How to Print Horizontally in Excel (4 Methods)

When users have a larger dataset it’s convenient to print horizontally in Excel. Though Excel by default prints worksheets in Portrait Page Orientation. Printing horizontally won’t be an issue if Excel is able to automatically switch page orientations depending on the data or selection. But Excel can’t change page orientation on its own. As a result, it becomes vital to change the page orientation if users want a decent printout. Because Excel is designed to execute calculations in convenient ways not arranging page layout for better print view.

In this article, we demonstrate multiple ways to print worksheets horizontally in Excel.


Download Excel Workbook


4 Easy Ways to Print Horizontally in Excel

As we mentioned earlier, there are several options to perform horizontally print for single or multiple worksheets. Use any one of the following methods to print horizontally in Excel.

Method 1: Changing Page Orientation from Page Layout Tab

🔺 Go to the Page Layout tab > Click on Orientation (from the Page Layout section) > Select Landscape.

Page layout-How to Print Horizontally in Excel

After selecting the Page Layout as Landscape, go to the Print section by pressing CTRL+P. You can make other customizations from the Print section Settings.

Read More: How to Print Landscape in Excel (3 Easy Methods)


Method 2: Using Page Setup Dialog Box to Print Horizontally

🔺 Another way to select Page Orientation is the Page Setup dialog box. Hover to Page Layout > Click on the Icon within the Page Setup section.

Page Setup-How to Print Horizontally in Excel

🔺 You can also bring out the Page Setup dialog box using the Page Setup option under the Printer Settings.

Page Setup

🔺 Clicking on the Page Layout Icon or Page Setup Option brings the Page Setup dialog box. From the dialog box, Select Landscape as Orientation in the Page section.

⧫ Click OK.

Page Setup dialog box

Afterward, you can choose any means to Print the desired worksheet.

Read More: How to Fit to Page and Print in Excel (10 Ways)


Similar Readings:


Method 3: By Changing Page Orientation in Printer Setting

There are a ton of options to customize the Print view under the Printer Settings. In this case, we just change the Page Orientation to Landscape using the Page Orientation drop-down options.

🔺 Click on the File ribbon.

Print Setting-How to Print Horizontally in Excel

🔺 Clicking File brings the options. Select Print (from the options) > Choose Landscape Orientation under Settings from Page Orientation drop-down options.

Selection

Read More: How to Set Print Preview in Excel (6 Options)


Method 4: Print Horizontally Using a Pre-formatted Excel Template

Also, we can make a blank worksheet or worksheets as Excel Templates (.xlsx or .xlsm file) to automatically print data in a horizontal layout.

Step 1: Select a worksheet or worksheets. In case, you want to select multiple worksheets, just hold SHIFT (for adjacent) or CTRL (for non-adjacent) then select the worksheets of your desire.

Template-How to Print Horizontally in Excel

Step 2:  Move to the Page Layout tab > Select Orientation (from the Page Setup section) > Choose Landscape.

Page layout

Step 3: Go to the File tab.

Selection

Step 4: Select Save As then Click on Browse.

page orientation

Step 5: Choose a Folder (i.e., Desktop > Preferred Folder) to save the file. Assign the file a Name and Select the Save as type as Excel Template.

Save file type

🔺 You can print the worksheet horizontally using the Template, every time you use it as your workbook.

Final outcome

Related Content: How to Adjust Print Settings in Excel (8 Suitable Tricks)


Conclusion

In this article, we demonstrate several ways to print horizontally in Excel. Hope these shown methods excel in their purpose in your case. Comment, if you have further inquiries or have anything to add.


Related Articles

Maruf Islam

Maruf Islam

My self, Maruf Islam, an engineer and Excel & VBA Content developer on Exceldemy. I enjoy solving problems, finding workable solutions, and most of the part I really like to take on challenges. On Exceldemy I write articles discussing various way outs of Microsoft Excel's stuck ons.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo