Showing posts with label keyboard. Show all posts
Showing posts with label keyboard. Show all posts

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+":"