Using Page Layout
To change the page orientation in Excel using thePage Layoutoption:
2.
Using Print Preview
Another way to change the page orientation of an Excel spreadsheet is when printing.
This method is convenient because it allows you to preview how your worksheet will look before you print it.
Here’s how to change page orientation using the print preview window.
Changing the orientation of each sheet would be time-consuming, especially if the workbook contains many worksheets.
All worksheets in the workbook should now have the landscape orientation.
A
To set the page orientation to portrait instead, enter the following code in theImmediatewindow and pressEnter.
A
