For Seniors: How to Understand Excel Functions
For Seniors: How to Use Common Excel Functions
For Seniors: How to Identify the Parts of an Excel Chart

For Seniors: How to Move around an Excel Worksheet

You can move around a Microsoft Excel worksheet using the cell cursor (also called the active cell indicator). The cell cursor is the dark outline around the active cell. To change which cell is active, you can do either of the following:

image0.jpg
  • With your mouse: Click the cell you want to be active.

  • From the keyboard: Press one of the arrow keys on the keyboard to move the cell cursor one cell at a time in the direction the arrow is pointing until you reach the cell you want to be active.

The following table provides more shortcuts for moving the cell cursor within a worksheet.

Movement Shortcuts
Press This . . . To Move . . .
Arrow keys One cell in the direction of the arrow
Tab One cell to the right
Shift+Tab One cell to the left
Ctrl+any arrow key To the edge of the current data region in a worksheet (the first or last cell that isn’t empty)
End To the cell in the lower-right corner of the window(This works only when the Scroll Lock key has been pressed on your keyboard to turn on the Scroll Lock function.)
Ctrl+End To the last cell in the worksheet, in the lowest used row of the rightmost used column
Home To the beginning of the row containing the active cell
Ctrl+Home To the beginning of the worksheet (cell A1)
Page Down One screen down(The cell cursor moves, too.)
Alt+Page Down One screen to the right
Ctrl+Page Down To the next sheet in the workbook
Page Up One screen up(The cell cursor moves, too.)
Alt+Page Up One screen to the left
Ctrl+Page Up To the previous sheet in the workbook
  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus
For Seniors: How to Create a Basic Excel Chart
For Seniors: How to Fill Color in Microsoft Excel
For Seniors: Get Familiar with Spreadsheet Structure in Microsoft Excel
For Seniors: How to Move and Copy Cell Content in an Excel Worksheet
For Seniors: How to Use Multiple Excel Worksheets
Advertisement

Inside Dummies.com