Page Numbering for Printing Multiple Worksheets

M

Mark White

I want to print a workbook that contains 5 worksheets
where each worksheet is 2 pages in length. How do I make
the printed output reference "1 of 2" and "2 of 2" for
each work sheet instead of "1 of 10, 2 of 10, etc...",
when I print all of the worksheets at one time?

I know that I can select each worksheet and print one at a
time but I was hoping to avoid this scenario.
 
F

Frank Kabel

Hi
as a workaround try the following:
- start recording a macro ('Tools - Macros - Record Macro')
- print the sheets individually
- stop the recording

After this simply invoke this macro
 

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

Top