Need footer to have "page# of #" for ws and page #

[jenforgod]

I've created a workbook of math timed tests in Excel.

Each Header is specific as to what problems are in that worksheet.

The footer is the same for each one and needs to look like this:

LEFT: copyright 2007

CENTER: Page 1 of 2 (pages in worksheet)

RIGHT: Page #(pages in workbook)

If I select all of the sheets and try to change the bottom to reflect a portion of this, it will change all the headers to be the same and they have to remain different.

How can I create this footer automatically)

 

[MorganO]

In the center section of the custom header window place the following:

Page &[Page] of &[Pages] (pages in worksheet)

This will give you what you need I believe.

The &[Page] code is created with button with the # on it

Then &[Pages] code is created with the button with ++ on it.

Hope this helps.

Owen

 

[jenforgod]

pages in worksheet and pages in workbook needed in footer...

I guess I should have clarified more....

I need to have the pages in the worksheet


AND


the pages in the workbook...

 

[MorganO]

After looking through all the formatting codes available for the header and footer, I don't see an option for putting the number of workbook pages in it. I don't believe what you are asking for is possible.

Sorry I couldn't help.

Owen

 

[jenforgod]

header footer page number for worksheet AND workbook on page

You can do that when you print the whole workbook.... I want to be able to do both.

Try it by putting the "&page of &pages" thing on the footer to a few pages on a worksheet and then do more than one worksheet. Select all the tabs and do a print preview and you'll see what I mean...