Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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... |
#2
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can I uniformly scale all worksheets at once in page set-up in on. | Setting up and Configuration of Excel | |||
adding a new page break to an existing page break | Excel Discussion (Misc queries) | |||
AUTO PAGE NUMBERING DIFFERENTLY FOR A WORKBOOK | Excel Worksheet Functions | |||
excel 2003 page numbering | Excel Worksheet Functions | |||
Linking to Worksheets on Excel -Saved Web Page | Links and Linking in Excel |