Thursday, August 6, 2020

Frequently Used Keyboard Shortcuts For Mac & Windows in Excel


To do this action Press in Windows Press in Mac
Add Borders Ctrl+Shift+& ⌘ +⌥ +0
Add or Remove Filter Ctrl+Shift+L ⌘ +⇧ +F
Bold Ctrl+B ⌘ +B
Center Align cell Contents Alt+H+A+C ⌘ +E
Left Align cell Contents Alt+H+A+L ⌘ +L
Right Align Cell Contents Alt+H+A+R ⌘ +R
Choose a Fill Color Alt+H+H
Cut Ctrl+X ⌘ +X
Copy Ctrl+C ⌘ +C
Paste Ctrl+V ⌘ +V
Delete Column / Row Ctrl+- ⌘ +-
Insert Column / Row Ctrl++ ⌘ ++
Find Ctrl+F ⌘ +F
Replace Ctrl+H ⌃ +H
Find Next Match Shift+F4 ⌘ +G
Find Previous Match Ctrl+Shift+F4 ⌘ +⇧ +G
Hide Selected Column Ctrl+0 ⌃ +0
Unhide Columns Ctrl+Shift+0 ⌃ +⇧ +0
Hide Selected Rows Ctrl+9 ⌃ +9
Unhide Rows Ctrl+Shift+9 ⌃ +⇧ +9
Open Context Menu Shift+F10 Fn+⇧ +F10
New Workbook Ctrl+N ⌘ +N
Open Workbook Ctrl+O ⌘ +O
Close Workbook Ctrl+W ⌘ +W
Print Preview Ctrl+F2
Print Ctrl+P ⌘ +P
Remove Cell Contents Delete Fn+Delete
Save Workbook Ctrl+S ⌘ +S
Undo Ctrl+Z ⌘ +Z
Zoom In Ctrl+Alt++ ⌥ +⌘ ++
Zoom Out Ctrl+Alt+- ⌥ +⌘ +-



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

Excel Cell Navigation Shortcuts For Mac & Windows

Formula Shortcuts For Mac & Windows



No comments:

Post a Comment