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+;
  • For the current time: Press CTRL+SHIFT+;
  • For the current date and time: Press CTRL+; then SPACE then CTRL+SHIFT+;
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: Insert the current date and time in a cell

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.