Contents

Know more about this
(or any other) subject?

Show off your know-how at Quamut Wiki.

Learn more with these titles from Barnes & Noble

Previous:
Shortcuts for Basic Excel Actions

Next:
Shortcuts for Selecting, Finding, and Replacing Cells, Text, and Data

Shortcuts for Navigating Excel Documents

Navigating Within a Worksheet

Action		Keyboard Shortcut
Move one cell to the left		Left Arrow (or Shift+Tab)
Move one cell to the right		Right Arrow (or Tab)
Move up one row		Up Arrow
Move down one row		Down Arrow
Move to the last occupied cell in a row		Ctrl+Right Arrow
Move to the first occupied cell in a row		Ctrl+Left Arrow
Move up to the next occupied cell in a column		Ctrl+Up Arrow (press again to step through occupied regions)
Move down to the next occupied cell in a column		Ctrl+Down Arrow (press again to step through occupied regions)
Scroll up one screen		Page Up
Scroll down one screen		Page Down
Move one screen to the left		Alt+Page Up
Move one screen to the right		Alt+Page Down
Move to the cell at the intersection of the rightmost occupied column and lowest occupied row		Ctrl+End
Move to the first cell (A1)		Ctrl+Home

Action		Keyboard Shortcut
Move to the next worksheet in the workbook		Ctrl+Page Down
Move to the previous worksheet in the workbook		Ctrl+Page Up
Change which open window is active		Ctrl+Tab
Skip to a specific object (such as a chart or graphic), comment, cell, or range of cells		Ctrl+G or F5

Previous:
Shortcuts for Basic Excel Actions

Next:
Shortcuts for Selecting, Finding, and Replacing Cells, Text, and Data

Download the PDF
for just $2.95

► Complete guide
► Handy, portable format