Printing Sheets to a Page - Oct 22

  • Thread starter Thread starter Rod Togo
  • Start date Start date
R

Rod Togo

I have Excel 2000. I have a single file with 25
worksheets. I am trying to print these 25 worksheets
such that 2 sheets print to a single page (all 25 sheets
have the same saved print area). It seems like Excel
should allow me to do this, but no matter what I try, all
25 sheets continue to print to individual pages. Thanks,
Rod
 
Rod
There is no built-in way to do what you want because there is an
infinite number of variations of doing such. What you have to do is insert
a new blank sheet and copy what you want printed from two sheets to that one
sheet, then print that one sheet.
That, of course, is tedious if you have a bunch of sheets. In that case
you should write a macro to do it for you. Post back with ranges and sheet
names details if you want to pursue the macro route. Also tell us what
sheets you don't want included in the printout. HTH Otto
 
Back
Top