Tweaks and Tricks Saving time navigating in Excel 2003 : Tweaks and Tricks Saving time navigating in Excel 2003 Joe Alford
Computer Support Specialist
Excel 2003 Cell & Worksheet Navigation : Excel 2003 Cell & Worksheet Navigation Jump Directly to a Given Cell
SUMMARY: Quickly focus on a specific cell in a Microsoft Excel 2003
worksheet with this keyboard shortcut. Need to jump directly to a specific cell in a Microsoft Excel 2003 worksheet and
don't want to use the mouse or cursor keys?1. Select "Edit" - "Go To" or use the keyboard shortcut CONTROL+G.2. The "Go To" dialog box will appear. Underneath "Reference",
enter the reference to the desired cell. For example, to go to the cell at row A,
column 10, just enter $A$10. To switch between worksheets, enter the worksheet name, an exclamation point,
and then the rest of the cell reference. For example, to go to worksheet "Sheet 3"
and focus on the cell at row J, column 22, enter Sheet3!$J$22.3. Press ENTER or the "OK" button to jump to the desired cell.
Excel 2003 Cell & Worksheet Navigation : Excel 2003 Cell & Worksheet Navigation Jump to the First or Last Row or Column
SUMMARY: Keyboard shortcut in Microsoft Excel 2003 to skip to the first or last column or row in a worksheet. While navigating a Microsoft Excel 2003 worksheet, do you ever need to
navigate to the first cell in a given row or the first row in a given column?
Perhaps the first row or column explains more information about the numbers
in a given row or column, such as that a row represents money earned in a
particular day or that a given column represents a type of tax-deductible expense.Instead of using the scroll bars or holding down the cursor keys,
the following shortcuts will work:HOME or CONTROL+LEFT ARROW - First column in the rowCONTROL+UP ARROW - First row in the columnThough not as useful except for extremely large spreadsheets, you can
also use the following shortcuts to navigate:CONTROL+RIGHT ARROW - Access column IV in the current rowCONTROL+DOWN ARROW - Access row 65,526 in the current column
Excel 2003 Cell & Worksheet Navigation : Excel 2003 Cell & Worksheet Navigation Jump to the Beginning or End of a Worksheet
SUMMARY: Keyboard shortcut in Microsoft Excel 2003 to navigate to the
beginning or end of the current worksheet. Need to quickly jump to the beginning or end of your Microsoft Excel 2003
worksheet? You don't need the scroll bars. You also don't need to endlessly
hold down the cursor keys, neither. Just use the following keyboard shortcuts.
Hold down the CONTROL key while pressing one of the following keys:HOME:Beginning of worksheetEND: End of worksheet
Excel 2003 Cell & Worksheet Navigation : Excel 2003 Cell & Worksheet Navigation Jump Between Sheets in a Workbook
SUMMARY: Microsoft Excel 2003 keyboard shortcut to switch
between worksheet tabs. Need to regularly switch your focus between different worksheets
in a Microsoft Excel 2003 workbook? You don't have to use the mouse
to click on different tabs; use the following keyboard shortcuts:CONTROL+PAGE DOWN - Switch to the next worksheetCONTROL+PAGE UP - Switch to the previous worksheet
Excel 2003 Cell & Worksheet Navigation : Excel 2003 Cell & Worksheet Navigation Automatically Convert Keyed Numbers to Currency
SUMMARY: Need to enter a huge series of dollar amounts into a Microsoft Excel 2003 spreadsheet?
This tweak can save you from typing the periods between dollars and cents. If you need to key in a huge selection of currency values into your Microsoft Excel 2003 spreadsheet,
not having to key in the decimal point can save you many keystrokes.
You can tweak Microsoft Excel 2003 to automatically add decimal points to all numbers entered.
For example, after performing this tweak, if you key in the following:1123456122055Microsoft Excel 2003 will automatically convert the above to:11.23456.122.050.051. Click "Tools", selecting "Options".2. When the "Options" multi-tabbed dialog box appears, click the "Edit" tab.3. Check "Fixed decimal".4. Next to "Places", you can customize the number of decimal places for all keyed numbers,
if desired. For currency this should remain "2", but if you are typing in other types of information
that requires decimal places to the thousandths or ten-thousandths, for example,
change this number to "3" or "4", respectively. 5. Click "OK" to close the dialog box.To later disable this functionality, repeat the above steps but uncheck "Fixed decimal".
Excel 2003 Cell & Worksheet Navigation : Excel 2003 Cell & Worksheet Navigation Change the Default Font
SUMMARY: Change Microsoft Excel 2003's spreadsheet cell default font. Normally, Microsoft Excel 2003 uses a default font of Arial 10-point
whenever you create a new spreadsheet. While you can change the
current font at any time by clicking on the font and font size pull-downs
in the toolbar, if you commonly use a different font you can change
the default for future spreadsheets.1. Click "Tools" - "Options".2. When the "Options" multi-tabbed dialog box appears, click the "General" tab.3. Next to "Standard font", click the pull-down to the right to change
the default font. Click the pull-down to the right of that to choose
the default font size.4. Click "OK" to close the dialog box.
Excel 2003 Cell & Worksheet Navigation : Excel 2003 Cell & Worksheet Navigation Shrink Values to Fit in a Cell
SUMMARY: Force large values to fit inside a small cell of a Microsoft Excel 2003 spreadsheet. When developing a Microsoft Excel 2003 spreadsheet, there may be times where values
do not perfectly fit inside a cell, based on the limited width of a particular column.
While Excel 2003 will try its best to display the most significant portion of a value,
if a cell's width is too small, the value will just be replaced with ####. You can force Excel 2003 to display large value by altering the font size of the particular cell.
Or, change this setting and Excel 2003 will automatically alter the cell's font size
as needed depending on the cell width:1. Right-click on the cell or cells and choose "Format Cells".2. When the "Format Cells" multi-tabbed dialog box appears, click the "Alignment" tab.3. Check "Shrink to fit".4. Click "OK" to close the dialog box.Note that if the value is especially large or the cell width especially small, it may be very
difficult to read the text, either on the screen or in a printout.