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.