Shortcuts

In this segment, you will learn a lot about using shortcuts in Microsoft Excel.

Navigation Shortcuts

To navigate faster throughout the worksheet we should know all the Navigation Shortcuts

Command Windows Shortcuts Mac Shortcuts

Move one cell right

Move one cell left

Move one cell up

Move one cell down

Select cell one screen to the right of the active cell

Alt + PgDn

Fn + Alt + ↓

Select cell one screen to the left of the active cell

Alt + PgUp

Fn + Alt + ↑

Move one screen down

PgDn

Fn + ↓

Select the first/last cell of a region (non-blank cells) moving right

Ctrl + →

Ctrl + →

Select the first/last cell of a region (non-blank cells) moving down

Ctrl + ←

Ctrl + ←

Select the first/last cell of a region (non-blank cells) moving up

Ctrl + ↑

Ctrl + ↑

Select the first/last cell of a region (non-blank cells) moving down

Ctrl + ↓

Ctrl + ↓

Move to begin of row

Home

Fn + ←

Select the last used cell in the sheet

Ctrl + End

Fn + Ctrl + →

Select the first visible cell in the sheet

Ctrl + Home

Fn + Ctrl + Home

Turn End mode on (like Ctrl+Arrow Keys)

End

Fn + →

Go back to the hyperlink

Ctrl+G, Enter

Ctrl+G, Return