Changing Orientations within a Single Printout

When Greg prints his workbook, he would like some worksheets to print in portrait orientation and some to print in landscape orientation. Greg knows he can print the worksheets one at a time, but he would like to print the workbook in one go. He wonders if there is some way to do this.

Actually, it is easier than one would think. Excel allows you to set the page parameters independently for each worksheet in a workbook. Thus, you can set some as landscape and some as portrait and later just print the whole workbook. Excel keeps track and orients the printing properly for each worksheet.

Here's the easy way to set orientation for a group of worksheets:

1. Click the tab of the first worksheet.
2. Hold down the Ctrl key as you click tabs of other worksheets you want to have the same orientation as the first worksheet. Each worksheet tab should appear "highlighted," indicating you are constructing a set of selected worksheets.
3. Choose the Page Setup option from the File menu. Excel displays the Page Setup dialog box. (Click here to see a related figure.) To display the dialog box in Excel 2007, click the Page Layout tab of the ribbon and then click the small icon at the bottom-right of the Page Setup group.
4. Specify the orientation you want to use for the selected worksheets.
5. Click OK.
6. Click on a worksheet tab different than the one that is currently selected. The tabs should go back to normal, indicating that you are no longer working with a selection set.

When you later want to print your worksheets, simply select the worksheets you want to print before doing the print, or display the Print dialog box and specify that you want to print the entire workbook.