0.pdf - Excel Shortcuts Cheat Sheet F1 Displays the Office...

1
Excel Shortcuts Cheat Sheet
 F1 Displays the Office Assistant or (Help >
Microsoft Excel Help)
 F2 Edits the active cell, putting the cursor at
the end
 F3 Displays the (Insert > Name > Paste)
dialog box
 F4 Repeats the last worksheet action (Edit >
Repeat)
 F5 Displays the (Edit > GoTo) dialog box
 F6 Moves to the next pane in a workbook (if
the window is split)
 F7 Displays the (Tools > Spelling) dialog box
 F8 Toggles whether to extend a selection
with the arrow keys
 F9 Calculates All the worksheets in All the
open workbooks
 F10 Toggles the activation of the Menu Bar
 F11 Displays the (Insert > Chart) dialog box
that creates a chart (on a chart sheet) using
the highlighted range
 F12 Displays the (File > Save As) dialog box
 Shift + F2 Inserts or edits a cell comment
(Insert > Comment)
 Shift + F3 Displays the (Insert > Function)
dialog box
 Shift + F4 Repeats the last Find, the same as
(Edit > Find Next)
 Shift + F5 Displays the (Edit > Find) dialog
box
 Shift + F6 Moves to the previous pane in a
workbook (if the window is split)
 Shift + F8 Toggles between switching Add
Mode on or off*
 Shift + F9 Calculates just the active
worksheet
 Shift + F10 Displays the (Shortcut) menu for
the selected item
 Shift + F11 Inserts a new worksheet (before
the active sheet) into the active workbook
(Insert > Worksheet)
 Shift + F12 Saves, Displays the (File > Save
As) dialog box if a new workbook
 Ctrl + F1 Closes and reopens the current
task pane (ribbon in 2007)
 Ctrl + F2 Print Preview
 Ctrl + F3 Displays the (Insert > Name >
Define) dialog box
 Ctrl + F4 Closes the selected workbook
window
 Ctrl + F5 Restores the size of the active
workbook or window
 Ctrl + F6 Moves to the next open workbook
or window
 Ctrl + F7 Activates the Move window
command
 Ctrl + F8 Activates the Resize window
command
 Ctrl + F9 Minimises the size of the active
workbook or window
 Ctrl + F10 Maximises the size of the active
workbook or window
 Ctrl + F12 Displays the (File > Open) dialog
box
 Alt + F1 Creates a chart (on a chart sheet)
using the highlighted range
 Alt + F2 Displays the (File > Save As) dialog
box
 Alt + F4 Closes all the workbooks (saving
first) and exits Excel (File > Exit)
 Alt + F8 Displays the (Tools > Macro >
Macros) dialog box

2
 Alt + F11 Toggles between the Visual Basic
Editor window and and the Excel window
 Alt + Ctrl + F9 Calculates All cells on All
worksheets in All workbooks
 Alt + Shift + F1 Inserts a new worksheet
(before the active sheet) into the active
workbook (Insert > Worksheet)
 Alt + Shift + F2 Displays the (File > Save
As) dialog box
 Alt + Shift + F4 Closes all the workbooks
(saving first) and exits Excel (File > Exit)
 Alt + Shift + F10 Displays the drop-down
menu for the corresponding smart tag
 Alt + Shift + F11 Activates the Microsoft
Script Editor window
 Ctrl + Shift + F3 Displays the (Insert >
Name > Create) dialog box
 Ctrl + Shift + F6 Moves to the previous
open workbook or window
 Ctrl + Shift + F10 Activates the Menu Bar or
Shortcut Characters in 2007
 Ctrl + Shift + F12 Displays the (File > Print)
dialog box