Menu
Switching to a Mac has its advantages but Excel shortcuts isn’t one of them. The main gripe I have is that keyboard shortcuts should be the same in every version of Excel, yet the Windows and Mac worlds are light-years apart. The F2 key is a fundamental shortcut I learned early in my Excel life. It edits the active cell and positions the cursor at the end of the cell contents.
You want to edit a formula, hit the F2 key. But wait! In Excel for Mac the F2 key cuts text from the active cell. How could they do this? What were they thinking? Window users are screwed when it comes to keyboard shortcuts in Excel for Mac. Remember that well.
Edit the Active Cell in Excel for Mac
CONTROL+U is the new F2 when you’re using Excel with a Mac. If you want to edit the active cell use the keyboard shortcut CONTROL+U.
Not sure what this does but on Mac, Alt keys actually puts in special character Shift+F2. Insert comment. This works in Mac Excel Alt+E, S, T. Opens the edit menu, then s choose paste specials and then format. You have to get this with Quickeys Control + 1. Format Cells. Need to change in the Excel Keyboard Shortcuts since it is select object on the Mac and format cells is command-1. Split from this thread. And moved to Excel Do you know how to do this in Office for Mac 2016, excel specifically, as I do a merge and center the left align the cell. What is the keyboard shortcut for Merge Cells in an Excel table? Split from this thread. And moved to Excel. You cannot assign custom keyboard shortcuts in Excel.
If you use F2 to edit a cell on a Mac, remember your screwed, and think FU. Then take control of the situation and use CONTROL+U to edit that cell and get on with your life.
Today in this article, we have compiled Excel 2011 Keyboard shortcuts for MAC for our readers.
As we know today use of smartphones, tablets and smart PC has increased. Similarly, use of MAC based PC and laptops of Apple Inc. has also increased.
Earlier, there were very few peoples using the products with MACINTOSH. Now it has subsequently increased.
Microsoft Excel was and is still one of the most used spreadsheet software over the internet.
Though other software like R, Python etc are introduced, for different purposes like data analytics, data management etc.
Excel has maintained its importance. Web research, data management and data analysis are still done on it. You cannot find any finance or accounts department withoutt excel.
Even users with a basic know-how of Excel can become more efficient by learning keyboard shortcuts. Shortcut keys are most useful and powerful way to save the time.
The Microsoft Excel 2011 Keyboard Shortcuts help to provide an easier and usually quicker method of directing and finishing commands. They are commonly accessed by using the Option, Control, Shift, Function key and Command key.
You can find the Microsoft Excel shortcut keys for Windows in our previous article, “Complete List of Excel Shortcuts – 109 Shortcuts”
By using these shortcuts you can save your time and increase the productivity as well. You can print this page or you can download here.
List of Microsoft Excel 2011 Keyboard Shortcuts
⌘ + O | Open File |
---|---|
⌘ + N | New File |
⌘ + P | |
⌘ + S | Save File |
F12 | Save File As |
⌘ + W | Close File |
⌘ + Q | Close Excel |
Esc | Exit Dialog |
⌘ + C | Copy |
⌘ + X | Cut |
⌘ + V | Paste |
⌘ + Z | Undo |
⌘ + Y | Redo |
⌘ + A | Select All |
⌘ + F | Find |
Ctrl + H | Replace |
⌘ + Tab | Switch Windows |
⌘ + , | Options Menu |
⌘ + Option + R | Show/Hide Ribbon Menu |
Ctrl + Spacebar | Select Column |
Shift + Spacebar | Select Row |
Ctrl + I | Insert Cells / Rows / Columns |
Ctrl + – | Delete Cells / Rows / Columns |
Right Mouse | Insert Cut Cells and Shift Over Group Rows / Columns |
Right Mouse Button + E | Insert Cut Cells and Shift Over |
⌘ + Shift + K | Group Rows / Columns |
Shift + Alt + Right | Group Rows / Columns |
⌘ + Shift + J | Ungroup Rows / Columns |
Shift + Alt + Left | Ungroup Rows / Columns |
Ctrl + 0 | Hide Columns |
Ctrl + Shift + 0 | Show Columns |
Ctrl + 9 | Hide Rows |
Ctrl + Shift + 9 | Show Rows |
⌘ + 1 | Format Dialog |
⌘ + Ctrl + V | Paste Special |
⌘ + Ctrl + V, ⌘ + T | Paste Formats |
⌘ + Ctrl + V, ⌘ + V | Paste Values |
⌘ + Ctrl + V, ⌘ + F | Paste Formulas |
⌘ + L | Align left |
⌘ + E | Align Center |
⌘ + R | Align Right |
⌘ + 1, Alignment | Change Indent |
⌘ + B | Bold |
⌘ + I | Italics |
⌘ + U | Underline |
⌘ + Shift + _ | Strikethrough |
⌘ + Alt + 0 | Add Borders |
⌘ + Alt + – | Delete Borders |
Shift + Ctrl + ~ | General |
Shift + Ctrl + ! | Number |
Shift + Ctrl + @ | Time |
Shift + Ctrl + # | Date |
Shift + Ctrl + $ | Currency |
Shift + Ctrl + % | Percentage |
Shift + Ctrl + ^ | Scientific |
⌘ + ; | Current Time |
Ctrl + ; | Current Date |
Ctrl + ⌘ + Mouse Scroll Wheel | Zoom |
= | Enter Formula |
F9 | Refresh All |
⌘ + T | Anchor Cell |
Ctrl + L | Name Cell |
F5 | Jump to Cell |
Tab | Use Suggested Name |
Shift + F3 | Enter Built-In Function |
⌘ + Ctrl + V, ⌘ + F | Paste Formulas |
⌘ + Ctrl + V, ⌘ + R | Paste Formats & Formulas |
Ctrl + D | Copy Down |
Ctrl + R | Copy Right |
Ctrl + ’ | Copy from Above |
F5, ⌘ + S, ⌘ + F | Go to Formulas |
F5, ⌘ + S, ⌘ + O | Go to Constants |
Ctrl + ~ | Show Formulas |
⌘ + Shift + T | Sum Adjacent Cells |
Ctrl + Shift +Enter | Array Enter Function |
Ctrl + [ | Immediate Precedents |
Ctrl + ] | Immediate Dependents |
Shift + Ctrl + { | All Precedents |
Shift + Ctrl + } | All Dependents |
F5 + Enter | Jump to Original Cell |
Shift + F2 | Add/Edit Comment |
Shift + F2 + Del | Del Comment |
F5, ⌘ + S, ⌘ + C | Highlight Cells w/ Comments |
⌘ + Shift + R | Sort Data |
⌘ + Shift + F | Filter Data |
Right Mouse Button + E + V | Filter by Cell’s Properties |
Option + F8 | View Macros |
Most shortcuts that use the Ctrl key on a Windows keyboard also work with the Control key in Excel 2011 for Mac.
All the shortcut keys in this article refer to the US keyboard layout. Keys for other layouts will not correspond exactly to the keys as on a US keyboard.
Note: Sometimes a shortcut requires pressing two or more keys at the same time. To notify this we have used a “+” sign as a separator. If there are more than one shortcuts for one common action, they are given after the “,”.
It might happen that some function keys doesn’t work as they need to, then you need to press the FN key in addition to the function key.
You can change your Apple system preferences if you don’t want to press the FN key each time.
Steps for Changing System Preferences
To change function key preferences with the mouse
![2016 excel shortcuts cheat sheet 2016 excel shortcuts cheat sheet](/uploads/1/2/5/6/125699729/103938351.jpg)
1) On the Apple menu, press System Preferences.
2) Select Keyboard.
3) On the Keyboard tab, select the check box for Use all F1, F2, etc. keys as standard function keys.
We thank our readers for liking, sharing and following us on different social media platforms.
If you have any queries please share in the comment section below. I will be more than happy to assist you.