Excel Shortcuts Cheat Sheet
F1 Displays the Office Assistant or (Help > Microsoft
Shift + F10 Displays the (Shortcut) menu for the
Excel Help)
selected item
F2 Edits the active cell, putting the cursor at the
Shift + F11 Inserts a new worksheet (before the active
end
sheet) into the active workbook (Insert > Worksheet)
F3 Displays the (Insert > Name > Paste) dialog box
Shift + F12 Saves, Displays the (File > Save As) dialog
box if a new workbook
F4 Repeats the last worksheet action
(Edit > Repeat)
Ctrl + F1 Closes and reopens the current task pane
(ribbon in 2007)
F5 Displays the (Edit > GoTo) dialog box
Ctrl + F2 Print Preview
F6 Moves to the next pane in a workbook (if the
window is split)
Ctrl + F3 Displays the (Insert > Name > Define) dialog
box
F7 Displays the (Tools > Spelling) dialog box
Ctrl + F4 Closes the selected workbook window
F8 Toggles whether to extend a selection with the
arrow keys
Ctrl + F5 Restores the size of the active workbook or
window
F9 Calculates All the worksheets in All the open
workbooks
Ctrl + F6 Moves to the next open workbook or window
F10 Toggles the activation of the Menu Bar
Ctrl + F7 Activates the Move window command
F11 Displays the (Insert > Chart) dialog box that
Ctrl + F8 Activates the Resize window command
creates a chart (on a chart sheet) using the
highlighted range
Ctrl + F9 Minimises the size of the active workbook or
window
F12 Displays the (File > Save As) dialog box
Ctrl + F10 Maximises the size of the active workbook
Shift + F2 Inserts or edits a cell comment
or window
(Insert > Comment)
Ctrl + F12 Displays the (File > Open) dialog box
Shift + F3 Displays the (Insert > Function)
dialog box
Alt + F1 Creates a chart (on a chart sheet) using the
highlighted range
Shift + F4 Repeats the last Find, the same as
(Edit > Find Next)
Alt + F2 Displays the (File > Save As) dialog box
Shift + F5 Displays the (Edit > Find) dialog box
Alt + F4 Closes all the workbooks (saving first) and
exits Excel (File > Exit)
Shift + F6 Moves to the previous pane in a
workbook (if the window is split)
Alt + F8 Displays the (Tools > Macro > Macros) dialog
box
Shift + F8 Toggles between switching Add Mode on
or off*
Shift + F9 Calculates just the active worksheet
Alt + F11 Toggles between the Visual Basic Editor window
Ctrl + Shift + 0 Unhides the columns in the current
and and the Excel window
selection
Alt + Ctrl + F9 Calculates All cells on All worksheets in
Ctrl + Shift + 2 Enters the value from the cell directly
All workbooks
above into the active cell
Alt + Shift + F1 Inserts a new worksheet
Ctrl + Shift + 8 Selects the current region (surrounded
(before the active sheet) into the active workbook
by blank rows and columns)
(Insert > Worksheet)
Ctrl + Shift + 9 Unhides the rows in the current selection
Alt + Shift + F2 Displays the (File > Save As) dialog box
Ctrl + A Displays formula palette given a function name or
Alt + Shift + F4 Closes all the workbooks (saving first)
selects the whole worksheet or current date
and exits Excel (File > Exit)
Ctrl + B Toggles bold on the current selection
Alt + Shift + F10 Displays the drop-down menu for the
corresponding smart tag
Ctrl + C Copies the current selection to the clipboard
Alt + Shift + F11 Activates the Microsoft Script Editor
Ctrl + D Copies the first cell in the selection downwards
window
Ctrl + F Displays the Find dialog box
Ctrl + Shift + F3 Displays the (Insert > Name > Create)
dialog box
Ctrl + G Displays the Go To dialog box
Ctrl + Shift + F6 Moves to the previous open workbook
Ctrl + H Displays the Replace dialog box
or window
Ctrl + I Toggles italics on the current selection
Ctrl + Shift + F10 Activates the Menu Bar or Shortcut
Characters in 2007
Ctrl + K Displays the Insert Hyperlink dialog box
Ctrl + Shift + F12 Displays the (File > Print) dialog box
Ctrl + L Displays the Create Table dialog box
Ctrl + 0 Hides the columns in the current selection
Ctrl + N Creates a new workbook
Ctrl + 1 Displays the formatting dialog box
Ctrl + O Displays the Open dialog box
Ctrl + 2 Toggles bold on the current selection
Ctrl + P Displays the Print dialog box
Ctrl + 3 Toggles italics on the current selection
Ctrl + R Copies the leftmost cell in the selection to the
right
Ctrl + 4 Toggles underlining on the current selection
Ctrl + S Saves, Displays the Save As dialog box if a new
Ctrl + 5 Toggles the strikethrough of text on the
workbook
current selection
Ctrl + U Toggles underlining on the current selection
Ctrl + 6 Toggles between hiding, displaying
Ctrl + V Pastes the entry from the clipboard
Ctrl + 8 Toggles the display of Outline symbols on
the active worksheet
Ctrl + W Closes the active workbook or window
Ctrl + 9 Hides the rows in the current selection
Ctrl + X Cuts the current selection to the clipboard
(Format > Row > Hide)
Ctrl + Y Repeats the last workbook action
Alt + Down Arrow Displays the Pick From List drop-down
list Esc Cancels the cell entry and restores the original
Ctrl + Z Undo the last workbook action
contents
Ctrl + Shift + F Activates the Font Tab of the format
Delete Deletes the selection or one character to the
cells
right
Ctrl + Shift + O Selects all the cells with comments
Backspace Deletes the selection or one character to
the left
Ctrl + Shift + P Activates the Font Size tab of the
format cells Enter Enters the contents of the active
Shift + Delete Cuts the selection to the clipboard
cell and moves to the cell below (by default)
Ctrl + Delete Deletes text to the end of the line
Shift + Enter Enters the contents of the active cell and
moves to the cell above (by default)
Ctrl + - Displays the Delete dialog box
Tab Enters the contents of the active cell and moves
Ctrl + Shift + = Displays the Cells dialog box
one cell to the right
Ctrl + \ Selects the cells in a selected row that do not
Shift + Tab Enters the contents of the active cell and
match the value in the active cell
moves one cell to the left
Ctrl + Shift + \ Selects the cells in a selected column
Alt + = Enters the SUM() function (AutoSum) to sum
that do not match the value in the active cell
the adjacent block of cells
Ctrl + / Selects the array containing the active cell ??
Alt + 0128 Enters the euro symbol (€) (using Number
keypad)
Alt + ; Selects the visible cells in the current selection
Alt + 0162 Enters the cent symbol (¢) (using Number
Ctrl + Shift + (8 or *) Selects the current region
keypad)
(surrounded by blank rows and columns)
Alt + 0163 Enters the pound sign symbol (£)
Ctrl + * Selects the current region (using the * on the
(using Number keypad)
number keyboard)
Alt + Enter Enters a new line (or carriage return) into a
Ctrl + [ Selects all the cells that are directly referred to
cell
by the formula in the active cell (precedents)
Ctrl + ' Enters the contents from the cell directly above
Ctrl + Shift + [ Selects all the cells that are directly
into the active cell
(or indirectly) referred to by the formula in the active
cell
Ctrl + Shift + 2 Enters the value from the cell directly
above into the active cell
Ctrl + ] Selects all the cells that directly refer to the
active cell (dependents)
Ctrl + ; Enters the current date into the active cell
Ctrl + Shift + ] Selects all the cells that directly
Ctrl + Shift + ; Enters the current time into the active
(or indirectly) refer to the active cell
cell
Ctrl + Shift + Page Down Selects the active worksheet
Ctrl + Shift + Enter Enters the formula as an Array
and the one after it
Formula
Shift + Insert Enters the data from the clipboard
Ctrl + Shift + Page Up Selects the active worksheet and
Ctrl + Shift + (4 or $) Applies the Currency format
the one before it
"£#,##0.00" to the selection
Ctrl + Shift + Spacebar Selects all the objects on the
Ctrl + Shift + (5 or %) Applies the Percentage format "0%"
worksheet when an object is selected or selects the
to the selection
whole worksheet
Ctrl + Shift + (6 or ^) Applies the Exponential format
Ctrl + Spacebar Selects the current column
"#,##E+02" to the selection
Shift + Arrow keys Selects the active cell and the cell
Ctrl + Shift + (# or ~) Applies the General format to the
in the given direction
selection
Shift + Backspace Selects the active cell when multiple
Ctrl + (# or ~) Applies the Custom Date format
cells are selected
"dd-mmm-yy" to the selection
Shift + Spacebar Selects the current row
Ctrl + Shift + (7 or &) Applies the outline border to the
selection
Ctrl + Shift + Arrow Key Extends the selection to the
next cell adjacent to a blank cell in that direction
Ctrl + Shift + (- or _ ) Removes all the borders from the
selection
Ctrl + Shift + End Extends the selection to the last
used cell on the worksheet
Arrow Keys Moves to the next cell in that direction
Ctrl + Shift + Home Extends the selection to the
Ctrl + Tab Moves to the next open workbook or window
beginning of the worksheet
Alt + Tab Moves to the next application open on your
Shift + Arrow Keys Extends the selection by one cell in
computer
that direction
Alt + Shift + Tab Moves to the previous application open
Shift + Home Extends the selection to the first column
on your computer
Shift + Page Down Extends the selection down one
Enter Moves to the cell directly below
screen
Tab Moves to the next cell on the right (or unprotected
Shift + Page Up Extends the selection up one screen
cell)
End + Shift + Arrow Keys Extends the selection to the
Home Moves to the first column in the current row
next non-blank cell in that direction
End + Arrow Keys Moves to the next non empty cell in
End + Shift + End Extends the selection to the last cell
that direction
in the current row*
End + Enter Moves to the last cell in the current row that
End + Shift + Home Extends the selection to last used
is not blank
cell on the worksheet
End + Home Moves to the last used cell on the active
Alt + ' Displays the Style dialog box
worksheet*
Ctrl + Shift + ( ' or ) Applies the Time format "hh:mm"
End + Home Moves to the last used cell on the active
to the selection
worksheet*
Ctrl + Shift + (1 or !) Applies the Comma separated
Page Down Moves to the next screen of rows down
format "#,##0.00" to the selection
Page Up Moves to the previous screen of rows up
Scroll Lock + End Moves to the last cell in the current
window
Shift + Enter Moves to the cell directly above (opposite
direction to Enter)
Scroll Lock + Home Moves to the first cell in the current
window
Shift + Tab Moves to the cell directly to the left
(opposite direction to Tab)
Scroll Lock + Page Down Moves you down one screen
(current selection unchanged
Alt + Page Down Moves you one screen of columns to
the right
Scroll Lock + Page Up Moves you up one screen
(current selection unchanged)
Alt + Page Up Moves you one screen of columns to
the left
Enter Moves from top to bottom within a selection
Ctrl + Home Moves to cell "A1" on the active sheet
Tab Moves from left to right within a selection
Ctrl + End Moves to the last used cell on the active
Ctrl + . Moves clockwise to the next corner within a
worksheet*
selection
Ctrl + Up Arrow Moves to the first row in the current
Shift + Tab Moves from right to left within a selection
region
(opposite direction to Tab)
Ctrl + Down Arrow Moves to the last row in the current
Alt + Ctrl + Left Arrow Moves to the left between non
region
adjacent cells in a selection
Ctrl + Left Arrow Moves to the first column in the
Alt + Ctrl + Right Arrow Moves to the right between non
current region
adjacent cells in a selection
Ctrl + Right Arrow Moves to the last column in the
= Starts a Formula
current region
Ctrl + ` Toggles between the value layer and the formula
Ctrl + Page Up Moves to the previous worksheet in
layer
the workbook
Ctrl + Insert Copies the current selection to the
Ctrl + Page Down Moves to the next worksheet in the
clipboard
workbook
Ctrl + Shift + ( Unhides any hidden rows within the
Ctrl + Shift + Tab Moves to the previous open workbook
selection
or window
Ctrl + Shift + ) Unhides any hidden columns within the
Scroll Lock + Arrow Keys Moves the workbook or
selection
window one cell the corresponding direction
Ctrl + Shift + \ Select unequal cells
