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

jenforgod

New Member
Joined
Jul 20, 2007
Messages
5
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)
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

MorganO

Active Member
Joined
Nov 21, 2006
Messages
483
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

New Member
Joined
Jul 20, 2007
Messages
5
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

Active Member
Joined
Nov 21, 2006
Messages
483
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

New Member
Joined
Jul 20, 2007
Messages
5
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...
 

Forum statistics

Threads
1,181,055
Messages
5,927,862
Members
436,573
Latest member
CMR237

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top