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. Contine reading to learn more about printing horizontal pages in Excel 2010.
Printing with the Landscape Orientation in Word 2010
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.
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.
Step 4: Click the File tab at the top-left corner of the window.
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.
Note that you can also quickly access this print menu from your spreadsheet at any time by pressing Ctrl + P.
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.