Showing posts with label date. Show all posts
Showing posts with label date. 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+":"

Monday, September 03, 2007

Insert a static date or time on a Excel worksheet

When I was creating a table on MS-Excel I needed to insert in several places the current date. Instead of writing the whole date numerous times, I thought that Excel should have a way to do it automatically. Indeed it does and it is very simple. Thus, if one wants to insert a static current date or time on a Excel worksheet just have to use the keyboard shortcuts described below:

Current date
Select a cell and press CTRL+;

Current time
Select a cell and press CTRL+:

Current date and time
Select a cell and press CTRL+; then SPACE then CTRL+:


Note: These shortcuts are for the international Excel version on a Portuguese keyboard. I cannot guarantee these will work on other versions. Try it for yourself and if you think your experience will help others, leave a comment here.