| To enter your worksheet data, you need some way of moving to the various cells within the worksheet. Keep in mind that the part of the worksheet displayed onscreen is only a small piece of the actual worksheet. Using the Keyboard To move around the worksheet with your keyboard, use the key combinations listed in Table 6.1. Table 6.1. Moving Around a Worksheet with the Keyboard | To Move | Press This | | Up one cell | Up-arrow key | | Down one cell | Down-arrow key | | Right one cell | Right-arrow key | | Left one cell | Left-arrow key | | Up one screen | Page Up | | Down one screen | Page Down | | Leftmost cell in a row (column A) | Home | | Lower-right corner of the data area | Ctrl+End | | Cell A1 | Ctrl+Home | | Last occupied cell to the right of a row | End+right-arrow key | You can also quickly go to a specific cell address in a worksheet using the Go To feature. Press Ctrl+G (or select Edit , Go To ). Type the cell address you want to go to into the Reference box, and then click the OK button (see Figure 6.2). Figure 6.2. The Go To feature can be used to move to a specific cell address on the worksheet.  The Go To feature keeps a list of cells that you have recently moved to using the Go To feature. To quickly move to a particular cell in the Go To list, double-click that cell address.  | Even Faster Than Go To To move quickly to a specific cell on a worksheet, type the cell's address (the column letter and row number; for example, C25 ) into the Name box at the left end of the Formula bar and press Enter . |
Using a Mouse To scroll through a worksheet with a mouse, follow the techniques listed in Table 6.2. Table 6.2. Moving Around a Worksheet with the Mouse | To Move | Click This | | Move the selector to a particular cell | Any cell | | View one more row, up or down | Up or down arrows on the vertical scrollbar | | View one more column, left or right | Left or right arrows on the horizontal scrollbar | | Move through a worksheet quickly | The vertical or horizontal scrollbar; drag it up or down or right and left, respectively (as you drag, a ScreenTip displays the current row/column number) | | | Watch the Scroll Box The size of the scroll box changes to represent the amount of the total worksheet that is currently visible. If the scroll box is large, you know you're seeing almost all of the current worksheet in the window. If the scroll box is small, most of the worksheet is currently hidden from view. |
Using a Wheel-Enabled Mouse If you use a wheel-enabled mouse (like the Microsoft IntelliMouse), you can move through a worksheet even faster than you can by using the scrollbars and a conventional mouse. Table 6.3 shows how. Table 6.3. Moving Around a Worksheet with a Wheel-Enabled Mouse | To: | Do This: | | Scroll a few rows (scroll up and down) | Rotate the wheel in the middle of the mouse forward or backward. | | Scroll faster (pan) | Click and hold the wheel button, and then drag the mouse in the direction in which you want to pan. The farther away from the origin mark (the four-headed arrow) you drag the mouse, the faster the panning action. To slow the pan, drag the mouse back toward the origin mark. | | Pan without holding the wheel | Click the wheel once, and then move the mouse in the direction in which you want to pan. (You'll continue to pan when you move the mouse until you turn panning off by clicking the wheel again.) | | Zoom in and out | Press the Ctrl key as you rotate the middle wheel. If you zoom out, you can click any cell you want to jump to. You can then zoom back in so you can see your data. |  |
