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
Sunday, March 25, 2007
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment