what did I do to get autodate?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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.
 
Back
Top