Reader's Question

Microsoft Excel 2011 Keyboard Shortcuts for MAC

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

⌘ + OOpen File
⌘ + NNew File
⌘ + PPrint
⌘ + SSave File
F12Save File As
⌘ + WClose File
⌘ + QClose Excel
EscExit Dialog
⌘ + CCopy
⌘ + XCut
⌘ + VPaste
⌘ + ZUndo
⌘ + YRedo
⌘ + ASelect All
⌘ + FFind
Ctrl + HReplace
⌘ + TabSwitch Windows
⌘ + ,Options Menu
⌘ + Option + RShow/Hide Ribbon Menu
Ctrl + SpacebarSelect Column
Shift + SpacebarSelect Row
Ctrl + IInsert Cells / Rows / Columns
Ctrl + –Delete Cells / Rows / Columns
Right MouseInsert Cut Cells and Shift Over Group Rows / Columns
Right Mouse Button + E
Insert Cut Cells and Shift Over
⌘ + Shift + KGroup Rows / Columns
Shift + Alt + RightGroup Rows / Columns
⌘ + Shift + JUngroup Rows / Columns
Shift + Alt + LeftUngroup Rows / Columns
Ctrl + 0Hide Columns
Ctrl + Shift + 0Show Columns
Ctrl + 9Hide Rows
Ctrl + Shift + 9Show Rows
⌘ + 1Format Dialog
⌘ + Ctrl + VPaste Special
⌘ + Ctrl + V, ⌘ + TPaste Formats
⌘ + Ctrl + V, ⌘ + VPaste Values
⌘ + Ctrl + V, ⌘ + FPaste Formulas
⌘ + LAlign left
⌘ + EAlign Center
⌘ + RAlign Right
⌘ + 1, AlignmentChange Indent
⌘ + BBold
⌘ + IItalics
⌘ + UUnderline
⌘ + Shift + _Strikethrough
⌘ + Alt + 0Add 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
F9Refresh All
⌘ + TAnchor Cell
Ctrl + LName Cell
F5Jump to Cell
TabUse Suggested Name
Shift + F3 Enter Built-In Function
⌘ + Ctrl + V, ⌘ + FPaste Formulas
⌘ + Ctrl + V, ⌘ + RPaste Formats & Formulas
Ctrl + DCopy Down
Ctrl + RCopy Right
Ctrl + ’Copy from Above
F5, ⌘ + S, ⌘ + FGo to Formulas
F5, ⌘ + S, ⌘ + OGo to Constants
Ctrl + ~Show Formulas
⌘ + Shift + TSum Adjacent Cells
Ctrl + Shift +EnterArray Enter Function
Ctrl + [Immediate Precedents
Ctrl + ]Immediate Dependents
Shift + Ctrl + {All Precedents
Shift + Ctrl + }All Dependents
F5 + EnterJump to Original Cell
Shift + F2 Add/Edit Comment
Shift + F2 + DelDel Comment
F5, ⌘ + S, ⌘ + CHighlight Cells w/ Comments
⌘ + Shift + RSort Data
⌘ + Shift + FFilter Data
Right Mouse Button + E + VFilter by Cell’s Properties
Option + F8View 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.

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.

Shabbir Bhimani

I have worked in Excel and like to share functional excel templates at ExcelDataPro.

Share
Published by
Shabbir Bhimani

Recent Posts

Download UK VAT Taxable Turnover Calculator Excel Template

To simplify the process, we have created a simple and easy UK VAT Taxable Turnover…

4 years ago

Step By Step Guide TO UK VAT Registration Process

Every business has to register for VAT with HM Revenue and Customs if their VAT…

4 years ago

Download UK VAT Dual Currency Invoice Excel Template

We have created the UK VAT Dual Currency Invoice excel template with predefined formulas that…

4 years ago

Download UK VAT Purchase Register Excel Template

We have created a simple and easy UK VAT Purchase Register Excel Template with predefined…

4 years ago

Download UK VAT Sales Register Excel Template

We have created a simple and easy UK VAT Sales Register Excel Template with predefined…

4 years ago

Download UK VAT Progress Billing Invoice Excel Template

We have created a ready to use UK VAT Progress Billing Invoice template in excel…

4 years ago