Microsoft Office Tutorials and References
In Depth Information
Navigating a Spreadsheet
Table 8-1
Using the Keyboard to Navigate a Spreadsheet
Pressing This
Does This
Up arrow (
)
Moves up one row
Down arrow (
)
Moves down one row
Left arrow (
)
Moves left one column
Right arrow (
)
Moves right one column
Ctrl+
Jumps up to the top of a column that contains data
Ctrl+
Jumps down to the bottom of a column that contains data
Ctrl+
Jumps to the left of a row that contains data
Ctrl+
Jumps to the right of a row that contains data
Page Up
Moves up one screen
Page Down
Moves down one screen
Ctrl+Page Up
Displays the previous worksheet
Ctrl+Page Down
Displays the next worksheet
Home
Moves to the A column of the current row
Ctrl+Home
Moves to the A1 cell
Ctrl+End
Moves to the bottom-right cell of your spreadsheet
If you know the specific cell you want to move to, you can jump to that cell
by using the Go To command. To use the Go To command, follow these
steps:
1. Click the Home tab.
2. Click the Find & Select icon in the Editing group.
A pull-down menu appears.
3. Click Go To.
The Go To dialog box appears, as shown in Figure 8-11.
You can also choose the Go To command by pressing Ctrl+G.
4. Click in the Reference text box and type the cell you want to move to,
such as C13 or F4.
5. Click OK.
Excel highlights the cell you typed in Step 4.
 
Search JabSto ::




Custom Search