Monday, August 27, 2012

Ask Amy: Useful Excel Keyboard Shortcuts


You can use keyboard shortcuts in every office program. Here are four Excel Shortcut Keys that we find extremely useful:

   

Keys

Action

CTRL + ; (semicolon) Enters the current date into the selected cell
CTRL + :
(colon)
Copies the current time into the selected cell
CTRL + '
(apostrophe)
Copies the data from the cell directly above into the selected cell
ALT + +
(plus sign)
Is the same as clicking on the AutoSum tool