Print multiple sheets with different orientations
6,747
With the Page Setup
option you can determine orientation for each work sheet separately.
It will print the worksheets accordingly.
Related videos on Youtube
Author by
Crash893
Updated on September 17, 2022Comments
-
Crash893 almost 2 years
I have a multisheet Excel Spreadsheet.
Some pages are setup as Portrait others are setup as Landscape.
Is there a way to define which pages should print as Portrait or Landscape, or is it an all one way or the other type of thing ?
-
TheModularMind over 14 yearsfor each worksheet, select the range you need to print and set that as the print area for that sheet (in pre-2007 versions this is easier the other way round, now I come to think of it; Page Setup > Print area, use the range selection icon or just type in the box), set the orientation here too. Unfortunately no way to do this for multiple sheets at once (grouping does not do it), but if you plan ahead and set up one sheet correctly, then copying that sheet will keep the properties the same
-
Crash893 about 11 yearswow this is from 09 i don't even remember what this is for but i checked and it works so thanks