Excel Shortcuts for Mac I need shortcuts for mac excel, but all online forums use F2 or buttons that aren't really on a mac anymore. For instance, insert a comment is shift F2, but that doesn't really work for my mac. Mac shortcut for line feed: Control + Option + Return or Control + Command + Return; In Excel 365 for Mac, you can also use Option + Return. Option is the equivalent of the Alt key on Windows, so it seems the original Windows shortcut (Alt + Enter) now works for Mac too. If it does not work for you, then try the traditional Mac shortcuts above. If you switched to the Mac from a PC, check out the Apple Support article Mac tips for Windows switchers for a list of Mac keyboard shortcuts and the differences between Mac and Windows keyboards. For more keyboard shortcuts, see the Apple Support article Mac keyboard shortcuts.
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
More Tutorials for YOU
- Consolidate Data From Multiple Worksheets / Merge Excel Files
About the Author
Ms Excel Shortcut List
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.