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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do I get autodate to stay the date it was saved 3
Why do I have to enter the cell (F2) for cell to calculate? 3
How do I turn off what appears to be a stuck control key? 1
What happened to my formatting? 4
Dueling keyboard shortcut Ctrl+Shft+B in Word and Outlook 2003 1
In Excel when I want shortcut to go to last entry 1
transpose - array problem 1
what's CTRL+W do? 4

Back
Top