Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Automatically number multiple sheets
I am trying to automatically number 35 sheets within the same workbook, using
the header/footer custom option. I am unable to get each tab to see one another and sucessfully number each tab (sheet) within the workbook. It will start to number a few, then the formatting will stop. I am running Office XP SP3, on XP SP2. All help greatly appreciated. |
#2
|
|||
|
|||
Not quite sure what you're doing, but maybe you could use a macro:
Option Explicit Sub testme01() Dim iCtr As Long For iCtr = 1 To Worksheets.Count With Worksheets(iCtr).PageSetup .LeftHeader = "Number: " & Format(iCtr, "000") End With Next iCtr End Sub I'd record one when I did the page setup manually for one page and then try to generalize it and cycle through the worksheets. If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm itguyintrainin wrote: I am trying to automatically number 35 sheets within the same workbook, using the header/footer custom option. I am unable to get each tab to see one another and sucessfully number each tab (sheet) within the workbook. It will start to number a few, then the formatting will stop. I am running Office XP SP3, on XP SP2. All help greatly appreciated. -- Dave Peterson |
#3
|
|||
|
|||
Your post is confusing.
Headers and footers options do not number worksheets. They number printed pages. To consecutively number printed pages from all 35 worksheets if you're printing, select all sheets by right-clicking on a tab and "select all sheets". Print as one job under "selected sheet(s)". What is it you want to do exactly? Gord Dibben Excel MVP On Wed, 2 Feb 2005 12:31:02 -0800, "itguyintrainin" wrote: I am trying to automatically number 35 sheets within the same workbook, using the header/footer custom option. I am unable to get each tab to see one another and sucessfully number each tab (sheet) within the workbook. It will start to number a few, then the formatting will stop. I am running Office XP SP3, on XP SP2. All help greatly appreciated. |
#4
|
|||
|
|||
"Gord Dibben" wrote: Your post is confusing. Headers and footers options do not number worksheets. They number printed pages. To consecutively number printed pages from all 35 worksheets if you're printing, select all sheets by right-clicking on a tab and "select all sheets". Print as one job under "selected sheet(s)". What is it you want to do exactly? Gord Dibben Excel MVP On Wed, 2 Feb 2005 12:31:02 -0800, "itguyintrainin" wrote: I am trying to automatically number 35 sheets within the same workbook, using the header/footer custom option. I am unable to get each tab to see one another and sucessfully number each tab (sheet) within the workbook. It will start to number a few, then the formatting will stop. I am running Office XP SP3, on XP SP2. All help greatly appreciated. Its not what I want to do but what my boss wants to do. If you were to look under print prieview, he wants to see page 1 of x in the lower right-hand corner for each sheet. He wants it to be done automatically and doesn't want it typed in manually. Printing is not the issue, but inevitably it will show up on the pages once they are printed. Does that make more sense, or have I further confused the issue? |
#5
|
|||
|
|||
If you print the workbook--not just a worksheet...
File|print|Check entire workbook (with the appropriate header/footer in each worksheet). Or even select/group the sheets you want. click on the first and ctrl-click on subsequent. Then print those selected sheets (again with the header/footer set up nicely). If you group your sheets, you can fix the header/footer in one fell swoop. But if you group the sheets, remember to ungroup them. Anything you do to one of the group, you do to each in the group. itguyintrainin wrote: "Gord Dibben" wrote: Your post is confusing. Headers and footers options do not number worksheets. They number printed pages. To consecutively number printed pages from all 35 worksheets if you're printing, select all sheets by right-clicking on a tab and "select all sheets". Print as one job under "selected sheet(s)". What is it you want to do exactly? Gord Dibben Excel MVP On Wed, 2 Feb 2005 12:31:02 -0800, "itguyintrainin" wrote: I am trying to automatically number 35 sheets within the same workbook, using the header/footer custom option. I am unable to get each tab to see one another and sucessfully number each tab (sheet) within the workbook. It will start to number a few, then the formatting will stop. I am running Office XP SP3, on XP SP2. All help greatly appreciated. Its not what I want to do but what my boss wants to do. If you were to look under print prieview, he wants to see page 1 of x in the lower right-hand corner for each sheet. He wants it to be done automatically and doesn't want it typed in manually. Printing is not the issue, but inevitably it will show up on the pages once they are printed. Does that make more sense, or have I further confused the issue? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
editing multiple sheets at once | Excel Discussion (Misc queries) | |||
Multiple sheets selected | Excel Discussion (Misc queries) | |||
count cells over multiple sheets | Excel Worksheet Functions | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
getting data from 2 excel sheets automatically | Excel Worksheet Functions |