Timestamp Your Spreadsheet

August 22, 2011

If you would like to timestamp your spreadsheet to keep track of when you added or updated data, try this:

1. To insert the current date into a cell, hold down the CTRL key while you press the semicolon (;) key.
2. To insert the current time, press CTRL+Shift+Semicolon.