Written by Puneet for Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019
Knowing and using Keyboard Shortcuts while using Excel is one of those Basic Excel Skills that can help you save a ton of time every day.
Command Windows Mac; Fit image on screen: Ctrl + 0: Command + 0: Zoom in: Ctrl + Command + Zoom out: Ctrl – Command – View / Hide extras: Ctrl + H: Command + H: Drag image with Hand Tool: Spacebar drag: Spacebar drag: Fit image in window: Double click Hand Tool: Double click Hand Tool: Rotate file: Press and hold R and use stylus. Press. If you're a long-time Mac user transitioning to a Windows keyboard, the Windows key, which is equivalent to the Mac's Command key, may occupy the physical position of the Option key on a Mac keyboard. Likewise, the Windows keyboard's Alt key is where you expect to find the Mac's Command key.
There are more than 500 keyboard shortcuts that you can use in Excel but the problem is not all of those can be helpful for you.
That's why I have listed only 82 most important keyboard shortcuts that you can learn and use easily.
If somehow you are not able to find a keyboard shortcut for the option that you use frequently in your work, you can use the following method to find.
Mac os 9 firefox. Here's the tip.
When you press the ALT key Excel shows you the keys that you can use to open the tab from the ribbon.
And when you press a key for a particular tab to open it further shows you the keys to open the options that you have on that tab, so one for further drop-downs.
Alt Commands For Symbols
Go to Library module. Command + Option + 1. Go to Develop module. Command + Option + 2. Go to Map module. Excel ribbon in Windows with accelerator keys visible. No equivalent on the Mac! Note: Accelerator Keys is a commercial product that makes it possible to drive the ribbon with the Alt/Option key using Accessibility features on Mac OS. Requires Catalina (10.15) or higher. Finally, some Excel shortcuts are just plain different.
Tips to make best out of this shortcut cheat sheet
- Replace your 10 most used options with shortcuts.
- Make your fingers learn the shortcut keys.
Download the Cheat Sheet (PDF)
Alt Commands Microsoft Word
Basic Keys
Formatting Keys
Insert & Layout Keys
Functions and Data Shortcuts
Basic Keys
Formatting Keys
Insert & Layout Keys
Functions and Data Shortcuts
My Favorite Keyboard Shortcuts
More Tutorials for YOU
- Consolidate Data From Multiple Worksheets / Merge Excel Files
About the Author
Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.
