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.

No comments: