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
Monday, January 4, 2010
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment