MS Excel Shortcut Key's
Shortcut
key Description
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 + ( Unhide any hidden rows within the selection
Ctrl + Shift + )
Unhide any hidden
columns within the selection
Ctrl + Shift + \
select unequal cells
Alt Toggles
the activation of the old Menu Bar
Alt + Shift + Left Arrow
Displays the (Data > Group and
Outline > UnGroup) dialog box
Alt + Shift + Right Arrow
Displays the (Data > Group and Outline
> Group) dialog box
Alt + Spacebar
Activates the
Control Box in the top left hand corner
End Toggles
between switching End Mode on or off
Scroll Lock Toggles between switching Scroll Lock on or off
Shift + Insert
Pastes the entry
from the clipboard
No comments: