Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
what did I do to get autodate?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
what did I do to get autodate?
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 On Nov 12, 11:25 am, BorisS wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autodate worksheet tab | Excel Discussion (Misc queries) | |||
How do I autodate(excel) every 7 days ex. 1/1/06-1/31/06? | New Users to Excel | |||
Inserting an AutoDate Function | New Users to Excel | |||
autodate and datetime stamp | Excel Worksheet Functions |