So, often times you might be putting together a spreadsheet in MS Excel that you would like to automatically time stamp. This way, you don’t have to guess when you created a particular spreadsheet or where you put it. One of the things you can do, for instance is =today) or =now) and input it to Excel. However, this is only a one-time fix. Instead, you should follow these steps to create automatic time stamps:

  • Use Ctrl+ and; to enter the current date.
  • Use Ctrl+ Shift + to insert the current time.