View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default what did I do to get autodate?

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.
--
David Biddulph

"BorisS" wrote in message
...
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.
--
Boris