Page Numbering

[Jeff Weinberg]

Is there a way to have page numbering span multiple worksheets in a file? I
would like to be able to print all the worksheets in a file and have the
page numbers in the second worksheet pick up where the page numbers in the
first worksheet ended without having to manually adjust the start point in
worksheet 2.

Please response back to the group.

Thanks.

JWeinberg

 

[Freemini]

I assume the page numbers are set up in your header/footer.

If this is correct then all you need to do is select all the sheets you
want to print by clicking on each sheet tab while holding down the
control key.

This will then print all the selected sheets in the workbook continuing
the page numbers on the subsequent sheets.

Hope this helps.

Mike

 

[Dave Peterson]

Try selecting the first worksheet to print, then ctrl-click on the subsequent
worksheet tabs.

Then do a print preview to see if it worked ok.

 

[Evan]

If the first sheet is to start with something other than "1", set it
with File > Page Setup > Page > First Page Number in that sheet only.
Leave the subsequent sheets on "Auto"