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.
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.
Leave a Reply