Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I'm recording results into an Excel spreadsheet, and I want to record the time I enter the results. In Notepad, one can simply press F6 to get the current time stamp. Is there a simple/easy way to do this in Excel?

share|improve this question

3 Answers 3

up vote 6 down vote accepted

How about these:

  • For the current date: Press CTRL+SEMICOLON
  • For the current time: Press CTRL+SHIFT+SEMICOLON
  • For the current date and time: Press CTRL+SEMICOLON then SPACE then CTRL+SHIFT+SEMICOLON
share|improve this answer

Just add =NOW() in a cell.

share|improve this answer

There are shortcuts for date (CTRL+;) and time (CTRL+SHIFT+;)

see also http://office.microsoft.com/en-us/excel/HP030561071033.aspx

For other language versions of Excel the shortcuts are a little different. For the german version the shortcuts are CTRL+. and CTRL+SHIFT+.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.