How to Print a Two Page Spreadsheet on One Page in Excel 2010

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.”

If your spreadsheet has a lot of individual columns that you need to combine into a smaller number, then the concatenate Excel formula can help a lot. It provides a quick way for you to combine different cells of data without needing to manually edit that data.