How to Print a Spreadsheet on One Page in Excel 2013

Excel spreadsheets are notoriously tricky to print, and even worksheets that have been optimized for printing can occasionally present problems. Fortunately there is an option on the Print menu in Excel 2013 that allows you to fit your entire worksheet on one page, with just the click of a button.

This option is best used for spreadsheets that are slightly too big to fit on the page, and are spilling an extra row or column onto another page. This is an unnecessary waste of paper, and it makes the information that much harder for your audience to read. So continue reading below to learn how to fit your printed spreadsheet on just one page.

 

Fit an Entire Spreadsheet on One Page in Excel 2013

The steps in this article are going to show you how to adjust the print settings for this worksheet in Excel 2013 so that the entire worksheet fits on one page. It will not affect other worksheets that you open in the program. Note that Excel will even try and do this to worksheets that will not realistically fit on one page, which can result in text that is much too small to read.

 

Step 1: Open the Excel file containing the spreadsheet that you want to fit on one page.

 

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

click the file tab

 

 

Step 3: Click the Print button in the column at the left side of the window.

click the print button

 

 

Step 4: Click the No Scaling button at the bottom of the center column, then click the Fit Sheet on One Page option. Note that Excel will not automatically adjust the orientation of the page to best suit the layout of the data, so you might find that you achieve better printing results by switching from portrait to landscape as well.

click the fit sheet on one page option

 

 

Step 5: Click the Print button when you have finished adjusting the print settings.

click the print button

 

 

Do you have an entire workbook of sheets that you want to be able to fit to just one page? Find out how and save yourself the headache of needing to manually change the print settings for every worksheet in your workbook.

solveyourtech.com newsletter
vintage t rex t-shirt

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