ExcelBanter - How can I print page 2 of each sheet in a workbook?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How can I print page 2 of each sheet in a workbook? (https://www.excelbanter.com/excel-discussion-misc-queries/16702-how-can-i-print-page-2-each-sheet-workbook.html)

sflower

How can I print page 2 of each sheet in a workbook?

CyberTaz

If I understand your request, the first point to clarify is that "each sheet"
does not have a page 2 - If there are 10 sheets & each one contains 2 pages
of data, each page is still sequentially numbered 1-20.

One option is to select the area to be printed on each sheet and go to
FilePrint AreaSet Print Area. Once you do this for each sheet, go to the
Print dialog box and select Entire Workbook.

HTH |:)
"sflower" wrote:

All times are GMT +1. The time now is 02:39 PM.