Excel Print Area Too Small? Fix Scaling and Margins

If an Excel printout is too small, first check the print scaling: in Windows Excel, open File > Print and change the scaling option from Fit Sheet on One Page to No Scaling or Fit All Columns on One Page. If part of the sheet is missing instead, go to Page Layout > Print Area > Clear Print Area, then select the cells you actually need and choose Page Layout > Print Area > Set Print Area.

What a small print area can mean

People use “print area too small” for two different problems. The printed content may be physically tiny on the page, or the selected print area may leave out cells that should appear. These problems have different causes: scaling changes how large Excel draws the chosen content, while the print area determines which cells Excel includes.

A print area is a range of cells marked for printing on a particular worksheet. When one is set, Excel generally prints that range rather than the rest of the used cells on the sheet. The range is saved with the workbook, so an old print area can remain after data is added or rearranged. Scaling is a separate print-layout setting. It can shrink a wide or tall range to fit a chosen number of pages, sometimes making text hard to read.

Start by opening Print Preview with Ctrl+P on Windows. The preview makes it easier to tell whether the issue is missing content, a small image of the whole sheet, or an unexpected page break. Do not assume that dragging a page boundary or changing the print area will automatically make text larger; the scale setting may still be shrinking the output.

Check the print range first

On the affected worksheet, choose Page Layout > Print Area > Clear Print Area. Then press Ctrl+P to inspect the result. If the missing cells now appear, the old print area was too narrow or short. Clearing the area does not delete worksheet data; it removes the saved instruction that restricted printing. Excel may then include more of the sheet than you want, so select the intended range and set a new print area.

To define a new range, drag across the cells you want included, then choose Page Layout > Print Area > Set Print Area. For example, if a report occupies A1:H35, select A1:H35 before setting the area. If a title or total is in row 36 or column I, include it in the selection. A common cause of cut-off output is setting the print area before the final row or column was added and never updating it.

Use Clear Print Area when you are unsure what range was saved.
Set the print area again only after checking the worksheet’s actual first and last required cells.
Use Print Preview to confirm the range before sending it to a printer or saving it as a PDF.

Print areas belong to individual worksheets. A print area set on one tab does not automatically define the range on another. If you print several sheets, inspect each one separately. Nonadjacent selections can also be included as multiple print areas, but Excel may place separate areas on separate printed pages; this can be surprising when the intention was to create one continuous report.

Understand how scaling affects size

Scaling is often the reason a correct print range looks too small. On the Page Layout tab, find the Scale to Fit group. Its Width and Height settings can force the sheet to fit a selected number of pages. If both are set to 1 page, Excel shrinks the entire selected area to fit on a single page, even when that means reducing the text substantially.

For a wide table, set Width to 1 page and Height to Automatic. This keeps all columns together while allowing rows to continue onto additional pages. For a long list that is not especially wide, leave Width at Automatic and use a suitable height setting only if there is a clear reason to limit the page count. Avoid setting both dimensions to 1 page for a large worksheet unless the result remains readable.

You can also use the scaling choices in File > Print. Depending on the current settings, the dropdown may show options such as No Scaling, Fit All Columns on One Page, Fit All Rows on One Page, or Fit Sheet on One Page. Choose No Scaling to print at the normal scale and allow content to flow onto additional pages. Choose Fit All Columns on One Page when columns would otherwise split horizontally, but inspect the preview because Excel may make the text smaller.

In the Page Setup dialog, the Page tab offers scaling choices such as Adjust to and Fit to. The dialog can be opened from the small dialog launcher in the Page Setup group on the Page Layout tab. When a Fit to page setting is active, Excel determines the scale from the page count; this is different from entering a fixed percentage. If a scale percentage seems unavailable or has no effect, check whether Fit to is controlling the layout.

Choose orientation, paper size, and margins

Before shrinking content, see whether the page setup is simply a poor match for the data. A table with many columns often fits better in landscape orientation. Choose Page Layout > Orientation > Landscape. A narrow, tall list may use Portrait more effectively. Orientation changes the printable shape of the page; it does not alter the worksheet cells or data.

Check the paper size as well. Choose Page Layout > Size and select the size that matches the paper loaded in the printer or the intended PDF page. If Excel is set to a larger paper size than the printer uses, the printer may scale or clip the output. A mismatch between Excel’s page size and the printer driver’s paper setting can also make Print Preview differ from the final sheet.

Margins use up page space. Choose Page Layout > Margins and try Narrow if the printer can handle it, or open Custom Margins to adjust the values. Do not set margins to zero unless the printer supports borderless printing; most printers have a nonprintable edge and may ignore or alter very small margins. Increasing usable page width can help avoid scaling, but margins cannot recover space if the content itself is too wide.

