How to Adjust a Spreadsheet to One Page in Excel 2013


There are a lot of different ways to modify an Excel spreadsheet to make it print better. Our guide to printing in Excel covers many of those areas, but manually adjusting column and row sizes, or tinkering with margins until you have achieved the right balance of settings can be both tedious and frustrating.

Excel 2013 has a print setting that can take care of much of this for you. It will automatically adjust the size of your spreadsheet so that all of the data fits on one page. You also have the option of choosing to only fit all of your rows or columns on one page if fitting the entire sheet on one page makes the data too small. Our tutorial below will show you how to find and use the setting that adjusts the size of your printed Excel sheet.

 

Here is how to adjust an Excel worksheet to one page –

  1. Open the file in Excel 2013.
  2. Click the File tab at the top-left corner of the window.
  3. Click Print in the left column.
  4. Click the No Scaling button at the bottom of the center column, then click the Fit Sheet on One Page option.
  5. Click the Print button at the top of the window.

These steps are repeated below with images –

Step 1: Open your spreadsheet in Excel 2013.

 

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 option

 

 

Step 4: Click the No Scaling button at the bottom of the window, then click the Fit Sheet on One Page. You will note that there are also options to either Fit All Columns on One Page or Fit All Rows on One Page. If your spreadsheet is particularly large, then one of those options may suit you better. After you select one of these options, the Print Preview section at the right of the window will adjust accordingly. If it seems that the data is too small, and difficult to read, then you may want to try one of the other options on this menu.

adjust excel sheet to fit on one page

 

 

Step 5: Click the Print button at the top of the window.

click the print button

 

 

If one of these automatic print scaling options doesn’t suit your needs, then consider setting a print area instead. This allows you to handpick a section of your spreadsheet to print, which can make the process a little simpler.

birthday t-shirts for boys
vintage t rex t-shirt

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