Handling an Excel spreadsheet that prints out on more than one page can be cumbersome. Additionally, the second page may not have all of the necessary labels, making it difficult to understand the data that you are viewing. Fortunately you can configure your document to reduce the scale of the worksheet and so that everything prints out on one page.
Step 1:
Open your spreadsheet in Excel 2010, then click the “Page Layout” tab at the top of the window.
Step 2:
Click the “Orientation” drop-down menu, then click “Landscape.”
Step 3:
Click the “File” tab at the top-left corner of the window.
Step 4:
Click “Print” at the left side of the window.
Step 5:
Click the “No Scaling” drop-down menu at the bottom of the window, then click “Fit Sheet on One Page.”
 |
Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.
