Sometimes it is convenient to use Landscape page orientation rather than the default Portrait orientation, especially when you have data with a lot of columns. Say, you have a worksheet like the following image.
In this article, I will show you how to change the orientation of this worksheet to landscape from the default portrait orientation.
Change the page orientation (single or group of worksheets)
In this process, you can change the page orientation of a single worksheet or a group of worksheets.
1) Single worksheet orientation change
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.
2) Multiple worksheets orientation change
If you want to change the orientation of a group of worksheets if you have to make a group with the worksheets at first.
# Grouping Excel worksheets to change all of their page orientation
There are two cases here:
1) Grouping Excel worksheets randomly:
When you want to group some of the Excel worksheets (not all) and randomly, use this way. 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. In the following image, I have made a group with Data1 and Data2 worksheets.
2) Grouping using all the worksheets available in the workbook
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). But there is a better way.
Right-click on any of the worksheets => and choose the option Select All Sheets from the menu. All the worksheets of your workbook will be grouped.
All the worksheets are now in a group.
When two or more worksheets are grouped, you will see [Group] word appears at the title bar of your worksheet.
When you will want to break the grouping, just select a worksheet that is not a member of the 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.
# Changing orientations for all the worksheets in a group
The procedure is as above. 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.
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.
Changing the page orientation when you’re printing your worksheet
You can also change the page orientation when you’re printing your worksheet.
In this way, you can change either the active worksheet or the entire workbook. You cannot choose the worksheets randomly.
Create a template that will use landscape page orientation and other changes (by default)
Say you are the admin of a department and you want that all the printed pages will use the same printing template.
To fulfill this purpose, you can create a workbook template that everyone in your office can use to create new workbooks.
Let’s create the template step by step
1) Create a new workbook
2) Select a worksheet or a group of worksheets on which you want to apply the page orientation and other changes
How to select Excel worksheets?
- a) A single worksheet
Click on the sheet that you want to select. Say I want to select the Data2 worksheet, so I will click on it.
But sometimes the worksheet name might not be visible. In that case, use these small left and right arrow icons to scroll to left and right.
To scroll to the first and last worksheet of a workbook, you have to press the CTRL key on your keyboard and then left-click on the mouse when your mouse pointer is on the left arrow icon and right arrow icon respectively.
If you want to see all the worksheets in a workbook, just right-click in between these arrow icons. You will see all the worksheets in a workbook.
- b) Selecting two or more adjacent worksheets
To select two or more adjacent worksheets, select the first worksheet name => now press and hold the Shift key on your keyboard => click on the last worksheet name to select.
All the worksheets between the first and last selected worksheets will be selected.
- c) Selecting two or more non-adjacent worksheets
To select two or more non-adjacent worksheets in a workbook, select the target worksheets pressing and holding the CTRL key on your keyboard.
- d) Selecting all the worksheets in a workbook
You can select all the worksheets in a workbook in two ways:
- The dumb way: Select the first worksheet => Press and hold the CTRL key on your keyboard => Select all the worksheets one by one. All the worksheets will be selected.
- Smart but still dumb: Select the first worksheet => Press and hold the Shift key on your keyboard => Select the last worksheet name. All the worksheets will be selected.
- The real smart way: Just right-click on a worksheet. And click on this option Select All Sheets from the menu. All the worksheets in the workbook will be selected.
3) Now you have selected the worksheet or a group of worksheets on which you want to apply landscape orientation and other formatting changes.
Go to Page Layout tab => In the Page Setup group of commands => Click on the Orientation drop-down => And choose Landscape option instead of Portrait.
4) Make other changes if you feel necessary
You can also make other changes like setting up the margins for every page, page size, you can use your company logo on the header and footer.
5) Now save this workbook as a template so that you or others in your office can use it later.
Click on the File tab and Save the file as a template. Say I save the file with the name “My Printing Template”.
To save a workbook as a template, you have to choose either .xltx or .xltm file extensions. You must choose .xltm extension if your workbook has a Macro.
Now my template has been saved.
How to use an Excel template?
Click on the File tab.
Then click on the New tab. On the right pane, select the PERSONAL link. You will find that your created custom template is showing here. Click on it.
A new workbook (named as “My Printing Template 1”) will be created with all your changes made to the template. This new workbook will not have an extension because it is not saved yet.
Now use this workbook to pour your data and then print with the changes that you have made with the Template Workbook.
Download Working File
So, these are my ways of changing the orientation of a worksheet to the landscape. Hope this helps you.
How do you change the orientation of your worksheet? I will be happy if let me know in the comment box.