Autofit Page in Excel: Fit a Worksheet to One Page

How-to basics · Updated November 19, 2026

To fit an Excel worksheet onto one printed page in Microsoft 365 for Windows, open Page Layout, then under Scale to Fit set Width to 1 page and Height to 1 page. If you want to keep the columns on one page but allow multiple pages down, set Width to 1 page and leave Height as Automatic.

What ‘Autofit page’ means in Excel

People use “autofit page” to mean two different things in Excel. The first is fitting worksheet content onto a printed page by scaling it down or up. The second is AutoFit for row heights and column widths, which resizes cells so their contents are visible. These operations solve different problems: fitting a page changes the print scale, while AutoFit changes the dimensions of rows or columns.

If a worksheet looks correct on screen but prints across several sheets of paper, you probably want print scaling. If text is cut off inside cells, use AutoFit, wrapping, or manual sizing first. You can combine both, but scaling a crowded sheet to one page may make the printed text too small to read.

Fit a worksheet to one printed page

On Windows, use the Scale to Fit controls to set the number of pages wide and tall. The setting applies to the active worksheet, so select the worksheet tab you intend to print before changing it.

  1. Go to Page Layout.
  2. In Scale to Fit, set Width to 1 page.
  3. Set Height to 1 page.
  4. Choose File > Print or press Ctrl+P to inspect the preview.

Excel scales the printout to fit the chosen page count. It does not delete data, change the worksheet’s cell values, or rearrange the data on the sheet. The scaling is a print-layout setting. If the result is too small, cancel or return to Page Layout and change the settings; you can also adjust the paper layout as described below.

The Print screen provides a convenient alternative. Open File > Print and look in the Settings area for the scaling menu. Depending on the displayed options, choose Fit Sheet on One Page to fit both dimensions, or choose an option that fits all columns or all rows when that better suits the worksheet. Always inspect the preview because a one-page setting can shrink a large sheet substantially.

Choose between one page and readable pages

Fitting everything to one page is not always the best choice. Excel has to reduce the print scale when the selected content is larger than the available paper area. A wide report with many columns, or a long list with hundreds of rows, may become too small to read if both Width and Height are limited to one page.

  • Width 1 page, Height Automatic: Keeps all selected columns together across the page width, while allowing the rows to continue onto additional pages. This is often the most practical option for long tables.
  • Width Automatic, Height 1 page: Keeps the selected rows on one page vertically but may divide a wide sheet across pages horizontally.
  • Width 1 page, Height 1 page: Compresses the entire print area into a single page. Use it for compact summaries, not automatically for every large worksheet.
  • Automatic for both: Leaves Excel to paginate at the current scale, which may produce several pages across and down.

For example, a sales table with eight columns and 300 rows may be easier to use with Width set to 1 page and Height set to Automatic. The column headings stay aligned on each printed page if you also repeat the header row, while the data remains at a more useful size than it would be on one sheet of paper. A small monthly summary with a few rows and columns may be a good candidate for fitting to one page in both directions.

Prepare the sheet before scaling

Good page setup can reduce unnecessary shrinking. First, check what is actually on the worksheet. Blank-looking cells with formatting, stray entries far to the right or below the report, or accidental content can make Excel treat the print range as much larger than expected. Use the scroll bars to inspect the edges, and remove unwanted content or formatting if appropriate.

Then consider these layout adjustments:

  • Use landscape orientation for a report with many columns. Choose Page Layout > Orientation > Landscape. Portrait is usually better for narrow, tall content.
  • Choose the paper size that will actually be used, such as Letter or A4, from Page Layout > Size. The printer and print dialog may affect which sizes are available.
  • Reduce margins if the printer supports it. Choose Page Layout > Margins and select a preset, or open Custom Margins. Very narrow margins are not printable on every printer.
  • Remove unnecessary columns from the report or shorten overly long headings where that improves clarity. Do not hide information readers need just to force a smaller page count.
  • Wrap long cell contents or adjust column widths so text is legible. On the Home tab, use Wrap Text when a heading should occupy multiple lines instead of forcing a very wide column.

AutoFit is useful for cell layout: select the relevant columns or rows, then choose Home > Format > AutoFit Column Width or AutoFit Row Height. You can also double-click the boundary between column letters or row numbers to AutoFit the selected boundary. However, AutoFit may make a column containing a long note extremely wide. For a printable report, wrapping text and setting a reasonable width can be better.

Set a print area when only part of the sheet belongs

