Wednesday, May 19, 2004
Excel Tip
Excel Tip of the Day
Short cuts enable you to do stuff with excel much faster. Typically these involve the keyboards as that is a faster way of interacting than a mouse.
Here are some of my favorites
CTRL SPACE - select a whole column
SHIFT SPACE - select a whole row
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
