View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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