Excel Shortcuts Cheat Sheet: Essential Keyboard Combinations for Efficiency, Cheat Sheet of MS Microsoft Excel skills

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)

 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 + 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)

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

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