Monday, October 04, 2004

Short Cut Keys in Excel save you time

Short cuts enable you to do stuff with Excel much faster. Typically these involve the keyboards as that is a faster way of operating than using a mouse.
Here are some of my most frequently used.

CTRL SHIFT and arrow keys - select cells (Hint: use the END key before an arrow to select blocks of cells)
CTRL SPACE - select a whole column
SHIFT SPACE - select a whole row
CTRL HOME - goes to the top left cell in the pane
CTRL + inserts a cell (or a row or column if the whole row or column is selected)
CTRL - deletes a cell (or a row or column if the whole row or column is selected)
CTRL PAGEUP - cycles up through the sheet tabs
CTRL PAGEDOWN - cycles down through the sheet tabs
CTRL D - fill down
CTRL R - fill right
CTRL INSERT - copy
SHIFT INSERT - paste
SHIFT DELETE - cut
F2 - edit formula
ALT F11 - open visual basic explorer
CTRL TAB or CTRL SHIFT TAB - cycles through open workbooks in forward and reverse

Comprehensive list of keyboard shortcuts


Posted by: Jethro | 1:30 AM |