Why is My Spreadsheet Printing So Small in Excel 2013?

I have found that spreadsheets I receive from other people often have some formatting that is already applied. One big one is the print area, which can be a really frustrating thing to solve when only part of your spreadsheet is printing. Many times these formatting issues due to the reuse of spreadsheets that were previously adjusted to accommodate sheets that are now a different size.

This can lead to scenarios where your printed spreadsheet is too small, and very difficult to read. Fortunately this is a problem that you can overcome by changing some print settings back to their defaults. Our guide below will show you two locations to check.

How to Change the Page Scale in Excel 2013

The steps below will assume that there is currently page scaling that is being applied to your Excel spreadsheet, which is causing the printed version of the sheet to be very small. This can occur in one of two ways. The first setting that we will check involves the manual scale of the page. If that setting is correct, then we will check a print setting.

Method 1 – Manual Page Scaling

Step 1: Open your spreadsheet in Excel 2013.

Step 2: Click the Page Layout tab at the top of the window.

click the page layout tab

Step 3: Adjust the values in the Scale to Fit section so that they look like the image below. Width should be Automatic, Height should be Automatic, and Scale should be 100%. These are the default print sizes for an Excel 2013 sheet. If you want to switch to an option that is bigger that what is currently set, but smaller than the defaults, then adjust any of these settings accordingly.

change page scale settings

Method 2 – Print Menu Adjustments

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 Print in the column at the left side of the window.

click the print button

Step 4: Click the button above the blue Page Setup link, then select the No Scaling option.

choose the no scaling option

The Print Preview at the right side of the window should adjust, and your spreadsheet should now appear larger than it previously did.

If your spreadsheet is printing fine, but is either too small or too large on your screen, then you might need to adjust the zoom level. This also makes it possible for you to manually choose how much or how little of your sheet appears on your screen.

solveyourtech.com newsletter

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