Monday, January 4, 2010

EXCEL KEYBOARD SHORTCUTS

Here are several keyboard shortcuts for you Excel power users.

These keystrokes change a cell’s format on the fly:
Ctrl-Shift-~             General (hold down the Control and Shift k eys while pressing the tilde key)
Ctr l-Shift-$             Currency with 2 decimal places
Ctrl-Shift-!               Number with 2 decimal places and commas
Ctrl-Shift-%             Percent with no decimal places
Ctrl-Shift-^               Exponential with 2 decimal places
Ctrl-Shift-#              Date with day, month and year
Ctrl-Shift-@             Time with hour, minute and AM/PM indicator
Ctrl-Shift-&      Apply the outline border
Ctrl-Shift-_               Remove outline borders
Ctrl-B                        Apply or remove bold (toggles)
Ctrl-I                         Apply or remove italics
Ctrl-U                       Apply or remove underline
C trl-5                      Apply or remove strikethrough
Ctrl-;                        Insert current date into cell
Ctrl-:                         Insert current time into cell

No comments: