Home

Microsoft Excel [email protected]

Microsoft Excel 2007

Microsoft Excel 2003

Forums

Microsoft Excel 2003 - Printing Spreadsheets

Add Time and Date to Printed Spreadsheets

Summary: Hard copies of spreadsheets can contain the time and date they were printed.

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.

Add: Del.icio.us | Digg | Furl | My Yahoo!

Last Modified on: August 21, 2008, at 8:34 A.M. EDT

Return to the Microsoft Excel 2003 - Printing Spreadsheets page.

Print this tip.

- Subscribe!

Search the Site: