- Go to 'Press new shortcut key' and type in a new shortcut. I used Command + Shift + v. And, click on 'Add'. Close the window. Now i can just use the normal copy ( Command + c) the cells from which i want to copy the formatting. Then go the cell where i want to paste the format and hit the keyboard shortcut (Command + Shift + v).
- Learn the basics of using Microsoft Excel for Mac, including the anatomy of a spreadsheet, how to enter data, how to make your data look good so it's easier.
- Excel Shortcuts List for Mac and PC (Searchable) How to Use this Shortcut List: + Indicates to hold the previous key, while pressing the next key. Indicates to tap the previous key, releasing it before pressing the next key. Find the shortcuts list below: # Description.
- Microsoft Office Excel For Mac
- Excel Keyboard Shortcuts Mac
- Excel For Mac Shortcuts 2011 Mac
- Excel Mac 2011 Shortcuts
- Ms Excel For Mac
- Excel Shortcuts For Mac Pdf
- Excel For Mac Shortcuts 2011 Key
Today in this article, we have compiled Excel 2011 Keyboard shortcuts for MAC for our readers.
Keyboard shortcuts on your Mac. You can press key combinations to do things on your MacBook Air that you’d normally do with a trackpad, mouse, or other device. Here’s a list of commonly used keyboard shortcuts. Cut the selected item and copy it to the Clipboard.
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.
Microsoft Office Excel 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.
Excel Keyboard Shortcuts Mac
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
Excel For Mac Shortcuts 2011 Mac
1) On the Apple menu, press System Preferences.
![For For](/uploads/1/3/4/8/134843906/742566918.jpg)
Excel Mac 2011 Shortcuts
2) Select Keyboard.
Ms Excel For Mac
3) On the Keyboard tab, select the check box for Use all F1, F2, etc. keys as standard function keys.
Excel Shortcuts For Mac Pdf
We thank our readers for liking, sharing and following us on different social media platforms.
Excel For Mac Shortcuts 2011 Key
If you have any queries please share in the comment section below. I will be more than happy to assist you.