Use This Shortcut to Insert Time/Date in Excel or Access
Here are a few keyboard shortcuts you can use to
insert the current time and date in a Microsoft Access table
or Microsoft Excel spreadsheet.
§
Current date: Press CTRL+SEMICOLON
§
Current time: Press CTRL+SHIFT+ SEMICOLON
§
Current date and time: Press CTRL+ SEMICOLON then SPACE then
CTRL+SHIFT+ SEMICOLON
In Access, this keyboard shortcut only works if you are
entering data in the Datasheet or Form view.
Editor's Note:
When you insert the date and time using this tip, the
information remains static. To update this information
automatically, you must use the TODAY and NOW functions. To
learn how to do this, search for Insert the current date
and time in a cell in Excel Help and then click
Insert a date or time whose value is updated.
|