The tabs should go back to normal, indicating that you are no longer working with a selection set. Excel displays the Page Setup dialog box.
Each worksheet tab should appear 'highlighted,' indicating you are constructing a set of selected worksheets. Hold down the Ctrl key as you click tabs of other worksheets you want to have the same orientation as the first worksheet.
Here's the easy way to set orientation for a group of worksheets: Excel keeps track and orients the printing properly for each worksheet. Thus, you can set some as landscape and some as portrait and later just print the whole workbook. Excel allows you to set the page parameters independently for each worksheet in a workbook. He wonders if there is some way to do this.Īctually, it is easier than one would think. Greg knows he can print the worksheets one at a time, but he would like to print the workbook in one go. When Greg prints his workbook, he would like some worksheets to print in portrait orientation and some to print in landscape orientation.
