Hello -
I have a spreadhseet with 12 worksheets. I want to print the Page numbers
(starting @ 1) on each of the 12 using a footer and clicking the # icon. I
select all 12 sheets at the same time and do this. However, Page 1 show for
all of them when they are all selected. Additionally, I have tried to make a
PDF of the 12 sheets and it is not allowing me to save one PDF with all 12
sheets. It is asking me to name 12 different files with 1 each. I believe the
2nd problem is based on the first. Any ideas of how to fix this? Thanks!

IF - AND ONLY IF - YOU HAVE 1 PRINTED PAGE PER TABBED SHEET

If you want the second sheet to be numbered Page 2, then use the Page Setup
dialog box to set the First Page Number (it's at the bottom of the left-most
tab). Do the same for each of the other sheets

Otherwise, select all the sheets you want printed, then go to the Print
Preview screen. You'll see that Excel figures out how many pages there are
and numbers each one accordingly.

If I select the tabs I want printed, and then send it to the Adobe print
driver, it allows them all to go to the same pdf file





"George" wrote:

Hello -
I have a spreadhseet with 12 worksheets. I want to print the Page numbers
(starting @ 1) on each of the 12 using a footer and clicking the # icon. I
select all 12 sheets at the same time and do this. However, Page 1 show for
all of them when they are all selected. Additionally, I have tried to make a
PDF of the 12 sheets and it is not allowing me to save one PDF with all 12
sheets. It is asking me to name 12 different files with 1 each. I believe the
2nd problem is based on the first. Any ideas of how to fix this? Thanks!

Hello Duke -

Thanks for the reply. For some reason, it is still not working. And, yes
there is only 1 page per sheet. Any other ideas? I think I have tried
everything? I'm just not sure why excel is not figuring out that the page
numbers should not all be 1. I'm guessing it has to do with some formatting
issues I have within the sheet.

Thanks,


"Duke Carey" wrote:

IF - AND ONLY IF - YOU HAVE 1 PRINTED PAGE PER TABBED SHEET

If you want the second sheet to be numbered Page 2, then use the Page Setup
dialog box to set the First Page Number (it's at the bottom of the left-most
tab). Do the same for each of the other sheets

Otherwise, select all the sheets you want printed, then go to the Print
Preview screen. You'll see that Excel figures out how many pages there are
and numbers each one accordingly.

If I select the tabs I want printed, and then send it to the Adobe print
driver, it allows them all to go to the same pdf file





"George" wrote:

Hello -
I have a spreadhseet with 12 worksheets. I want to print the Page numbers
(starting @ 1) on each of the 12 using a footer and clicking the # icon. I
select all 12 sheets at the same time and do this. However, Page 1 show for
all of them when they are all selected. Additionally, I have tried to make a
PDF of the 12 sheets and it is not allowing me to save one PDF with all 12
sheets. It is asking me to name 12 different files with 1 each. I believe the
2nd problem is based on the first. Any ideas of how to fix this? Thanks!