To change your Mac keyboard settings to change the Show Desktop shortcut for the key. Change system preferences for keyboard shortcuts with the mouse 1. On the Apple menu, press System Preferences. In the tabs, press Shortcuts. Click Mission Control. Clear the check box for the keyboard shortcut that you want to use. A clear list of over 200 Excel shortcuts for both Windows and Mac, side-by-side. Windows shortcuts in dark gray on the left, Mac shortcuts in white on the right.
My frustration level is high with the learning curve associated with keyboard shortcuts in Excel 2011 so I decided to import them into a spreadsheet and found out that’s not happening. Since there’s more than one way to skin a cat (sorry cat lovers, just an expression) I decided to import them from the Office:Mac website to have at my beck and call whenever the need arises.
Different Methods of Getting External Data – Windows vs Mac
Excel 2010 has a From Web option to import data from a web page. As shown in my last blog post, this option works well in Windows versions of Excel – 2010 and 2007.
Not so in Excel 2011 where the only comparable option is to import data from an HTML file. And while this may work wonderful in many cases, trust me when I say that trying to import an HTML file from the Excel:Mac Help website doesn’t work well at all.
Locate the Excel 2011 Keyboard Shortcuts Webpage
Contrary to the Excel 2010 [Windows] Help system that defaults to showing data from Office.com, the Excel 2011 program for Mac defaults to showing Help content from your computer. Here’s how to locate the web page address or URL.
Excel 2011 For Mac Download
- Open Excel 2011
- Choose Help > Excel Help
- Click the Go Online button (top-right of screen)
- Close the Excel Help screen as it will dominate all windows
- Go to your web browser and locate the Excel Help page
- Type Excel Keyboard Shortcuts in the search box then press enter
- Click the link for Excel Keyboard Shortcuts
You now have the web page for Excel 2011 Keyboard Shortcuts.
Bookmark or Save a Local Copy?
Bookmarking this page in your web browser is prudent at this point. And maybe that’s sufficient for your purposes. Yet a bookmark is only good when you have online access.
I’m going to save this web page to my computer because of one simple reason: When using Help in Excel 2011 you can’t switch between Help and Excel without minimizing the Help window. By using the browser and a local copy of the web page you can view the keyboard shortcuts while offline, and switch back and forth between any program that’s open.
Save Excel 2011 Keyboard Shortcuts to Your Computer
I use the Firefox browser on my MacBook Pro, but dabble with Safari and Google Chrome, and have found some interesting differences. Not in the information, but rather the files saved to your computer.
Save with Firefox
Here are the steps I used to save this page to my hard drive with the Firefox web browser.
- Choose File > Save Page As…
- In the Save As dialog box, type a name you want for the web page in the Save As box
- Click the Save As drop-down box and select Web Page, complete
- Select the directory you want and click Save
You will see one HTML file and a folder with support files.
Save with Chrome
Here are the steps I used to save this page to my hard drive with the Chrome web browser.
- Choose File > Save Page As…
- Type a name in the Save As box (I left the default name)
- In the Where box select the location for the file
- Choose Web Page, Complete in the Format box
- Click Save
Again you get the HTML file and a folder with support files.
Save with Safari
Here are the steps I used to save this page to my hard drive with the Safari web browser.
- Choose File > Save As…
- Type a name in the Export As box (I left the default name)
- In the Where box select the Folder where you want the file to reside
- Click Save
There’s only one file saved, a webarchive file, and no support folder with files. Since I’m relatively new to Mac’s this was a revelation to me and immediately liked the idea of having only one file. Clean, neat, and easy to move. You don’t have to worry about any other files or folders.
Web File Location
If you’ve saved the file to your desktop your done. I saved my file to a Dropbox folder on my hard drive, which ensures that it will be saved to the cloud and synced to the hard drive of any computer I have installed Dropbox on. (Download and install Dropbox, where you get 2GB of free storage.)
Save an Alias to the Desktop
- Open Finder and locate the webarchive (Safari) or HTML (Firefox, Chrome) file you just downloaded
- Right click the file and select Make Alias
- Copy the Alias file to your Desktop and rename if desired
Now you can access the Excel 2011 Keyboard Shortcuts at anytime and not worry about the Help screen getting in your way.
Related posts:
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
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.
Microsoft Office Excel For Mac
We thank our readers for liking, sharing and following us on different social media platforms.
Ms Excel For Mac
If you have any queries please share in the comment section below. I will be more than happy to assist you.