30 Advanced Excel Tips for 2026

Excel Champs / Excel Basics / How to Print Data on One Page in Excel
By Puneet Gogia (Microsoft MVP)

How to Print Data on One Page in Excel

30+ Advanced Excel Tips for 2026

No spam. Only Excel Stuff. God Promise. 😊

Press Ctrl + P, open the last drop-down under Settings (it normally reads No Scaling) and choose Fit Sheet on One Page. The preview updates straight away, so check the text is still readable before you print.

For a long list, choose Fit All Columns on One Page instead: Excel shrinks the width to one page and lets the rows run on to as many pages as they need. Add Page Layout → Print Titles → Rows to repeat at top so the header row appears on every page. Fit All Rows on One Page does the reverse.

For finer control, use the Page Layout → Scale to Fit group: set Width to 1 page and leave Height on Automatic, or set both to Automatic and type a fixed Scale between 10% and 400%.

Free up space before you shrink anything: switch to Page Layout → Orientation → Landscape, pick Page Layout → Margins → Narrow, and hide columns you don’t need on paper. Scaling is saved per worksheet, not per workbook, so set it on each sheet you print or group the sheets first.

If Fit Sheet on One Page makes everything tiny, Excel is scaling to a used range larger than your data, usually because of a stray value or formatting far below or to the right. Press Ctrl + End to see where Excel thinks the sheet ends, delete the extra rows and columns and save, or set a print area with Page Layout → Print Area → Set Print Area so only your data is scaled.

You sometimes print a report or a data set from your Excel spreadsheet. But that data goes over a single page. In this situation, you can use an option (there are three options) to fit the entire data on a single page.

In this tutorial, we will learn about these options and how to use them correctly. So, let’s get started. Let’s take an example which we are going to use here.

print-data-on-one-page

In this example, we have data that will take six pages to print.

Print on One Page Option in Excel

  1. Click on the File Tab.
  2. Then click on Print.
  3. Now, go to the Scaling drop-down (the last option under Settings, which shows No Scaling by default).
  4. Select the option you want to use to fit on a single page.
print-on-one-page-option

As you can see, there are three options that you can use. These options work in different ways, so let’s understand them individually.

Fit Sheet on One Page

It fits the entire data on a single page. This option is useful when your data is only a little more than a single page. The more data you have, the less likely this option will help you.

With the above example, the “Fit Sheet on One Page” option compresses the entire data on a single page. This data takes six pages initially.

fit-sheet-on-one-page

As I said, if the data is more than two pages and you use this option, it fits the data on a single page in a way that it becomes hard to read when you take the print. So, you need to check the size of the data you want to fit on a single page.

Fit All Columns on One Page

This option fits only columns on a single page and doesn’t change the rows scaling. When you use it with data that is originally six pages while printing, it fits that data to 3 pages, but only by scaling it down until all the columns fit on the width of the page.

fit-all-columns-on-one-page

Fit All Rows on One Page

This option fits all rows to a single page and doesn’t change the column scaling. And now, when we use this option, it scales all the rows to a single page and only makes it on one page.

fit-all-rows-on-one-page

In our data, we have more rows of data than columns, and that’s why this doesn’t work. It makes data so small that it won’t be readable when you take the Print.

Notes

  • To use these options correctly, you need to check which option works for your data, so that it is still readable when you print it on paper (use the print preview to check).
  • These options are sheet-level settings and are saved with each worksheet. If you are printing a different worksheet or workbook, you must apply the settings again.

Using Custom Scale

In the same way, you can also use the custom scaling option to fit data onto one page. When you click on the “Custom Scaling Option”…

custom-scaling-options

…it opens the Page Setup dialog box, where you can change the scale percentage.

change-scale-percentage

In the “Adjust to” option, you can change the scale percentage (from 10% to 400%) to fit your data onto one page.

Then, from the next option, “Fit to”, you can enter the number of pages to fit into. If you want to fit columns into 1 page and rows into three pages, you need to enter 1 in “page(s) wide” and 3 in “tall”. And if you leave the “tall” box empty, Excel uses as many pages as the rows need, while all the columns fit on one page wide.

