Single key press date input

  • Thread starter Thread starter Just Me
  • Start date Start date
J

Just Me

I searched the group but may have missed this as it seems like a
common task. I would like to enter the current date into a cell with
just a single key press.the cell,column actually, is formated for date
and pressing D would enter todays date.Any pointers would be greatly
appreciated.
SteveC
 
After serious thinking Just Me wrote :
I searched the group but may have missed this as it seems like a
common task. I would like to enter the current date into a cell with
just a single key press.the cell,column actually, is formated for date
and pressing D would enter todays date.Any pointers would be greatly
appreciated.
SteveC
Click to expand...

You could look in online help for keyboard shortcuts if you want to use
built-in ones. The key combo you need for entering current date is
'Ctrl+:'.
 
GS used his keyboard to write :
After serious thinking Just Me wrote :

You could look in online help for keyboard shortcuts if you want to use
built-in ones. The key combo you need for entering current date is 'Ctrl+:'.
Click to expand...

Sorry about typo. It should be 'Ctrl+;'
 
Not possible with one keystroke.

Excel does not know what has been entered in a cell until you signify you are
done with that cell by moving out of that cell using enter key or arrow key or
Tab key.

CTRL + ;(semi-colon) enters a static date.


Gord Dibben MS Excel MVP.
 
Thanks all.
SteveC

Not possible with one keystroke.

Excel does not know what has been entered in a cell until you signify youare
done with that cell by moving out of that cell using enter key or arrow key or
Tab key.

CTRL + ;(semi-colon) enters a static date.

Gord Dibben     MS Excel MVP.
Click to expand...
 
Back
Top