Scaling uses the worksheet’s printable content, so define a print area if the worksheet includes notes, calculations, or other cells that should not appear on paper. Select the range to print, then choose Page Layout > Print Area > Set Print Area. Open Print Preview to check that the selection includes all intended headings and totals.

To clear the restriction later, choose Page Layout > Print Area > Clear Print Area. A saved print area can explain why some cells do not appear in a printout, or why changing the scale seems not to include the whole worksheet. Excel’s print preview is the quickest way to confirm what the current area contains. A print area is a print setting; it does not hide the cells or remove them from the workbook.

Control where page breaks fall

When a worksheet spans multiple pages, page breaks determine where Excel divides the content. Select View > Page Break Preview to see the page divisions. You can drag a break to adjust it, or use the Page Layout tab’s page-break controls to insert, remove, or reset breaks. This is helpful when a total row or a group of related columns would otherwise be split awkwardly.

If you set both Width and Height to 1 page, there is little room for page breaks to control because the printout is being forced onto one page. For a multi-page result, choose a suitable scaling arrangement first, then review the breaks in Page Break Preview. If scaling controls are unavailable or do not behave as expected, check whether the sheet has manual page breaks and whether you are editing the intended worksheet.

Check the print preview and troubleshoot results

Do not rely only on the worksheet view: the grid on screen is not a dependable picture of the printed page. Use File > Print to review the page count, orientation, margins, and the size of the text before printing. If the preview shows an unexpected extra page or a tiny report, work through the likely causes rather than repeatedly changing the scale.

  • Unexpected blank pages: Look for stray content or formatting outside the report, and check the print area and page breaks.
  • Text is too small: Avoid fitting both directions to one page. Try Width 1 page with Height Automatic, use landscape orientation, or simplify the printed range.
  • Columns are cut off: Fit the width to one page, use landscape, or reduce margins. Check that the paper size in Excel matches the paper loaded in the printer.
  • Rows are missing: Confirm that the print area includes them and that they are not hidden. Also inspect the preview’s page count and scaling selection.
  • Printed output differs from the preview: Check the printer’s paper size and printer-specific margins or settings. A printer cannot print into areas outside its printable limits.

A useful habit is to preview after each major adjustment rather than changing orientation, margins, print area, and scale all at once. That makes it easier to identify which setting fixed the issue and reduces the chance of ending up with a page that technically fits but cannot be read comfortably.

Excel for Mac and Excel for the web

In Excel for Mac, page layout and scaling options are available from the Page Layout tab, though the ribbon arrangement and labels can differ slightly from Windows. You can also open the print dialog with Command+P rather than Windows’ Ctrl+P. Check the page setup and print preview on the Mac version you are using, especially because the available paper sizes can depend on the selected printer.

In Excel for the web, open the print view from File > Print and use the scaling choices shown in the print settings if available. The web interface may not expose every desktop page-setup control, and print options can differ from the Windows application. If you need detailed control over print areas, page breaks, or repeated print headings, open the workbook in the desktop version of Excel and set up the worksheet there.

When another approach is better

If a one-page printout makes the data difficult to read, do not treat fitting to one page as a requirement. A multi-page report can be clearer and more useful. For a long table, repeat the heading row on each printed page by opening Page Layout > Print Titles and setting the rows to repeat at the top. This keeps column labels visible without shrinking all the data to fit one sheet.

You can also print only a meaningful selection, split a very wide report into separate views, or adjust the worksheet design before printing. For a table intended mainly for screen use, the right solution may be a readable PDF or a wider paper size rather than extreme scaling. The goal is to make the information accessible, not merely to force Excel’s page count to one.

Frequently Asked Questions

How do I fit all columns on one page in Excel?
On Windows, go to Page Layout > Scale to Fit and set Width to 1 page. Leave Height as Automatic if you want the rows to continue onto more pages. Check File > Print to confirm the result.

How do I fit an entire Excel sheet on one page?
Set both Width and Height to 1 page in the Scale to Fit group on the Page Layout tab. Preview before printing, because a large sheet may be reduced until its text is too small to read.

Does fit to one page change my spreadsheet data?
No. It changes how Excel scales the worksheet for printing. It does not delete cells or change their values. AutoFit, by contrast, changes row heights or column widths.

Why is my Excel printout so small?
The sheet may be scaled down to fit one page in both directions, or Excel may be including a much larger area than the visible report. Try allowing multiple pages in height, checking the print area, and reviewing stray content in the preview.

Can I fit a sheet to one page in Excel for the web?
Open File > Print and check the scaling choices in the print settings. For more detailed page setup, such as managing print titles or page breaks, use desktop Excel if the web version does not show the control you need.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.