See all How-To Articles

How to Make a Sheet Fit on One Page in Excel & Google Sheets

This tutorial demonstrates how to make a sheet fit on one page in Excel & Google Sheets.

 

fit sheet one page 6

 

Scale a Worksheet to Fit in Excel

Say that you have the following data set with values (A6:J6). If you were to print this data range it would be on two pages.

 

fit sheet one page 4

 

To print your worksheet on a single page, you can use the Scale to Fit feature in Excel. To apply this, just follow the next steps:

1. In the Ribbon, (1) go to Page Layout. In the Scale to Fit group, (2) click on the Width box, and from the drop-down list (3) select 1 page.

 

fit sheet one page 1

 

2. In the Ribbon, (1) go to Page Layout, in the Scale to Fit group, (2) click on the Height box, and from the drop-down list (3) select 1 page.

 

fit sheet one page 2

 

As a result, your data will be printed on a single page.

 

fit sheet one page 3

 

Note: Excel will shrink your data to fit the page, so if you scale it too much it can become difficult to read the data. To see how much you scaled your data look at the number in the Scale box (in this example 93%).

 

fit sheet one page 7

 

Scale a Worksheet to Fit in Google Sheets

Say that you have the following data (A6:J6) and you want to shrink the data to fit the one single page in Google Sheets. To do that just follow the next steps:

 

fit sheet one page 12

 

1. In the Toolbar, (1) go to File and (2) click on Print.

 

fit sheet one page 11

 

2. In the Print Setting area (1) click on the arrow in the Scale box and from the drop-down list (2) choose Fit to page.

 

fit sheet one page 9

 

As a result, the data will shrink to fit on a single page.

 

fit sheet one page 10