Change the page orientation when you are ready to print
- Select the worksheet, worksheets, or worksheet data that you want to print.
- Click File > Print.
- In the Page Orientation drop-down box, under Settings, click Portrait Orientation or Landscape Orientation.
- When you are ready to print, click Print.
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.
Excel Print Options, Tips and Tricks Tutorial
Page Setting in Excel for Print , How to Print Data in Excel
how to print large excel sheet in one page
Frequently Asked Questions
How do I print in landscape mode?
Go to Layout > Orientation, and then select Landscape. Go to File > Print. Under Settings, make sure the orientation box says Landscape Orientation. Select Print.
How do I convert a PDF to landscape in Excel?
Under the "Page Layout" tab, click the "Orientation" option and then select "Landscape." Then create your PDF as usual. You can save Excel files in PDF, even without using Excel.
How to print an Excel spreadsheet portrait or landscape?
Depending upon the size and shape of your data, it may be better to change the orientation of the page to print your spreadsheet landscape rather than portrait. This can be done quite easily: On the Page Layout tab > Page Setup group > Orientation > choose either ‘ Portrait’ or ‘ Landscape’ Now all you need to do is print as normal.
Is there a way to print an Excel spreadsheet?
This can be done quite easily: On the Page Layout tab > Page Setup group > Orientation > choose either ‘ Portrait’ or ‘ Landscape’ Now all you need to do is print as normal. To view how the data will look on the page, view a print preview first
How can I print a page in 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.