Sunday, August 9, 2020

Shortcuts to Make Selections in Excel


To do this action Press in Windows Press in Mac
Complete Cell Entry and Select Above Cell Shift+Enter ⇧ +Return
Extend Cell Selection Downward Shift+↓ ⇧ +↓
Extend Cell Selection to the Left Shift+← ⇧ +←
Extend Cell Selection to the Right Shift+→ ⇧ +→
Extend Cell Selection to the Top Ctrl+Shift+Home Fn+⌃ +⇧ +←
Extend Cell Selection Upwards Shift+↑ ⇧ +↑
Extend Selection to Last Bottom Cell Ctrl+Shift+↓ ⌃ +⇧ +↓
Extend Selection to Last Left Cell Ctrl+Shift+← ⌃ +⇧ +←
Extend Selection to Last Right Cell Ctrl+Shift+→ ⌃ +⇧ +→
Extend Selection to Last Top Cell Ctrl+Shift+↑ ⌃ +⇧ +↑
Fill Selected Cell Range with the Current Entry Ctrl+Enter ⌃ +Return
Redo Last Action Ctrl+Y ⌘ +Y
Undo Typing Ctrl+Z ⌘ +Z
Select All Objects when an Object is Selected Ctrl+Shift+Space
Select Current and Next Worksheet Ctrl+Shift+Pg Dn
Select Current and Previous Worksheet Ctrl+Shift+Pg Up
Select Current Array Ctrl+/ ⌃ +/
Select Current Region around the Cell Ctrl+Shift+* ⇧ +⌃ +Space
Select Differences in Columns Ctrl+Shift+| ⌃ +⇧ +|
Select Differences in Rows Ctrl+\ ⌃ +\
Select Entire Column Ctrl+Space ⌃ +Space
Select Entire Row Shift+Space ⇧ +Space
Select Entire Worksheet Ctrl+A ⌘ +A
Select First Command on Menu Home Fn+←
Select Only Visible Cells Alt+; ⌘ +⇧ +Z
Start a New Line in a Cell Alt+Enter ⌃ +⌥ +Return
Toggle Add to Selection Mode Shift+F8 Fn+⇧ +F8
Toggle Extend Mode F8 Fn+F8



For More Shortcuts (Click on the links below):

Excel Ribbon Tab Shortcuts for Windows

Formatting Cell Shortcuts in Excel

Inside the Ribbon Shortcuts in Excel

Frequently Used Keyboard Shortcuts For Mac & Windows in Excel

Excel Cell Navigation Shortcuts For Mac & Windows

Formula Shortcuts For Mac & Windows



No comments:

Post a Comment