Keyboard shortcut: something new
In xl2003's help, I can search for "keyboard shortcuts"
Click on the first item (Keyboard Shortcuts)
then scroll down for:
Keys for entering, editing, formatting, and calculating data
Then click on: Enter data
Near the bottom of that section, I see:
CTRL+; (semicolon)
Enter the date.
CTRL+SHIFT+: (colon)
Enter the time.
James Silverton wrote:
Hello, All!
I have been using Excel 2002, as the name implies, for quite a
long time but it still surprises me sometimes. Today, I
accidentally pressed CTRL-SHIFT-; and the time with hour and
minutes appeared. Can anyone tell me please where this shortcut
is documented?
James Silverton
Potomac, Maryland
E-mail, with obvious alterations:
not.jim.silverton.at.verizon.not
--
Dave Peterson
|