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

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

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

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