Enter date and time stamps- unchanging
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.
OR you can use the shortcut to enter the current time.
To see the full course contents click here.