Say you are the admin of a department and you want that all the printed pages will use the same printing template. You cannot choose the worksheets randomly.Ĭreate a template that will use landscape page orientation and other changes (by default) In this way, you can change either the active worksheet or the entire workbook. You can also change the page orientation when you’re printing your worksheet. Changing the page orientation when you’re printing your worksheet If you check now the worksheets individually, you will find that all the worksheets’ page orientation has been changed to Landscape from the default Portrait. Just go to Page Layout tab => in the Page Setup group of commands => click on the Orientation drop-down => and select from Portrait to Landscape. # Changing orientations for all the worksheets in a group But if you have grouped all the worksheets in your workbook, right-click on any worksheet and choose the option Ungroup Sheets from the menu. When you will want to break the grouping, just select a worksheet that is not a member of the group. When two or more worksheets are grouped, you will see word appears at the title bar of your worksheet. All the worksheets of your workbook will be grouped. Right-click on any of the worksheets => and choose the option Select All Sheets from the menu. To group all the worksheets of a workbook, you can use the above way (select a worksheet => press CTRL key on your keyboard => select all the worksheets one by one). In the following image, I have made a group with Data1 and Data2 worksheets.Ģ) Grouping using all the worksheets available in the workbook Select a worksheet at first, then press CTRL key on your keyboard and select the other worksheets that you want to add to the group. When you want to group some of the Excel worksheets (not all) and randomly, use this way. # Grouping Excel worksheets to change all of their page orientation If you want to change the orientation of a group of worksheets if you have to make a group with the worksheets at first.
If you want to change the orientation of a single page, first select the worksheet and then go to Page Layout tab => in the Page Setup group of commands => click on the Orientation drop-down => and select from Portrait to Landscape.Ģ) Multiple worksheets orientation change In this process, you can change the page orientation of a single worksheet or a group of worksheets. Read more Change the page orientation (single or group of worksheets)
0 kommentar(er)
