Windows XP Registry: A Complete Guide to Customizing and Optimizing Windows XP (Information Technologies Master Series)
| [ LiB ] |
You can use your mouse or keyboard to move around a worksheet. Because of the large size of an Excel worksheet, you need ways to move around quickly.
For illustration purposes, in the following two figures you see a worksheet with a lot of information stored in it. You will learn how to enter information into your worksheets in Chapter 2, "Creating a Simple Worksheet."
Using the Mouse
Because there are over 16 million possible cells in a single worksheet, you may find that using the mouse is an easy way to move around in the worksheet.
By default, Excel displays three worksheets, labeled Sheet1, Sheet2, and Sheet3.
You'll learn more about working with multiple worksheets in Chapter 8, "Working with Larger Worksheets."
| Keystroke | Result |
|---|---|
| Arrow keys | Moves one cell at a time up, down, left, or right |
| Page Down | Moves one screen down |
| Page Up | Moves one screen up |
| Home | Moves to column A of the current row |
| Ctrl+Home | Moves to cell A1 |
| Ctrl+Arrow key | Moves to the beginning or end of a row or column |
| Ctrl+Page Down | Moves to the next worksheet |
| Ctrl+Page Up | Moves to the previous worksheet |
| F5 | Displays the Go To dialog box which enables you to specify a cell address |
Using the Keyboard
As you have just discovered , you can use your mouse to move around an Excel worksheet; however, you may find using the keyboard faster and easier. The table shown here describes keyboard methods for moving around a worksheet.
Accessing the Go To Command
If you have a rather large worksheet, you can use the Go To command to jump to a specific cell or area of the worksheet.
NOTE
If you are using personalized menus , you may not immediately see the Go To command. Pause the mouse over the Edit menu to display the additional options.
NOTE
Optionally, press the F5 key to quickly display the Go To dialog box.
| [ LiB ] |