196 useful Keyboard Shortcuts for Excel 2011

3/12/2014

196 useful Keyboard Shortcuts for Excel 2011.

A wiki-style reference database for keyboard shortcuts

2003

2007

2010

Comments (99)

Edit

Excel 2011

mac

Add

login/ register
772

Account
My Shortcuts
Login/ Register
Platforms:
Linux Shortcuts
Mac OS Shortcuts
Windows Shortcuts
Web Applications
New Mac OS Shortcuts: iTunes Vuescan
Avid Media Composer 7
VLC Media Player
Site:
About
Discuss
Add Page
Request Page

Excel 2011 Shortcuts
Uploaded by bernd,
PDF
Print updated on 2/10/2012 by bernd
Hide all
Show all
Platform: Mac OS/ English
Show Apple Symbols as
Text
Table of Contents:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.

Function keys
Moving and scrolling in a sheet or workbook
Previewing and printing
Entering data on a sheet
Working in cells or the Formula bar
Formatting and editing data
Working with a selection
Selecting cells, columns, or rows
Charts
Data forms
Filters and PivotTable reports
Outlining data
Toolbars
Windows
Dialog boxes

Give Feedback

http://www.shortcutworld.com/en/mac/Excel_2011.html#link_1

1/13

3/12/2014

196 useful Keyboard Shortcuts for Excel 2011.

1. Function keys

http://www.shortcutworld.com/en/mac/Excel_2011.html#link_1

F1

Undo

F2

Cut text from the active cell

Shift + F2

Edit a cell comment

F3

Copy text from the active cell

Shift + F3

Open the Formula Builder

F4

Paste text into the active cell

Shift + F4

Repeat the last Find (Find Next)

⌘ + F4

Close the window

F5

Display the Go To dialog box

Shift + F5

Display the Find dialog box

⌘ + F5

Restore the window size.*

F6

Move to the next pane in a workbook that has been split

Shift + F6

Move to the previous pane in a workbook that has been split

⌘ + F6

Move to the next workbook window ⌘ + Shift + F6

Move to the previous workbook window F7

Check spelling
2/13

3/12/2014

196 useful Keyboard Shortcuts for Excel 2011.

F8

Turn on extend selection mode; used with arrow keys or cursor

Shift + F8

Add to the selection

Option + F8