Wednesday, August 5, 2020

Excel Cell Navigation Shortcuts For Mac & Windows


To do this action Press in Windows Press in Mac
Cycle Through Text Boxes / Images Ctrl+Alt+5
Enter the End Mode End Fn+→
Exit Navigation of Text Boxes / Images Esc Esc
Extend Selection of Cells to Last Used Cells Ctrl+Shift+End Fn+⌃ +⇧ +→
Move One Cell Down ↓ ↓
Move One Cell Left ← ←
Move One Cell Right → →
Move One Cell Up ↑ ↑
Move One Screen Down in a Worksheet Pg Dn Fn+↓
Move One Screen Left in Worksheet Alt+Pg Up Fn+⌥ +↑
Move One Screen Right in Worksheet Alt+Pg Dn Fn+⌥ +↓
Move One Screen Up in a Worksheet Pg Up Fn+↑
Move to Beginning of a Worksheet Ctrl+Home Fn+⌃ +←
Move to Cell in the Upper Left Corner Home+Scr Lk Fn+⌃ +←
Move to Left Edge of Data Region Ctrl+← ⌃ +←
Move to Right Edge of Data Region Ctrl+→ ⌃ +→
Move to Top Edge of Data Region Ctrl+↑ ⌃ +↑
Move to Bottom Edge of Data Region Ctrl+↓ ⌃ +↓
Move to Last Cell on a Worksheet Ctrl+End Fn+⌃ +→
Move to the Next Cell (Right Side) Tab Tab
Move to the Previous Cell Shift+Tab ⇧ +Tab
Move to the Next Sheet in Workbook Ctrl+Pg Dn Fn+⌃ +↓
Move to the Previous Sheet in Workbook Ctrl+Pg Up Fn+⌃ +↑
Open List of Choices (Drop-down) on a Cell Alt+↓ ⌥ +↓
Show "Go to" Dialog Ctrl+G ⌃ +G


For More Shortcuts (Click on the links below):

Excel Ribbon Tab Shortcuts for Windows

Shortcuts to Make Selections in Excel

Formatting Cell Shortcuts in Excel

Inside the Ribbon Shortcuts in Excel

Frequently Used Keyboard Shortcuts For Mac & Windows in Excel

Formula Shortcuts For Mac & Windows



No comments:

Post a Comment