Insert the Time or Date into Excel or Access

Here are a few keyboard shortcuts that you can use to insert the current time and date into a Microsoft Access table or Excel spreadsheet. Current date: CTRL+SEMICOLONCurrent time: CTRL+SHIFT+ SEMICOLON Current date and time: CTRL+ SEMICOLON then SPACE then CTRL+SHIFT+ SEMICOLON

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 into a cell in Excel Help and then click Insert a date or time whose value is updated.