Page Count with Tabs

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
 
G

Guest

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
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting pages for tab 4
Printing multiple tabs 3
Page numbers across multiple tabs - one sequence 3
Folder/Tabs Newbie Question 2
Printing using Macros for Multiply Co-workers in Excel 2
Page Numbering 1
Partial printing of entire worksheet (1st or 2nd pages only) 4
emailing worksheet... 1

Top