Hold that Date! Timestamped Printouts in Excel

It’s not uncommon at my office to see “version 37” of a budget, sales plan, or other big project. Keeping track of all these changes can be a mess.

While Excel has some functionality to track changes, it’s a weakness of Excel. This is especially dicey with workbooks containing many links and formulas — things can change, even unintentionally.

It’s old-fashioned, but a great idea to keep a hard copy of any spreadsheet you’re presenting. This can be done via a PDF copy or a literal printout.

One nice thing to include in this printout is a timestamp. To have Excel display the date and time at which your workbook was printed, follow the below steps.

From “Page Setup,” you will go to “Header/Footer,” then select either header or footer. Choose the calendar and clock buttons to get the date and time.

 

2016-04-04_18-12-35

Note there are many other things to include in a header or footer — page numbers, file path, etc. It’s a great, underused feature of Excel. 

business-257911_960_720

Subscribe to my mailing list.

Leave a Reply

%d bloggers like this: