Printing multiple page setups
Posted by peter rouse on February 15, 2002 7:03 AM
I have a spreadsheet covering about 250 rows, parts of which I want to print.
Some rows have a length more suitable for Landscape, some more suitable for portrait.
Using Set Print Area, and highlighting the various non contiguous areas using the control key, I can create a sheet with two or more seperate areas for printing. But I cannot select these areas for individual page setup, although when I go to Print Preview, it shows each of the areas I have selected as seperate pages. Creating a landscape format for page 1 means pages 2 and 3 take landscape. and vice verca.
Is there a way, in a single spreadsheet, of having multiple set print areas with different page formats?