Navigating and Selecting Cells

Worksheets and Workbooks View Row and Column Selection Ribbon Control Pivot Tables Operating within a Cell Navigating and Selecting Cells Help and Menus Group Selection General Excel General Cell Control Formulas and Functions Formatting Text and Numbers Dialog Boxes Borders Advanced Selection Adding Content to Cells

Use your keyboard to navigate to any cell you wish. These shortcuts will enable you to select everything from words to individual data points and characters.

To do this

Windows keys

Mac keys

Move one cell right

→

►

Move one cell left

←

◄

Move one cell up

↑

▲

Move one cell down

↓

▼

Move one screen right

Alt PgDn

Fn Option ▼

Move one screen left

Alt PgUp

Fn Option ▲

Move one screen up

PgDn

Fn ▲

Move one screen down

PgUp

Fn ▼

Move to the right edge of data range

Ctrl →

Control ►

Move to the left edge of data range

Ctrl ←

Control ◄

Move to the top edge of data range

Ctrl ↑

Control ▲

Move to the bottom edge of data range

Ctrl ↓

Control ▼

Navigate to the cell in the left most column of the current row

Home

Fn ◄

Navigate to the last cell in a data range

Ctrl End

Fn Control ►

Move to first cell of data range

Ctrl Home

Fn Control ◄

Activate "end" mode

End

Fn ►

Select active cell only

Shift Backspace

Shift Delete

Show active cell

Ctrl Backspace

⌘ Delete

Move selection down

Return

Enter

Move selection up

Shift Return

Move selection right

Tab

Move selection left

Shift Tab

Worksheets and Workbooks

View

Row and Column Selection

Ribbon Control

Pivot Tables

Operating within a Cell