Tuesday, January 17, 2012

Keyboard shortcuts to add date and time in Excel

It seems simple, but I was doing it by typing the current date and time "by hand" in a Excel worksheet cells. It was not efficient. There should be a quicker way to do it! And there is. Through the use of keyboard shortcuts:

  • Enter the current date: CTRL+SHIFT+";"
  • Enter the current time: CTRL+SHIFT+":"

No comments: