How to Fit All Columns on One Page in Excel 2013

It is very common for printed Excel spreadsheets to have a column or two of data that spills over onto extra pages. This has the unfortunate effect of doubling the number of printed pages, while also making the spreadsheet difficult to read. You may have attempted some manual fixes to solve this issue, but there is a simple way to fit all of your columns on one page in Excel 2013. Our guide below will show you how to make this adjustment from the Print Preview screen.

Step 1: Open your spreadsheet in Excel 2013.

 

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

fot spreadsheet on one page in excel 2013

 

Step 3: Click the Print option in the left column.

stop printing extra pages with one column in excel 2013

 

Step 4: Click the No Scaling button under Settings in the center column.

fit all columns on page in excel

 

Step 5: Click the Fit All Columns on One Page option. You can then print your document by clicking the Print button.

how to print all columns on one page in excel 2013

 

You will notice that there are other options on that menu as well, including Fit Sheet on One Page, and Fit All Rows on One Page. You can elect to use one of those options instead if they are more appropriate to your current Excel spreadsheet-printing needs.

 

Is your spreadsheet difficult to understand because there are no column labels after the first page? Learn how to repeat the top row on every page in Excel and minimize the confusion that can be caused when people are unsure about which column a cell belongs in.