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

Changing, in MS Excel, cell colors based on its value

In order to produce an easy-to-read table in MS Excel, I wanted to assign a color to each cell according to its contents. To that end I just need to apply conditional formatting to that cells. In MS Excel this can be done through menu Format>Conditional Format and by providing the conditions and corresponding formats.

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.