| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Page Count with Tabs
I have a spreadsheet that has 3 tabs. Each tab prints out 3 pages. How can I
get Excel to # the pages 1-9? It keeps printing 1-3 three times. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Page Count with Tabs
Tom
If you group your worksheets they will number from 1 to 9. Right click on the first tab and select the "Group" command, then print. (Make sure you select "Active Worksheet") Remember to ungroup them before you make any changes, because any changes to one sheet will affect all sheets. Hope this Helps Mike Rogers "Tom" wrote: I have a spreadsheet that has 3 tabs. Each tab prints out 3 pages. How can I get Excel to # the pages 1-9? It keeps printing 1-3 three times. Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Page Count with Tabs
Thanks That did it.
"Mike Rogers" wrote: Tom If you group your worksheets they will number from 1 to 9. Right click on the first tab and select the "Group" command, then print. (Make sure you select "Active Worksheet") Remember to ungroup them before you make any changes, because any changes to one sheet will affect all sheets. Hope this Helps Mike Rogers "Tom" wrote: I have a spreadsheet that has 3 tabs. Each tab prints out 3 pages. How can I get Excel to # the pages 1-9? It keeps printing 1-3 three times. Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Page Count with Tabs
Tom,
I am glad it helped, thanks for the feedback Mike Rogers "Tom" wrote: Thanks That did it. "Mike Rogers" wrote: Tom If you group your worksheets they will number from 1 to 9. Right click on the first tab and select the "Group" command, then print. (Make sure you select "Active Worksheet") Remember to ungroup them before you make any changes, because any changes to one sheet will affect all sheets. Hope this Helps Mike Rogers "Tom" wrote: I have a spreadsheet that has 3 tabs. Each tab prints out 3 pages. How can I get Excel to # the pages 1-9? It keeps printing 1-3 three times. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Faulty Page Tabs | Excel Discussion (Misc queries) | |||
| Page Break Problem | Excel Worksheet Functions | |||
| For Hector Miguel - Inserting page numbers in cell | Excel Discussion (Misc queries) | |||
| Page scaling & Page break preview prob | Excel Discussion (Misc queries) | |||
| Page Numbering between tabs | Excel Discussion (Misc queries) | |||
Hybrid Mode
