MS Excel: navigation shortcuts for Windows, Mac, Web
- Fakhriddinbek
- May 5
- 2 min read
Efficient navigation is key to mastering Excel, especially when working with large datasets or multiple worksheets. Whether you're using Excel 2021 on Windows, Mac, or Excel for the Web, knowing the right shortcuts will save time and enhance your productivity.
Below is a handy reference table of the most common navigation shortcuts, helping you jump between cells, worksheets, and workbooks effortlessly—no matter the platform.
Comprehensive Navigation Shortcuts in Microsoft Excel 2021 (Windows, Mac, Web)
Action | Windows Shortcut | Mac Shortcut | Excel for Web Shortcut |
|---|---|---|---|
Move one cell up/down/left/right | Arrow Keys | Arrow Keys | Arrow Keys |
Jump to beginning of row | Home | Fn + Left Arrow | Home |
Jump to first cell (A1) | Ctrl + Home | Fn + Ctrl + Left Arrow | Ctrl + Home |
Jump to last cell with data | Ctrl + End | Fn + Ctrl + Right Arrow | Ctrl + End |
Move to next worksheet | Ctrl + Page Down | Fn + Cmd + Down Arrow | Ctrl + Page Down |
Move to previous worksheet | Ctrl + Page Up | Fn + Cmd + Up Arrow | Ctrl + Page Up |
Scroll one screen down/up | Page Down / Page Up | Fn + Down/Up Arrow | Page Down / Page Up |
Scroll one screen right/left | Alt + Page Down / Page Up | Ctrl + Fn + Right/Left Arrow | N/A |
Move to edge of data region | Ctrl + Arrow Key | Command + Arrow Key | Ctrl + Arrow Key |
Select to edge of data region | Ctrl + Shift + Arrow Key | Command + Shift + Arrow Key | Ctrl + Shift + Arrow Key |
Select entire column | Ctrl + Space | Ctrl + Space | Ctrl + Space |
Select entire row | Shift + Space | Shift + Space | Shift + Space |
Select entire worksheet | Ctrl + A (twice) | Command + A (twice) | Ctrl + A |
Go to a specific cell | Ctrl + G / F5 | Command + G / Fn + F5 | Ctrl + G |
Open Go To dialog | F5 | Fn + F5 | F5 |
Open Name Box | Ctrl + F3 | Ctrl + F3 | Ctrl + F3 |
Activate next open workbook | Ctrl + Tab | Command + ` | Ctrl + Tab |
Activate previous workbook | Ctrl + Shift + Tab | Command + Shift + ` | Ctrl + Shift + Tab |
Move between panes (split view) | F6 | Fn + F6 | F6 |
Move focus to ribbon | Alt or F10 | Control + Option + R | Alt or F10 |
Move to task pane | Ctrl + F1 | Command + Option + R | Ctrl + F1 |
Expand formula bar | Ctrl + Shift + U | Command + Shift + U | N/A |
Exit cell entry without changes | Esc | Esc | Esc |
Complete cell entry and stay in same cell | Ctrl + Enter | Command + Return | Ctrl + Enter |
Complete cell entry and move down | Enter | Return | Enter |
Complete cell entry and move up | Shift + Enter | Shift + Return | Shift + Enter |
Complete cell entry and move right | Tab | Tab | Tab |
Complete cell entry and move left | Shift + Tab | Shift + Tab | Shift + Tab |
Display context menu | Shift + F10 | Ctrl + Click | Shift + F10 |
Most navigation shortcuts remain consistent across Excel platforms, but Mac users often need to use the Fn key to access function keys, and Cmd instead of Ctrl.
Comments