B
Bailey
How can I enter different footers on each page in a workbook without all
pages having the same footer?
pages having the same footer?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gord Dibben
Bailey
A "page" is generally considered to be the area of a worksheet that will print
on one sheet of paper. You could have multiple pages on one worksheet and
multiple worksheets in a workbook, each with multiple pages to print.
Do you mean each "worksheet" of a workbook to have different footers for the
pages printed from that worksheet?
Or different footers for each page printed from a single worksheet?
This would be done manually in most cases.
You could do it with VBA code but need a couple of the questions above answered.
Gord Dibben MS Excel MVP
A "page" is generally considered to be the area of a worksheet that will print
on one sheet of paper. You could have multiple pages on one worksheet and
multiple worksheets in a workbook, each with multiple pages to print.
Do you mean each "worksheet" of a workbook to have different footers for the
pages printed from that worksheet?
Or different footers for each page printed from a single worksheet?
This would be done manually in most cases.
You could do it with VBA code but need a couple of the questions above answered.
Gord Dibben MS Excel MVP
B
bailey
I have multiple pages on one worksheet.
Gord Dibben said:Bailey
A "page" is generally considered to be the area of a worksheet that will print
on one sheet of paper. You could have multiple pages on one worksheet and
multiple worksheets in a workbook, each with multiple pages to print.
Do you mean each "worksheet" of a workbook to have different footers for the
pages printed from that worksheet?
Or different footers for each page printed from a single worksheet?
This would be done manually in most cases.
You could do it with VBA code but need a couple of the questions above answered.
Gord Dibben MS Excel MVP
G
Gord Dibben
A unique footer on each page would require a separate setup for each page anda
print job for each.
You could do it with VBA but it would still wind up as separate print jobs.
See Ron de Bruin's site for sample code which would have to be modified.
http://www.rondebruin.nl/print.htm#not
Gord Dibben MS Excel MVP
print job for each.
You could do it with VBA but it would still wind up as separate print jobs.
See Ron de Bruin's site for sample code which would have to be modified.
http://www.rondebruin.nl/print.htm#not
Gord Dibben MS Excel MVP
B
bailey
I only need the center footer to read differently on each page. For
example, on page 1, it should read "Net Cash Flows" and on page 2, it should
read "Net Working Capital", and on page 3, it should read "Summary Tables",
etc. If I enter the center footer on page 1, it is automatically copied to
the remaining pages. Do I have any other options?
Thank you for your help.
example, on page 1, it should read "Net Cash Flows" and on page 2, it should
read "Net Working Capital", and on page 3, it should read "Summary Tables",
etc. If I enter the center footer on page 1, it is automatically copied to
the remaining pages. Do I have any other options?
Thank you for your help.
D
Dave Peterson
Record a macro when you
change the footer for page 1 and then only print page 1
Keep recording when you change the footer for page 2 and print page 2
and keep recording while you are changing the footer and printing that page.
After you're done, stop recoring the macro.
Next time you need to print this stuff, just run the macro that you recorded.
change the footer for page 1 and then only print page 1
Keep recording when you change the footer for page 2 and print page 2
and keep recording while you are changing the footer and printing that page.
After you're done, stop recoring the macro.
Next time you need to print this stuff, just run the macro that you recorded.
B
Bill Sharpe
The simple solution is to put each of your pages on a separatebailey said:I have multiple pages on one worksheet.
worksheet. Then you can specify whatever you want for the footer on each
of the worksheets.
Bill