Search
Close this search box.

How to Print on One Page in Google Sheets (Fit to Page)

If you often print your work in Google Sheets, I am sure you have faced the issue of some rows or columns spilling to the next sheet (leading to an extra print copy).

While you may want this in some cases, often you can also print on one page and save some paper.

By default, Google Sheets has a specific area that can be printed on one page, but you can change this by forcing it to print more on a single sheet.

In this short tutorial, I will show you how to change the print setting so that you can print on one page in Google Sheets by fitting more content on each page.

So let’s get started!

How to Print on One Page in Google Sheets (Fit to Page)

Suppose you have a dataset as shown below and you want to print this entire dataset on one page in Google Sheets.

Dataset that needs to be printed in one page

By default, Google Sheets will print the first 9 columns (till Store 8) in one sheet and the rest two columns will be printed in the next sheet.

Below are the steps to fit the entire content in one single page and print everything on one page:

  1. Select the dataset that you want to print
  2. Click on the Print icon in the toolbar (you can also use the keyboard shortcut Control + P).Click on the Print Icon in the toolbar
  3. In the Print setting page that opens up, click on the Scale option.Click on the Scale option
  4. Click on the ‘Fit to page’ option.Click on Fit to Page
  5. Click on Next
  6. In the Print window that opens, select the printer and click on the Print button.

The above steps would print the entire content of the worksheet in one single page.

Note that when you use this option, it will try and lower the font to fit the content on one page. In case you have a lot of data in the worksheet, this can lead to font lowering to such a level that it becomes illegible. So make sure you check the Print Setting preview to see how the printed page would look like.

You can also choose to use the options ‘Fit to Width’ print all the columns on one page, while the rows can be printed on multiple columns. Similarly, there is a ‘Fit to height’ option as well.

Also read: How to Autofit Column Width in Google Sheets

Tip to Fit Data on One Page In Google Sheets

While there is an in-built option to ‘Fit to page’ in Google Sheets, it leads to the lowering of font and makes the content smaller.

There are some other ways as well that you can use to try and fit all the content on one page without compromising on the legibility:

  1. Hide rows/columns that you don’t need. This can help squeeze in more rows/columns into a single view and can help fit more content in one single page
  2. Resize the column width to remove some white space and fit more columns on one page. Google Sheets has a specific area in the worksheet (called the Print Area) that it can fit on one page when printing. When you reduce column width, it allows Google Sheets to fit more columns in that same Print Area
  3. Remove any cell padding (if there is).
  4. Remove gridlines (in case you have applied a thick one). This can help squeeze in more rows and columns
  5. Format the cells to occupy minimum space. For example, change the date format to a short one (if you have dates in the dataset). In case you’re using numbers with a thousand separator or decimal points, remove this.

These are just some ways and can help fit data on one page in case you only have a few extra rows/columns spilling over.

So this is how you can fit and print on one page in Google Sheets.

Looking for a great high-quality printer? We highly recommend checking out Epson’s extensive line of printers, ranging from compact and efficient home printers to large multifunction printers for your business.

You may also like the following Google Sheets tutorials:

Most Popular Posts

5 thoughts on “How to Print on One Page in Google Sheets (Fit to Page)”

  1. I have a small spreadsheet i want to print to fit page which is small enough to easily fit an 81/2 x11 sheet. It now prints on less than a quarter of the paper. This is on an android tablet & does not show the icons to use. How do I expand it to fit the page? D

    Reply
    • That’s annoying! Sorry to hear that Dave. If you want it to fit your paper, adjust the print settings by selecting “Paper size” or “Layout” and opting for “Letter” size. Make sure the “Fit to page” option is selected

      Reply
  2. I want to print 4 columns of data that only take up 1/2 of a vertical page in landscape, side by side on the same page. I can’t seem to find a way. Printing 2 pages per page leaves one long column of 4 columns of data and 1/2 of the vertical page blank.

    Reply

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Related Posts

Thanks for visiting! We’re happy to answer your spreadsheet questions. We specialize in formulas for Google Sheets, our own spreadsheet templates, and time-saving Excel tips.

Note that we’re supported by our audience. When you purchase through links on our site, we may earn commission at no extra cost to you.

Like what we do? Share this article!