Moving Within a Worksheet

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.

graphics/63fig02.jpg

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.

graphics/tip_icon.gif

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)

graphics/tip_icon.gif

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.



Microsoft Office 2003 All-in-One
Microsoft Office 2003 All-in-One
ISBN: B005HKSHB2
EAN: N/A
Year: 2002
Pages: 660
Authors: Joe Habraken

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net