How to Fix When Printing Too Small in Excel & Google Sheets

Written by

Mel Jenkins

Reviewed by

Laura Tsitlidze

Last updated on March 28, 2023

This tutorial demonstrates how to fix when printing too small in Excel and Google Sheets.


printtosmall intro


Scale in Print Preview

If the text in your worksheet is printing too small, it may be that your worksheet has been scaled to fit into a specific number of pages. This means that Excel automatically decreases the font size of the text in Print Preview and Print in order to fit the contents into the required number of pages.

  1. In the Ribbon, go to File > Print (or press CTRL + P on the keyboard).
  2. Check the Settings to see if Fit Sheet on One Page is set as a print option.


printtoosmall fit sheet


  1. Click on the drop down box, and choose No Scaling to reset the size of the print.


printtoosmall no scaling


Scale in Page Setup

  1. In the Ribbon, go to Page Layout > Page Setup and then click in the bottom-right corner of the group.


printtoosmall ribbon


  1. In the Page Tab, check the Scaling. As you can see in the example below, it is set to Fit to 1 page wide by 1 page tall.


printtoosmall page setup


  1. You can adjust the Fit to by clicking on the little arrow to the right of the page tall box to increase the number of pages to print and thus increase the print size.


printtoosmall adjust tall


  1. Alternatively, you can click in the Adjust to toggle box and adjust the % to normal size to your liking.


printtoosmall adjust percentage


Change Font Size

You may find that your font size in your Excel worksheet is just too small for printing.

  1. In your Excel screen, first check to see if you are zoomed to more than 100% and check your font size.


printtoosmall adjust zoom


  1. If you are zoomed in above 100%, you’ll have the illusion that the font is bigger than it actually is. Change the zoom setting to 100% by sliding the little black slider to the left until the zoom percentage reaches 100%.


printtoosmall 100 zoom


  1. Notice that your font probably appears quite small!


printtoosmall show font


  1. Increase the font size by clicking the larger A to the right of the font size box, or in the font size drop down, choose a larger font size. You can also change the font size using the keyboard.


printtoosmall adjust font


  1. Click Print Preview to see your changes.

Printing Too Small in Google Sheets

Google Sheets can have the same printing problems as Excel does.

  1. In Print Preview in your Google sheet, check to make sure that your scaling is not set to a “Fit to…” option.


printtosmall gs fit to sheet


  1. If it is set to, for example, Fit to height, choose another option from the Scale drop down (e.g., Normal (100%)).


printtoosmall gs normal scale


  1. Then, check whether your font size is too small. To fix this, select the data, and then choose the required font from the font size drop down on the Toolbar.


printtoosmall gs font size

AI Formula Generator

Try for Free

See all How-To Articles