Enter date and time stamps- unchanging

Please sign up for the course before starting the lesson.

If you often have to enter the current date and time into a cell, you will appreciate these shortcuts. They will save you time in looking at your watch or cell phone to see the date/ time.

With the first shortcut Excel will enter the current date as shown below. Note that it is a date stamp in that it 'types' it in. This date will not change if you open the file tomorrow.

Date Time Stamp

OR  you can use the shortcut to enter the current time.

To see the full course contents click here.

Back to: Intermediate Excel Course > Tips and Tricks- Intermediate