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.
Step 3: Click the Print option in the left column.
Step 4: Click the No Scaling button under Settings in the center column.
Step 5: Click the Fit All Columns on One Page option. You can then print your document by clicking the Print button.
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.
Matt Jacobs has been working as an IT consultant for small businesses since receiving his Master’s degree in 2003. While he still does some consulting work, his primary focus now is on creating technology support content for SupportYourTech.com.
His work can be found on many websites and focuses on topics such as Microsoft Office, Apple devices, Android devices, Photoshop and more.