uniform headers on Excel worksheets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Timbertoe - 11 Oct 2006 12:11 GMT

I want to print a worksheet each week from one workbook. I want the headers
to be uniform from worksheet to worksheet without having to enter the text
for each worksheet. Additionally, I would like to have the date of the last
day to pring in the header. Who knows the secret?

Reply to this Message

Pete_UK - 11 Oct 2006 19:23 GMT

You can set up identical headers in all worksheets by grouping them all
and apply the header once. Right-click on a sheet tab and click on
Select All Sheets. Then click on File | Page Setup | Header/Footer tab
then click Custom Header and enter your text into one of the three
panels. If you want to enter the current date, click on the symbol
which looks a bit like a calendar - "7" covering "6".

Once this is done, OK your way out of it, and then right-click a sheet
tab once more and Ungroup Sheets.

Hope this helps.

Pete

> I want to print a worksheet each week from one workbook. I want the headers
> to be uniform from worksheet to worksheet without having to enter the text
> for each worksheet. Additionally, I would like to have the date of the last
> day to pring in the header. Who knows the secret?

Reply to this Message

FloMM2 - 12 Oct 2006 09:56 GMT

Timbertoe,
Or you could setup one worksheet, then save as a Template.
Then everytime you open the template, save as "New Name ", Save as type:
*.xls.
This way if you decide to change the format, change your template only. The
next time you open the worksheet and save, it will be as the new template.
Hope this helps.

> You can set up identical headers in all worksheets by grouping them all
> and apply the header once. Right-click on a sheet tab and click on
[quoted text clipped - 14 lines]
> > for each worksheet. Additionally, I would like to have the date of the last
> > day to pring in the header. Who knows the secret?

Reply to this Message