How to Print Excel on One Page Without Cutting Off Data

How-to basics · Updated November 20, 2026

To print an Excel worksheet on one page in Microsoft 365 for Windows, open the Page Layout tab, set Width and Height in the Scale to Fit group to 1 page, then check the result in File > Print. This fits the selected print area—or, if none is set, the worksheet’s printable content—onto one sheet of paper. Before printing, check whether the reduced text will still be readable.

What You’ll Need

  • An Excel workbook and a printer, or access to a PDF printer such as Microsoft Print to PDF.
  • The correct paper size, such as Letter or A4, and enough time to review the print preview before using paper.
  • The worksheet or specific cell range you intend to print. If you are unsure, you can preview the whole sheet first and decide whether to limit the print area.

Step-by-Step

  1. Open the worksheet and check what is included. Select the worksheet tab you want to print. Look over the data, including columns and rows that may be outside the visible window. If the sheet has an existing print area, Excel may print only that range. To remove an old print area, go to Page Layout > Print Area > Clear Print Area. If you want to print only part of the sheet, select its cells, then choose Page Layout > Print Area > Set Print Area. The selected range becomes the area Excel fits to the page.
  2. Set the page orientation. On the Page Layout tab, choose Orientation, then select Landscape for a sheet with many columns or Portrait for a tall, narrow list. Landscape gives the page more horizontal room, but it does not increase the paper size. You can change orientation again after reviewing the preview.
  3. Choose the paper size. On the same tab, select Size and choose the paper loaded in your printer, commonly Letter or A4. If Excel is set to a different size from the printer, the printed output may be scaled or positioned unexpectedly. The available choices can depend on the selected printer and its driver.
  4. Set the worksheet to fit one page wide and one page tall. In the Scale to Fit group on the Page Layout tab, set Width to 1 page and Height to 1 page. Excel scales the printable range down or up to fit within one page. If those controls show percentages or are unavailable, check that the worksheet is not in a view or state that prevents the scaling controls from being edited; you can also open the Page Setup dialog as described in the next step.
  5. Use Page Setup if you prefer its fit-to-page controls. Click the small dialog box launcher in the lower-right corner of the Page Setup group on the Page Layout tab. In the dialog, open the Page tab, select Fit to, and enter 1 page wide by 1 tall. Click OK. This is another way to apply the same one-page scaling. Do not select Adjust to if your goal is specifically to fit the printout to one page; that option sets a percentage instead.
  6. Choose margins that suit the content. Go to Page Layout > Margins and try Narrow if the sheet is close to fitting at a readable size. Narrower margins create more room for the worksheet, but the printer may not be able to print right to the paper’s edge. Use the margin options or the Page Setup dialog to check the margins if content appears too close to an edge.
  7. Preview the scaled page before printing. Choose File > Print, or press Ctrl+P on Windows. Review the preview pane and confirm that the content is on one page, the correct worksheet is selected, and no important column or row is missing. Use the navigation controls in the preview if more than one page appears. The preview is also where you can check the selected printer and paper settings.
  8. Make a readability decision, then print or save a PDF. If the preview text is comfortably readable, choose Print. If it is too small, return to the worksheet and reduce the amount of content, use landscape orientation, adjust margins, or print only a useful range. You can also select Microsoft Print to PDF in the printer list to save a PDF and inspect it on screen before using paper.

In Excel for Mac, the names and positions of some controls can differ slightly by release. Use the Page Layout tab to set orientation, paper size, margins, and scaling, then open File > Print to inspect the preview. The Mac print shortcut is Command+P. Excel for the web has a print workflow of its own: open File > Print and use the available scaling choice, such as fitting the sheet on one page. Check its preview before printing because browser and printer options can affect the available settings.

Common Mistakes

  • Setting only the width to one page. Width set to one page keeps all columns together, but the worksheet can still continue across multiple printed pages vertically. Set both Width and Height to one page when the requirement is exactly one sheet of paper.
  • Assuming one page always means readable. Excel can shrink a large worksheet dramatically to honor the one-page setting. A preview that technically fits may still be difficult to read. If the text is too small, edit the layout or print across more than one page rather than forcing an unreadable result.
  • Forgetting an existing print area. A print area saved earlier can exclude rows or columns you expect to see. Clear it to print the worksheet’s printable content, or set a new area that includes the intended cells.
  • Printing the wrong range or worksheet. In the Print screen, the settings may be set to print the active sheet, the entire workbook, or a selection. Confirm the desired option and worksheet before sending the job.
  • Ignoring paper size and orientation. A landscape sheet set to print on portrait paper, or an A4 layout sent to a Letter-size printer, may have different margins or scaling than expected. Match Excel’s page setup to the paper you will use.
  • Relying on a changed zoom level. The zoom control at the bottom of the Excel window changes how large the sheet looks on screen; it does not control print scaling. Use the Page Layout scaling controls instead.

