Today in this article, we have compiled Excel 2011 Keyboard shortcuts for MAC for our readers.
If you have a one-time purchase of Office for Mac 2011, you'll need a product key to activate. Find your product key for Office for Mac 2011. In the Get Started wizard, click Enter your purchased product key. Tip: If the wizard isn't open, start an Office application and click Activate Now.
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.
- Download microsoft word 2011 for mac for free. Productivity downloads - Microsoft Word by Microsoft and many more programs are available for instant and free download. KillerKeys VR is a desktop application providing a virtual (VR) on-screen keyboard that displays color-coded shortcuts on each key of the virtual keyboard.
- DO NOT BUY Microsoft Office Mac 2011 unless it comes with a valid product key. As sold by Microsoft the product key was not included in the package. Instead a one-time PIN was provided which could be used at the Microsoft website to obtain the product key. However, Microsoft ended support for Office 2011 in 2017, and the website has been.
Earlier, there were very few peoples using the products with MACINTOSH. Now it has subsequently increased.
Microsoft Office 2011 For Mac Key
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.
Nuke for mac os. 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.
Microsoft For Mac 2011 Download
Steps for Changing System Preferences
To change function key preferences with the mouse Free vpn servers for mac.
1) On the Apple menu, press System Preferences.
2) Select Keyboard.
Though other software like R, Python etc are introduced, for different purposes like data analytics, data management etc.
Nuke for mac os. 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.
Microsoft For Mac 2011 Download
Steps for Changing System Preferences
To change function key preferences with the mouse Free vpn servers for mac.
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.