Create a keyboard shortcut in Excel for Mac. On the Tools menu, click Customize Keyboard. In the Categories list, click a tab name. In the Commands list, click the command that you want to assign a keyboard shortcut to. Any keyboard shortcuts that are currently assigned to the selected command will appear in the Current keys box.
.Excel 2016 for Mac uses the function keys for common commands, including Copy and Paste. For quick access to these shortcuts, you can change your Apple system preferences so you don't have to press the FN key every time you use a function key shortcut. 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. 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. Special symbols. One of more confusing aspects of keyboard shortcuts on the Mac are the symbols. Excel keyboard shortcuts (Windows and Mac) File. Create new workbook.
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.
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.
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.
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)
Basic Keys
Formatting Keys
Insert & Layout Keys
Functions and Data Shortcuts
My Favorite Keyboard Shortcuts
Excel Shortcuts On Mac Keyboard
More Tutorials for YOU
- Consolidate Data From Multiple Worksheets / Merge Excel Files
Excel Key Shortcuts For Mac Windows 10
About the Author
Excel Keyboard Shortcuts Pdf
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.