Microsoft Office Tutorials and References
In Depth Information
Moving Around the Excel Screen
Moving Around the Excel Screen
Each worksheet in Excel has more than
17 billion individual cells. Luckily, Excel offers
several methods using your mouse, your
keyboard, and even the Ribbon for moving around
them all. Depending on how you use Excel, you
may find that you will use all three methods.
Using the Keyboard
Arguably the easiest, but surely the most
common, way to move around an Excel worksheet is
by using the keyboard. Table 1-1 displays some
of the ways you can use the keyboard to move
around an Excel workbook.
Table 1-1
Keystroke Movement in Excel
Keystroke
Movement
Arrow keys
Moves one cell at a time in the direction of the arrow
Tab
Moves one cell right
Shift+Tab
Moves one cell left
Enter
Moves one cell down
Shift+Enter
Moves one cell up
Page Up
Moves one full screen up in the current column
Page Down
Moves one full screen down in the current column
Home
Moves to the first cell in column A of the current row
Ctrl+Home
Moves to first cell in the spreadsheet, cell A1
Ctrl+End
Moves to the last cell in the spreadsheet that has any data in it
Alt+Page Down
Moves right one screen in the current row
Alt+Page Up
Moves left one screen in the current row
Ctrl+Arrow key
Moves to the next adjacent cell that contains data, depending on the direction
of the arrow
Ctrl+Page Down
Moves to the next worksheet (see Figure 1-9)
Ctrl+Page Up
Moves to the previous worksheet
 
 
Search JabSto ::




Custom Search