This tip was printed from the Tips for Spreadsheets website at http://tipsforspreadsheets.com/.

Microsoft Excel 2003 - Printing Spreadsheets - Add Time and Date to Printed Spreadsheets

If printouts of multiple versions of your Microsoft Excel 2003 spreadsheets get distributed amongst officemates, it can prove cumbersome to determine who has the latest version of a spreadsheet. This can be especially troubling if office workers make copies of copies of your spreadsheet so others can make suggestions, thus you may not know which version a particular person has.

To help alleviate this problem, at least the problem of knowing who has the latest spreadsheet, you can add the time and date the spreadsheet was printed to the header or footer of a printout.

1. Select "View" - "Header and Footer".

2. The "Page Setup" multi-tabbed dialog box appears, with the "Header / Footer" tab selected. Either click the "Custom Header" or "Custom Footer" button.

3. A "Header" or "Footer" dialog box appears. Click on which section of the header or footer you want the date and or time to appear, either the left, center, or right section.

4. Click the calendar icon to insert the date in the desired header or footer section. Or, click the clock icon to enter the time in the desired header or footer section. You may do both.

5. Click on the "OK" dialog boxes to close them.



Press the "print" button on your browser or select "File" - "Print" to print this tip. Then, return to Microsoft Excel 2003 - Printing Spreadsheets - Add Time and Date to Printed Spreadsheets.
 
Standard disclaimer applies - Read http://tipsforspreadsheets.com/copyright-disclaim.html.