0 of 135 lessons complete (0%)
Tips and Tricks- Intermediate

Enter date and time stamps- unchanging

You don’t have access to this lesson
Please purchase this course, or sign in if you’re already enrolled, to access the course content.

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.