Sunday, March 25, 2007

Excel shortcuts

If you do a lot of work in Microsoft Excel, you might be able to work faster by keeping your fingers on the keyboard (rather than clicking through the menus with your mouse).

Excel has some shortcuts.

TAB key
TAB = move to next cell to the right
SHIFT+TAB = move to the next cell to the left

ENTER key
ALT + ENTER = create a line-break in the same cell (start a new line)
CTRL + ENTER = fill the highlighted range with the current entry
SHIFT + ENTER = move to the cell above

CTRL key combinations
CTRL + R = Fill to the right
CTRL + D = Fill down
CTRL + F3 = Define a name
CTRL + K = Insert a hyperlink
CTRL + Z = Undo the last action
CTRL + ; = Enter the current date
CTRL, SHIFT + : = Enter the current time

Single keys
ESC = cancel the current cell entry
HOME = move to the beginning of the line
END = move to the end of the line
F4 = repeat the last action

No comments: