Keyboard shortcut: something new

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

James Silverton - 23 Sep 2007 13:01 GMT

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

Reply to this Message

Dave Peterson - 23 Sep 2007 13:09 GMT

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.

> Hello, All!
>
[quoted text clipped - 9 lines]
> E-mail, with obvious alterations:
> not.jim.silverton.at.verizon.not

Signature

Dave Peterson

Reply to this Message

James Silverton - 23 Sep 2007 13:14 GMT

Dave wrote on Sun, 23 Sep 2007 07:09:03 -0500:

DP> Click on the first item (Keyboard Shortcuts)
DP> then scroll down for:
DP> Keys for entering, editing, formatting, and calculating
DP> data Then click on: Enter data

DP> Near the bottom of that section, I see:

DP> CTRL+; (semicolon)
DP> Enter the date.

DP> CTRL+SHIFT+: (colon)
DP> Enter the time.

DP> 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?

Thank you very much Dave, it had not occurred to me to look
under "Enter data". As I've said many times before, you live and
learn.

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.verizon.not

Reply to this Message

MartinW - 23 Sep 2007 13:15 GMT

Hi James,

Put 'keyboard shortcut' into the index section of Help
and then click on 'keys for entering data'.

You will also see it used all over these newsgroups.
Press Ctrl+; followed by space followed by Ctrl+Shift+;
and you will get the current Date and time in the cell.

HTH
Martin

> Hello, All!
>
[quoted text clipped - 8 lines]
> E-mail, with obvious alterations:
> not.jim.silverton.at.verizon.not

Reply to this Message