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 -- Dick Archer
|
Post a Comment