Page Count with Tabs

T

Tom

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
 
M

Mike Rogers

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
 
T

Tom

Thanks That did it.

Mike Rogers said:
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
Click to expand...
 
Top