Print Ranges

M

margob111

Can you combine multiple spreadsheets so the pages print consecutively; i.e.,
spreadsheet 1 has 11 pages and the footer needs to read 1 of ?, 2 of ?;
spreadsheet 2 has 3 pages and needs to start with 12 of ?, etc.
 
J

JWolf

If you are speaking of two workbooks each with one worksheet, then:
In page setup of each, header/footer, custom footer, enter: Page &[Page]
of 14
On second workbook, in page setup, change: First page number, from: auto
to 12.
Print.

If you are speaking of two worksheets within one workbook, then:
In page setup of each, header/footer, select: page 1 of ? or in custom
footer enter: Page &[Page] of &[Pages]
Select both worksheets: (hold down ctrl and click second tab) and then
print, Excel will automatically calculate total pages and print the
first worksheet followed by the second.

If you are speaking of 11 worksheets on one workbook and 3 on a second
workbook, a combination of above will work.
 
Top