Page 30 - Excel Workbook for Dummies

05_798452 ch01.qxp 3/13/06 7:52 PM Page 13
Chapter 1: Entering the Spreadsheet Data 13
If you use a mouse with a wheel button, scroll up and down the rows of the work-
sheet by rotating the wheel button forward (to scroll up) and backward (to scroll
down).
If you use a mouse with a wheel button, pan through the rows and columns of
the worksheet by clicking the wheel button and then dragging the triangular
mouse pointer in the direction you want to scroll.

Don’t forget that scrolling is not the same as selecting! After scrolling to a new part of
the worksheet in view, you still have to select a cell by clicking it to set the cursor in it.

Try It

Exercise 1-5: Moving the Cell Cursor to Distant Parts of the Worksheet

Practice moving the cell pointer to cells in unseen parts of Sheet1 in the Book1 work-
book by doing the following:

1. Move the cell cursor to cell C125 with the Name Box on the Formula Bar.
2. Move the cell cursor to cell CA125 using the horizontal scroll bar.
3. Move the cell cursor to cell CA63560 using the vertical scroll bar.
4. Move the cell cursor directly to cell A1 (the Home cell) in a single operation.
Hold down the Shift key to scroll quickly through columns and rows by dragging
the scroll box in the horizontal or vertical scroll bar.
After scrolling into view the region with the cell you want to select, you still need
to click the cell to select it.

Q. What’s the most efficient way to move A. Use the Ctrl key in combination with any of
between ranges of data that are spread out the four arrow keys to jump from occupied
across a worksheet? cell to occupied cell in a particular direction.

Try It

Exercise 1-6: Moving the Cell Cursor from Entry to Entry
Practice moving the cell pointer around a blank worksheet and between data entries
with the Ctrl key and the arrow keys in Sheet1 of Book1 by doing the following:

1. Press Ctrl+→, Ctrl+↓, Ctrl+←, and Ctrl+↑ in succession to jump the cell cursor
from A1 to IV1, IV1 to IV65536, IV65536 to A65536, and A65536 to back to A1
(when there are no occupied cells in a particular direction, the cursor jumps
right to the border of the worksheet).
2. Move the cell cursor to cell A18, type Stop, and press Ctrl+Home. Next, press
Ctrl+↓ (the cursor stops in A18 rather than A65536 because A18 is now occupied).
3. Move the cell cursor to cell AB18, type Stop Again, and press Home. Next, press
Ctrl+→ (the cursor stops in cell AB18 rather than IV18 because AB18 is now
occupied).
4. Press the Delete key, and then press Ctrl+← followed by the Delete key to remove
the two dummy cell entries. Press Ctrl+Home to put the cursor back in cell A1.