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