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