A quick way to date and time stamp your spreadsheet is to make use of Excel shortcuts using the control key.
- For updated video clips in structured Excel courses with practical example files, have a look at our MS Excel online training courses . You can even try the Free MS Excel tips and tricks course.
- To see if this video matches your skill level (see the suggested skill score below) do our free MS Excel skills assessment.
- If you are based in South Africa look at the live courses we offer in Johannesburg and Cape Town.
- - 1:00
- - Skill Level: 3
- - What's my skill level
So for example, if I want to put a date time stamp in a spreadsheet cell, you’ll see that if I hold control down and push the semi- colon (;), you’ll see what happens. You’ll see it puts today’s date in. Now push enter and you’ll see because I formatted it in another way, it shows the date in that format. Similarly with the time if I hold the control and shift key and press semi colon, you’ll see it puts in the time today. Push “Enter”. When you look at the formula bar you’ll see that these aren’t linked, they are actually stamped. They are values that you have actually entered and each time you want to change them you can use those shortcuts again.