Tips

  • Decide what needs to be on the page before shrinking it. If a worksheet contains notes, calculations, or unused columns that readers do not need, consider setting a print area around the relevant table. Printing only the useful range often produces a clearer page than squeezing every populated cell onto it.
  • Use landscape for wide tables. It can reduce the amount of scaling needed when columns are the main problem. If the worksheet is still too wide, shorten long headings, adjust column widths, or remove nonessential columns from the print area.
  • Check page breaks when a layout seems odd. Choose View > Page Break Preview to see how Excel divides the sheet into pages. You can inspect the boundaries and return to View > Normal afterward. With fit-to-page scaling active, the preview helps identify whether Excel is including unexpected cells.
  • Use print preview as a final quality check. Look for small text, clipped headings, blank areas, and content close to the paper edge. A quick PDF preview is useful when you want to check the output without wasting paper.
  • Keep the editable workbook unchanged when possible. Printing settings can be saved with the workbook and affect future print jobs. If you need a different layout for a one-time print, make a note of the original settings or save a separate copy.
  • Do not confuse fitting with enlarging. The fit-to-page setting makes the selected range fit the page; depending on the content, Excel may reduce or enlarge it. For a large worksheet, it usually reduces the scale, while a small range may be enlarged in some print setups. Review the output rather than assuming a particular scale.

Troubleshooting

The printout still spans more than one page. Reopen Page Layout and verify that both Width and Height are set to 1 page. Then check the preview’s page counter. Confirm that you are printing the intended sheet or selection and that the paper size in Excel matches the printer. If necessary, open Page Setup and confirm that the Fit to setting is 1 page wide by 1 tall.

Some rows or columns are missing. Check whether a print area is restricting the output. Use Page Layout > Print Area > Clear Print Area to remove it, or reset it to include the cells you need. Also check the Print screen’s setting for printing a selection, active sheet, or entire workbook.

The content fits but the text is too small. This is a limitation of putting a large amount of data on one page, not a preview error. Try landscape orientation, narrower margins, better-sized columns, shorter labels, or a smaller print area. If these changes do not make the sheet readable, allow it to print on two or more pages. Keeping all content visible is not useful if nobody can read it.

The page is mostly blank or content is unexpectedly tiny. Excel may be including faraway cells or formatting that extends the used area. Inspect the worksheet for stray values, spaces, or formatting well beyond the actual table. Clear unnecessary content or formatting in those distant rows and columns, save the workbook, and check the preview again. If the sheet has a print area, clear and reset it to the intended range.

The printout is clipped at an edge. Check the paper size, orientation, and margins in Page Layout, then compare them with the printer’s settings. Some printers have a nonprintable border even when Excel’s margins appear small. Increase the margin or reduce the content width slightly, then review the preview and, if available, a test PDF.

The scaling options are unavailable or do not seem to apply. First make sure you are on the worksheet you intend to print and using Excel’s Page Layout controls rather than the on-screen zoom. Open the Page Setup dialog and check the Page tab’s scaling choice. If you are using Excel for the web, use the scaling controls in its print screen instead; desktop ribbon paths do not always apply to the browser version.

Frequently Asked Questions

How do I print an Excel sheet on one page without making it too small?
Use landscape orientation for wide sheets, narrow margins, and print only the necessary range. Adjust column widths or simplify headings. If the preview remains hard to read, print on more than one page; Excel cannot fit an unlimited amount of content onto one page at a readable size.

What is the difference between Fit All Columns on One Page and Fit Sheet on One Page?
Fitting all columns on one page keeps the sheet’s width to one page but may use several pages vertically. Fitting the entire sheet on one page scales both width and height to a single page. The exact labels can vary between Excel desktop and Excel for the web.

Can I print only part of an Excel worksheet on one page?
Yes. Select the cells you need and choose Page Layout > Print Area > Set Print Area. Then apply one-page scaling and check the preview. To return to printing the full sheet, use Clear Print Area.

Does Ctrl+P set the worksheet to one page?
No. Ctrl+P opens the Print screen on Windows; it does not by itself change the scaling. Set the width and height in Page Layout > Scale to Fit first, then use the preview in the Print screen. On Mac, use Command+P to open printing.

Can I save the one-page printout as a PDF?
Yes. In Windows, open File > Print, select Microsoft Print to PDF as the printer, confirm the preview and page settings, then choose Print and select a save location. The exact PDF option depends on the operating system and available printers.

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.