Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date in header that is not the current date
You can select all of the worksheets in the workbook at once then choose View
| Headers and Footers and then choose Custom Header and manually enter the date you prefer in the header. All sheets will get the update. After closing the dialog, be sure and select a single sheet because any changes you make to the visible sheet without ungrouping them will also be made on all currently selected sheets. Repeat monthly? "TW" wrote: How do you insert a date other than the current date in a header on various worksheets in a workbook? For example, today'sa date is '16 August 2007', How do I ensure the header for each worksheet shows the date '31 July 2007' and then change this on a monthly basis? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Figuring Vacation Hrs. Earned using Current Date minus Hire Date | Excel Worksheet Functions | |||
I want any date 90 days or older from current date change color | Excel Worksheet Functions | |||
Make date change in excel to current date when opening daily? | Excel Discussion (Misc queries) | |||
current date in header | Setting up and Configuration of Excel | |||
Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions |