ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Auto page numbering for several worksheets (https://www.excelbanter.com/excel-worksheet-functions/17266-auto-page-numbering-several-worksheets.html)

Andy March 11th 05 06:19 PM

Auto page numbering for several worksheets
 
hi,

I have about 30 some worksheet that I need to put consecutive page numbers.
I have only one page per worksheet, but problem is that it needs to be custom
page numbering. I would like to know if anyone has an idea about how to
setup an automated page numbering for all worksheets such that if I change
the first worksheet page number, then page number for all worksheets will
change in result of my first page number, consecutively. Ex. first page
number is A-1, the next should be A-2, and A-3, etc. I need and urgent help.


Thanks.
Andy...

Debra Dalgleish March 13th 05 04:41 AM

Right-click a sheet tab, and choose 'Select All Sheets'
Choose ViewHeader and Footer
Click the Custom Footer button
In the Centre section, type: A-
Click the Page number button
Click OK

With all the pages still selected, click the Print button.
When finished printing, right-click a sheet tab, and choose
Ungroup Sheets

Andy wrote:
hi,

I have about 30 some worksheet that I need to put consecutive page numbers.
I have only one page per worksheet, but problem is that it needs to be custom
page numbering. I would like to know if anyone has an idea about how to
setup an automated page numbering for all worksheets such that if I change
the first worksheet page number, then page number for all worksheets will
change in result of my first page number, consecutively. Ex. first page
number is A-1, the next should be A-2, and A-3, etc. I need and urgent help.


Thanks.
Andy...



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



All times are GMT +1. The time now is 09:12 AM.

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
ExcelBanter.com