Moving around the Worksheet Screen

[ 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 ]