- Enter the current date: CTRL+SHIFT+";"
- Enter the current time: CTRL+SHIFT+":"
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: