How to Print a Page Horizontally in Excel 2010

Microsoft Excel 2010 gives you a significant number of ways to alter how your data is displayed on screen or on a printed document. One common method for changing how a spreadsheet prints is by adjusting the orientation of the sheet. This is the change that you need to make when you want to print a page horizontally in Excel 2010. The actual term for horizontal printing in Excel 2010 is the “landscape” orientation, and it allows you to fit more columns on one sheet while you are printing. Continue reading to learn more about printing horizontal pages in Excel 2010.

How to Print Excel Landscape

Changing the print orientation in Excel 2010 using the method outlined below will only change the orientation for the current document. The default orientation will remain at the vertical, or “portrait” setting. It will also be applied to every page in your worksheet. Note, however, that you will need to change the orientation for each worksheet in your workbook if you want to print every worksheet horizontally.

Step 1: Open the spreadsheet that you want to print horizontally in Excel 2010.

Step 2: Click the Page Layout tab at the top of the window.

excel 2010 page layout tab

Step 3: Click the Orientation drop-down menu in the Page Setup section of the ribbon at the top of the window, then click the Landscape option.

how to print a page horizontally in excel 2010

Step 4: Click the File tab at the top-left corner of the window.

excel 2010 file tab

Step 5: Click Print in the column at the left side of the window, then click the Print button at the top of the window.

excel 2010 print menu

Note that you can also quickly access this print menu from your spreadsheet at any time by pressing Ctrl + P.

More Information on How to Print Horizontally in Excel

  • Alternatively you can click the small dialog box at the bottom-right of the Page Setup section of the ribbon, which will open a new Page Setup pop-up menu. Here you can select the page orientation as well.
  • Microsoft Word allows you to change your page orientation in a similar way. If you change the page orientation of a Word document, it’s also updated on the screen, allowing you to see how your printed document will look without navigating to the Print menu.
  • When you switch your Excel spreadsheet to landscape mode, more of your columns are going to fit on each printed page, but fewer rows are going to fit on each page. If you are relying on your printed layout including specific rows on the same page, then it’s helpful to check the Print Preview section in the Print dialog box menu that you open from the File menu or by pressing Ctrl + P on your keyboard.
  • Google Sheets also allows you to print horizontally, and actually does so by default. If you want to print in Portrait mode in Google Sheets then you will need to adjust that setting by going to File > Print and choosing the Portrait orientation option at the right side of the window.
  • While you are on the Print setup menu in Excel you can change a number of other helpful print settings as well. For example, if you click the No Scaling button you can have Excel automatically fit your rows, columns, or even the entire sheet to one page. This can help to eliminate a lot of the frustrations that occur when printing in Excel.

If your spreadsheet is still extending off the side of your page, you can follow the instructions in this article to automatically have Excel scale your document to fit on one page.

solveyourtech.com newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.