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.
Step 3: Click the Print button in the column at the left side of the window.
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.
Step 5: Click the Print button when you have finished adjusting the print settings.
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. After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites. His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well. Read his full bio here.
You may opt out at any time. Read our Privacy Policy