number-of-pages-to-fit

Other Options to Fit Data into One Page

1. Change Font Size

You can change the font size for the entire data and then adjust the width of the columns. It makes the data smaller than its original size.

change-font-size

You can use the keyboard shortcut Ctrl + A to select all the cells in the sheet and then change the height of rows and width of the columns.

2. Hide Rows and Columns

You can also hide the columns and rows you don’t need in the Print. It will make the data size less than its original size and help you to fit it into a single page.

hide-rows-and-columns

And once you take the printout, you can unhide those hidden rows and columns. Even when you hide rows and columns, you may still need to change the width of columns and the height of rows, but that’s OK.

3. Change the Margin to Fit into One Page

When your data is just a little more than a single page, one of the best ways to fit it onto a single page is to change the margins.

change-margin-to-fit-to-one-page

Go to Page Layout > Margins > Narrow. Selecting a narrow margin gives you more space on a single page to fit data.

And if you want to change the margins further, go to Page Layout > Margins > Custom Margins. When you click on Custom Margins, it opens the Page Setup dialog box, where you can change the margins the way you want.

custom-margin-dialogbox

You can also reduce the space reserved for the header and footer in the same dialog box, which gives more space at the top and bottom of the page.

4. Changing Page Orientation

You can also change the page orientation before printing. If the data has more columns that can’t fit on a single page, you can change the orientation to landscape.

change-page-orientation

Go to Page Layout > Orientation > Landscape. And once you print the data, you can change the orientation back to portrait.

5. Print Selected Data Only

There is an option allowing you to print a specific range of cells from the sheet. You need to select the data which you want to print.

print-selected-data-only

When you select “Print Selection”, it only prints the selected data range. But if the selected data size is big enough to not fit on a single page, you must use other options to fit it into a single page.

6. Page Break Preview

When you go to the View Tab and click the Page Break Preview button, it switches to a view where you can see the page breaks.

page-break-view

With this view, you can drag the blue page break lines to include more data on a page. When you drag a break line to include more rows or columns, Excel scales the page down to fit them.

Fit to One Page from the Page Layout Tab

You can set the same thing without opening the Print page. Go to Page Layout ➜ Scale to Fit, and set Width to 1 page and Height to 1 page (or leave Height on Automatic to fit only the columns). The Scale box shows how much Excel has shrunk the data, which helps you check that it will still be readable.

And if your data still takes more than one page, use Page Layout ➜ Print Titles to repeat the header row at the top of each page.

Fit to One Page with VBA

If you print the same report again and again, the following macro sets the active sheet to print all the columns on one page wide, with as many pages tall as needed:

Sub fit_columns_on_one_page()
With ActiveSheet.PageSetup
.Zoom = False
.FitToPagesWide = 1
.FitToPagesTall = False
End With
End Sub

To fit the whole sheet on one page, change FitToPagesTall to 1. The Zoom = False line is needed, otherwise Excel uses the scale percentage and ignores the fit settings.

Frequently Asked Questions

Why is my data too small after fitting it on one page?

Excel shrinks the whole page to fit, so a lot of data becomes tiny. Fit only the columns on one page, switch to landscape, narrow the margins, or hide the columns you don’t need to print.

Why does Excel still print an extra blank page?

Usually because of formatted or used cells beyond your data. Set a print area (Page Layout ➜ Print Area ➜ Set Print Area) on your data, then fit it to one page.

How do I fit all sheets on one page each?

Select all the sheets (right-click a sheet tab ➜ Select All Sheets), then choose Fit Sheet on One Page. The setting goes to every selected sheet. Ungroup the sheets afterwards so you don’t edit them all at once.

Puneet Gogia

Written by

Puneet Gogia

Microsoft MVP — Excel · Founder, Excel Champs

Twelve years of teaching Excel, and a decade before that using it as a data analyst. Every tutorial here is written from a file I actually built.

3M+ readers helped
1,000+ tutorials written
Since 2015 teaching Excel

Leave a Comment