Instead of working with the default portrait orientation, sometimes it might be more convenient to change the orientation to landscape. To be able to change landscape, we first have to learn how to change the orientation to landscape. Changing the orientation to landscape is mostly necessary when you have a worksheet with so many columns. This article will provide a clear guide on how to get landscape orientation.
Figure 1: Data for which we want to change orientation in Excel
Note, that you can change the sheet to landscape view for a single page or for multiple pages. Let us look at how to change the worksheet orientation to landscape for a single page.
Changing single page orientation to landscape
It is actually much easier to change from page view to landscape for a single page. To do this all you have to do is to select the worksheet you are working on, and the head to Page Layout tab. After that, in the Page Setup group of commands, click on the Orientation drop down menu. From the menu, change page orientation from portrait to landscape.
Figure 2: Changing Excel orientation
Note that changing the orientation of a page will automatically change the text direction as well.
Printing the page in landscape orientation
Now that you have changed the orientation of the worksheet to landscape, perhaps you should also learn how to print it in the same landscape orientation.
To print a page in landscape orientation, you will first have to connect the printer. When you connect a printer via a USB cable, you will be prompted to setup the printer via a setup wizard.
Once you have connected the printer, you will be presented with a window where you can change the orientation from portrait to landscape to suit your needs.
Instant Connection to an Excel Expert
Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.