Skip to content
Ash RoyOct 31, 2013 6:09:38 AM2 min read

Microsoft Excel for Mac 2011 Keyboard Shortcuts

If you haven’t been using keyboard shortcuts on your Mac then you’re in for a treat! Depending on how long you spend on your computer each day you could be saving yourself HOURS each week!

If you want a 30-minute video coaching session then just click here to book a call right now. This offer is only available for a limited time so hurry and set yourself up for an epic 2020!

This post covers keyboard shortcuts specifically on Excel For Mac 2011. You might also want to check out these 45 Insanely useful Mac OSX Keyboard Shortcuts to save you over an hour each week to find quicker ways to navigate around your Mac in general.

If you’re a PC user then check out these 57 Keyboard Shortcuts that will turn you into a Microsoft Excel ninja!

You’re about to find some incredible time-saving hacks that will transform future interactions with your Mac computer.

So strap on your seat belt and brace yourself. You’re about to hit warp speed!

Check out these exceptional keyboard shortcuts on Microsoft Excel for Mac 2011

Working in cells or the formula bar

Repeat the last Action: ⌘+Y

Display  autocomplete list : CONTROL+OPTION+DOWN ARROW

Enter the time :⌘+SEMICOLON (;)

Enter the date : CONTROL+SEMICOLON (;)

Start a formula :  =

Edit the active cell : CONTROL+U

Insert a hyperlink : ⌘+K

Previewing and Printing

Display the Print dialog box :  ⌘+P

Move around in print view : Arrow keys

 

Moving and scrolling on a sheet

 

Move to the edge of the current data region : CONTROL + arrow key

Move to the beginning of the row : HOME

Move to the beginning of the sheet : CONTROL+HOME

Working with a selection

Copy the selection : ⌘+C

Cut the selection : ⌘+X

Paste the selection : ⌘+V

Undo the last action : ⌘+Z

Formatting and editing data

Display the Style dialog box : ⌘+SHIFT+L

Display the Format Cells dialog box :  ⌘+1

Hide Rows : CONTROL+9

Unhide Rows : CONTROL+ZERO

Hide Columns :  CONTROL+SHIFT+(

Unhide columns: CONTROL+SHIFT+)

Edit the active cell : CONTROL+U

Apply or remove bold formatting : ⌘+B

Apply or remove italic formatting : ⌘+I

Apply or remove underscoring : ⌘+U

 

Copy and Paste Special  (paste only values or only formatting etc)

 

Copy and Paste Special Format ⌘+C ; and then  ^+⌘+V ; and then; ⌘+T

Copy and Paste Special Values – ⌘+C ; and then  ^+⌘+V ; and then; ⌘+V

Copy and Paste Special Formulas ⌘+C ; and then  ^+⌘+V ; and then; ⌘+F

 

© Copyright Ash Roy ® All rights reserved 2013

avatar

Ash Roy

Ash Roy has spent over 15 years working in the corporate world as a financial and strategic analyst and advisor to large multinational banks and telecommunications companies. He suffered through a CPA in 1997 and completed it despite not liking it at all because he believed it was a valuable skill to have. He sacrificed his personality in the process. In 2004 he finished his MBA (Masters In Business Administration) from the Australian Graduate School of Management and loved it! He scored a distinction (average) and got his personality back too!

RELATED ARTICLES