Page Count with Tabs

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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...
 
Back
Top