For example, a report with eight columns might be tiny in Portrait with Normal margins and Fit Sheet on One Page. Changing to Landscape, using narrower margins, and fitting only the columns to one page may make the text larger while allowing the rows to continue on a second page. The best combination depends on the paper and printer, so use the preview rather than relying on the worksheet’s on-screen appearance.

Inspect page breaks and print preview

Page breaks determine where Excel divides content across printed pages. To inspect them, choose View > Page Break Preview. Blue lines show page boundaries, and dashed lines can indicate automatic breaks. If a page break splits a table awkwardly, you can adjust the layout or insert a manual break from Page Layout > Breaks. Return to Normal view when finished; Page Break Preview changes how the sheet is displayed, not the underlying cell contents.

In Print Preview, look at both the page count and the size of the text. If a large worksheet is compressed into one page, switch away from Fit Sheet on One Page. If the preview shows only a small block in one corner, check the print area, paper orientation, and scaling. If the preview looks right but the physical sheet does not, review printer properties such as paper size and any printer-side Fit or Shrink setting.

Excel’s Print Titles setting is separate from the print area. Page Layout > Print Titles lets you repeat specified rows or columns on each printed page. It is useful for column headings on a long report, but it does not expand a print area or fix text that has been scaled too small. Likewise, hiding rows or columns can change what appears in print; check for hidden sections if expected data is missing.

Common causes and practical fixes

When the first adjustment does not solve the problem, check these less obvious causes:

Stale print area: The selected range stops before recently added data. Clear it and set the updated range.
Fit-to-page scaling: Excel is forcing many rows and columns onto one page. Use No Scaling or fit only the dimension that must stay together.
Wrong orientation or paper size: Choose a page shape and size that match the report and output device.
Margins or printer limits: Adjust margins within the printer’s printable area, and confirm the printer’s paper settings.
Manual page breaks: A previously inserted break divides the report in an inconvenient place. Review Page Break Preview and reset or adjust breaks as needed.
Hidden content or blank-looking cells: Hidden rows and columns do not print as ordinary visible data. Check whether the missing information is hidden rather than outside the print area.

Another misconception is that making the print area smaller will make the remaining cells print larger. It may help only if the smaller range gives Excel less content to fit into the same page count. If the scaling option still forces that range to fit on one page, the output may remain small. Conversely, clearing the print area can make the output smaller if it causes Excel to include a much larger used range. Recheck the page count and scale after every change.

Excel for Mac and Excel for the web

The instructions above use Excel for Microsoft 365 on Windows. Excel for Mac has similar Page Layout controls, but ribbon placement and dialog appearance can differ. Use Command+P rather than Ctrl+P to open printing on a Mac. Look for the Print Area, Orientation, Size, and Margins controls on the Page Layout tab, then use the print preview to verify the result. If the ribbon is simplified or hidden, expand it to reveal the page-layout commands.

Excel for the web also has printing and page-layout options, but its interface and available controls are not identical to the Windows desktop app. If you cannot find a saved print-area or scaling control in the browser, open the workbook in the desktop app for the more complete Page Layout and Page Setup controls. A browser’s own print dialog is not the same as Excel’s worksheet print settings, so check Excel’s preview before using the browser dialog.

Frequently Asked Questions

Why is my Excel spreadsheet printing so small?
Most often, Excel is fitting too many rows and columns onto one page. In File > Print, replace Fit Sheet on One Page with No Scaling or Fit All Columns on One Page, then inspect the preview. Landscape orientation may also help a wide table.

How do I make an Excel print area bigger?
Choose Page Layout > Print Area > Clear Print Area, select the larger range you need, and choose Set Print Area. Then check File > Print to confirm that the new cells appear. If the range prints tiny, change the scaling separately.

How do I print all columns on one page without shrinking every row?
Set Width to 1 page and Height to Automatic in the Scale to Fit group, or choose Fit All Columns on One Page in the print settings. Excel can then let the rows continue onto additional pages instead of squeezing the entire worksheet onto one.

Why does Excel print only part of my worksheet?
A saved print area may exclude the missing cells, or a row or column may be hidden. Clear the print area to test, inspect hidden rows and columns, and review Page Break Preview. Also confirm that the desired worksheet tab is the one being printed.

Will clearing the print area delete my data?
No. Clear Print Area removes the worksheet’s print-range instruction; it does not delete cells or their contents. You can select the intended range and set a new print area afterward.

Why is the print preview different from the paper?
The printer driver may use a different paper size, margin limit, or scaling option from Excel. Match the paper size in Excel and the printer properties, then check whether the printer is set to fit or shrink the page. A PDF preview can help distinguish an Excel layout issue from a physical printer setting.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

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

Spotted an error in this guide? Let us know.