what did I do to get autodate?

B

BorisS

I am confused. I had my left hand somewhere around ctrl/shft and right near
enter and hit some combination that auto-entered the date at the end of the
text of the cell ABOVE the one on which I believe I hit this combination.

Any idea what I could have hit to get this to happen? Curious, as I may
want to repeat the functionality/shortcut.
 
P

Pete_UK

CTRL and semicolon will get you the date (date-stamped, so it doesn't
change - unlike the function TODAY).

Incidentally, CTRL-SHIFT-semicolon will give you a time-stamp.

Hope this helps.

Pete
 
D

David Biddulph

Control semi-colon gives date. Control - shift - colon gives time. Control
semi-colon - space - Control - shift - colon gives date and time together.
But these will insert into the current cell, not the one above, so you must
have had another keystroke to move from cell to cell.
 
Top