 Ctrl + Shift + Page Up Selects the active
worksheet and the one before it
 Ctrl + Shift + Spacebar Selects all the
objects on the worksheet when an object is
selected or selects the whole worksheet
 Ctrl + Spacebar Selects the current column
 Shift + Arrow keys Selects the active cell
and the cell in the given direction
 Shift + Backspace Selects the active cell
when multiple cells are selected
 Shift + Spacebar Selects the current row
 Ctrl + Shift + Arrow Key Extends the
selection to the next cell adjacent to a blank
cell in that direction
 Ctrl + Shift + End Extends the selection to
the last used cell on the worksheet
 Ctrl + Shift + Home Extends the selection
to the beginning of the worksheet
 Shift + Arrow Keys Extends the selection by
one cell in that direction
 Shift + Home Extends the selection to the
first column
 Shift + Page Down Extends the selection
down one screen
 Shift + Page Up Extends the selection up
one screen
 End + Shift + Arrow Keys Extends the
selection to the next non-blank cell in that
direction
 End + Shift + End Extends the selection to
the last cell in the current row*
 End + Shift + Home Extends the selection
to last used cell on the worksheet
 Alt + ‘ Displays the Style dialog box
 Ctrl + Shift + ( ‘ or ) Applies the Time
format “hh:mm” to the selection
 Ctrl + Shift + (1 or !) Applies the Comma
separated format “#,##0.00” to the selection
 Ctrl + Shift + (4 or $) Applies the Currency
format “£#,##0.00” to the selection
 Ctrl + Shift + (5 or %) Applies the
Percentage format “0%” to the selection
 Ctrl + Shift + (6 or ^) Applies the
Exponential format “#,##E+02” to the
selection
 Ctrl + Shift + (# or ~) Applies the General
format to the selection
 Ctrl + (# or ~) Applies the Custom Date
format “dd-mmm-yy” to the selection
 Ctrl + Shift + (7 or &) Applies the outline
border to the selection
 Ctrl + Shift + (- or _ ) Removes all the
borders from the selection
 Arrow Keys Moves to the next cell in that
direction
 Ctrl + Tab Moves to the next open
workbook or window
 Alt + Tab Moves to the next application
open on your computer
 Alt + Shift + Tab Moves to the previous
application open on your computer
 Enter Moves to the cell directly below
 Tab Moves to the next cell on the right (or
unprotected cell)
 Home Moves to the first column in the
current row
 End + Arrow Keys Moves to the next non
empty cell in that direction
 End + Enter Moves to the last cell in the
current row that is not blank
 End + Home Moves to the last used cell on
the active worksheet*
 End + Home Moves to the last used cell on
the active worksheet*
 Page Down Moves to the next screen of
rows down
5
 Page Up Moves to the previous screen of
rows up
 Shift + Enter Moves to the cell directly
above (opposite direction to Enter)
 Shift + Tab Moves to the cell directly to the
left (opposite direction to Tab)
 Alt + Page Down Moves you one screen of
columns to the right
 Alt + Page Up Moves you one screen of
columns to the left
 Ctrl + Home Moves to cell “A1” on the
active sheet
 Ctrl + End Moves to the last used cell on
the active worksheet*
 Ctrl + Up Arrow Moves to the first row in
the current region
 Ctrl + Down Arrow Moves to the last row in
the current region
 Ctrl + Left Arrow Moves to the first column
in the current region
 Ctrl + Right Arrow Moves to the last
column in the current region
 Ctrl + Page Up Moves to the previous
worksheet in the workbook
 Ctrl + Page Down Moves to the next
worksheet in the workbook
 Ctrl + Shift + Tab Moves to the previous
open workbook or window
 Scroll Lock + Arrow Keys Moves the
workbook or window one cell the
corresponding direction
 Scroll Lock + End Moves to the last cell in
the current window
 Scroll Lock + Home Moves to the first cell
in the current window
 Scroll Lock + Page Down Moves you down
one screen (current selection unchanged
 Scroll Lock + Page Up Moves you up one
screen (current selection unchanged)
 Enter Moves from top to bottom within a
selection
 Tab Moves from left to right within a
selection
 Ctrl + . Moves clockwise to the next corner
within a selection
 Shift + Tab Moves from right to left within a
selection (opposite direction to Tab)
 Alt + Ctrl + Left Arrow Moves to the left
between non adjacent cells in a selection
 Alt + Ctrl + Right Arrow Moves to the right
between non adjacent cells in a selection
 = Starts a Formula
 Ctrl + ` Toggles between the value layer and
the formula layer
 Ctrl + Insert Copies the current selection to
the clipboard
 Ctrl + Shift + ( Unhides any hidden rows
within the selection
 Ctrl + Shift + ) Unhides any hidden columns
within the selection
 Ctrl + Shift + \ Select unequal cells