 |
| Navigation Links |
 Step
1 |
| The Basics |
|
Moving around in Excel |
| The Ribbon Tabs |
| Page Setup |
| Entering data in Excel |
| Adding in Excel |
| More formulas |
| Saving |
| Three things to know |
| Text Version |
Welcome to Excelling with Excel 2007
Moving around in Excel
So far so good, you now know what a cell address is, how to use the
scrollbars and you should be practicing naming workbooks and work sheets.
I will be looking for named sheets and workbooks in all your projects.
There are several ways to move around in Excel:
- tab key
- enter key
- arrow keys
- TRY IT
- be in cell A1 - check to be sure you are there by checking the cell address area
- tab, tab, tab - what cell did you end with?
- now, move using the arrow keys on your keyboard.
- click on cell H4 - type the number 1 (USE THE NUMERIC KEYPAD, good Excel users use the numeric keypad - no exceptions!)
- enter - what cell are you on now?
- let me see the answers to the questions
- Do you see the difference in moving with the tab, arrows and enter key? The tab key moves you cell by cell, the enter key drops you down a row and the arrow keys move you in the direction of the arrow.
- Something to memorize - click on cell G84. To go back to the beginning of the spreadsheet immediately, hold down the control (ctrl) key and select the home key. You will be back at A1.
TIP: use the numeric keypad, this must be important.
It has been mentioned several times. BUT, to be sure you can work with
the numeric keypad the num lock key should be on.
How do you know if the num lock key is on? There is usually a little green
light above the words num lock.
Where is the num lock key?
- The num lock key is found on the numeric keypad - at the top of the numeric keypad just above the number 7.
- Show me a picture.
And onto another basic - the Ribbon Tabs.
