Contents

Know more about this
(or any other) subject?

Show off your know-how at Quamut Wiki.

Learn more with these titles from Barnes & Noble

Previous:
Shortcuts for Reviewing, Protecting, and Sharing

Function Key Quick Reference

Function Keys

Action		Keyboard Shortcut
Open Excel’s Help features (or Microsoft Office Online)		F1
Edit the active cell or move the cursor into the Formula Bar when the editing feature in a cell is turned off		F2
Open the Paste Name dialog box		F3
Redo your most recent command		F4
Go to a specific location in the worksheet		F5
Go to the next open pane		F6
Start Spell Check		F7
Turn on extend-selection mode		F8
Calculate all sheets in all open workbooks		F9
Show or hide KeyTips		F10
Insert a chart on a new spreadsheet in the current workbook		F11
Save a workbook in a particular file format (Save As)		F12

Action		Keyboard Shortcut
Show or hide the Ribbon (“Task Pane” in previous versions of Excel)		Ctrl+F1
Switch to the Print Preview view		Ctrl+F2
Open the Name Manager dialog box		Ctrl+F3
Close the active window (or workbook, if only one window)		Ctrl+F4
Restore a minimized window		Ctrl+F5
Switch to the next window (if more than one is open)		Ctrl+F6
Move (adjust the location of) the current window		Ctrl+F7
Execute the Size command when a workbook is not maximized		Ctrl+F8
Minimize the active window		Ctrl+F9
Maximize the active window		Ctrl+F10
Open a new Macro spreadsheet		Ctrl+F11
Open an existing spreadsheet		Ctrl+F12

Action		Keyboard Shortcut
Insert a comment or edit an existing comment		Shift+F2
Start the Insert Function wizard		Shift+F3
Find the next . . . (based on your most recent search)		Shift+F4
Open the Find and Replace dialog box		Shift+F5
Go to the previous pane		Shift+F6
Open the Research pane		Shift+F7
Add additional cells to a selection		Shift+F8, arrow keys
Calculate the current worksheet only		Shift+F9
Open the shortcut menu (same as right-clicking on a cell)		Shift+F10
Add a new worksheet to the current workbook		Shift+F11
Save the current workbook		Shift+F12

Action		Keyboard Shortcut
Open the Create Names from Selection dialog box		Ctrl+Shift+F3
Find the previous . . . (based on your most recent search)		Ctrl+Shift+F4
Go to the previous window (if more than one is open)		Ctrl+Shift+F6
Print the current worksheet		Ctrl+Shift+F12

Action		Keyboard Shortcut
Insert a chart into the current worksheet		Alt+F1
Save a workbook in a particular file format (Save As)		Alt+F2
Close Excel		Alt+F4
Open the Macro dialog box (to run or manage Macros)		Alt+F8
Open the Visual Basic Code editor		Alt+F11

Previous:
Shortcuts for Reviewing, Protecting, and Sharing

Download the PDF
for just $2.95

► Complete guide
► Handy, portable format