To print an Excel worksheet on a single page in Microsoft 365 for Windows, open File > Print, select Fit Sheet on One Page from the scaling menu, and check the preview before printing. If the sheet becomes too small, set a print area, switch to landscape, or adjust the page layout first. You will need a worksheet and access to a printer or PDF output; the steps below help you fit the intended content without accidentally shrinking it to unreadable size.
What You’ll Need
- An Excel workbook open in the desktop version of Microsoft Excel for Microsoft 365.
- A printer connected to your computer, or the option to print to PDF.
- The correct paper size for your destination, such as Letter or A4. Check the printer’s tray and settings if you plan to print on paper.
You do not need to change cell sizes or delete data. However, if the worksheet has many rows or columns, decide whether every cell truly belongs on the same page. Fitting a very large sheet onto one page can make labels and values difficult to read.
Step-by-Step
- Open the sheet you want to print. Select its worksheet tab at the bottom of Excel. If you only want one sheet, make sure you have not grouped multiple sheet tabs; grouped tabs may be indicated by several selected tabs. Click an unselected tab to work with a single sheet. Save the workbook before making layout changes so you can easily return to the original view.
- Decide what should be included. Review the used area of the sheet and remove accidental content far below or to the right of your real data if it should not print. If you want only a specific block, select that range, then choose Page Layout > Print Area > Set Print Area. This tells Excel to print the selected range rather than the whole worksheet. To remove that restriction later, use Page Layout > Print Area > Clear Print Area.
- Choose the page orientation. On the ribbon, open Page Layout > Orientation. Choose Landscape when your content is wider than it is tall, such as a table with many columns. Choose Portrait for a narrow or tall layout. Orientation does not itself fit the sheet, but it can reduce how much Excel must shrink the content.
- Set the paper size and margins. On Page Layout, choose Size and select the paper that will actually be used, for example Letter or A4. Then choose Margins and try Narrow if the sheet is only slightly too large. Margins that are too narrow can be outside a printer’s printable area, so use the preview to confirm there are no warnings or cut-off edges. A larger paper size is useful only if the printer is loaded with that size.
- Apply one-page scaling from the Page Layout ribbon. In the Scale to Fit group on the Page Layout tab, set Width to 1 page and Height to 1 page. Excel reduces the printed scale as needed so the print area fits across one page and down one page. If the Scale to Fit controls are not visible, widen the Excel window or look for the group in the compact ribbon layout.
- Alternatively, choose the one-page option in Print. Open File > Print. Under Settings, open the scaling dropdown, which commonly displays No Scaling, and select Fit Sheet on One Page. This is a quick way to make the same general adjustment. Do not also select options such as Fit All Columns on One Page if your goal is one page in both directions; that option can still allow the sheet to continue onto additional pages vertically.
- Inspect the print preview carefully. Use the preview on the right side of the Print screen to check that the intended rows and columns are present, headings are visible, and nothing important is clipped. Confirm the page count says one page. If the preview looks too small, cancel out of Print and reduce the content, set a tighter print area, choose landscape, or use a larger supported paper size before trying again.
- Print or save a PDF. In the Print screen, verify the printer, paper size, and number of copies. Choose Print to produce a paper copy. To make a shareable file instead, select Microsoft Print to PDF as the printer on Windows, then print and choose where to save the PDF. Open the PDF and check its page before sending or printing it elsewhere.
On a Mac, the ribbon names are similar: use Page Layout for orientation and scaling, then open File > Print to preview and print. The exact layout of the print dialog can differ by macOS version and printer. In Excel for the web, use File > Print and review the print preview and scaling choices available there; some page-layout controls are more limited or arranged differently than in desktop Excel. If an option is missing in the browser, open the workbook in the desktop app to set the page layout.
Common Mistakes
- Using the wrong scaling option. Fit All Columns on One Page only limits the width. Rows can still flow onto more pages. Choose Fit Sheet on One Page, or set both Width and Height to 1 page, when the requirement is one total page.
- Printing the entire sheet when only a table is needed. A stray value, a formatted cell, or an old note far from the main table can expand the print range. Set a print area for the intended block and check the preview.
- Ignoring readability. A fit-to-page setting does not rearrange content; it scales it down. If a large worksheet becomes tiny, printing it on one page may not be a useful result. Remove unnecessary columns, split the report into logical sections, or use multiple pages.
- Assuming a selection is the print area. Selecting cells does not always mean Excel will print only those cells. Use File > Print and choose Print Selection in Settings when you only need the current selection, or set a print area if you want the choice to persist in the workbook.
- Forgetting paper and printer settings. Excel may preview a different paper size from the one in the printer tray. A mismatch can cause extra scaling, unexpected page breaks, or clipped edges. Confirm the paper size in both Excel’s print settings and the printer properties when needed.
Tips
- Use page breaks as a diagnostic. Choose View > Page Break Preview to see how the sheet divides into printed pages. With one-page scaling, breaks may shift or be overridden to fit the content. Return to View > Normal when finished.
- Keep headings readable. Shorten long column labels, wrap text selectively, or reduce unnecessary blank columns before scaling. These changes can preserve more usable space than shrinking every cell.
- Consider a larger paper size only when practical. Tabloid or A3 paper can make a wide report more legible, but the printer and reader must support it. Confirm the selected size in the print preview rather than assuming Excel will use it automatically.
- Check print settings before each print job. The print area and scaling settings can remain with the workbook. If you later add data, return to the preview to verify that the new content is included and still fits.
- Use a PDF for a final visual check. A PDF preserves the page layout for review and sharing. It is especially useful when the recipient may use a different printer or computer, though the PDF should still be checked at a readable zoom level.
Troubleshooting
The preview shows more than one page. Reopen the scaling dropdown in File > Print and select Fit Sheet on One Page. If you used the ribbon, confirm both Width and Height are set to 1 page. Also check that you are viewing the intended worksheet and that multiple sheet tabs have not been selected for printing. If it still spans pages, check for a large print area or distant content that is extending the used range.
The output is too small to read. One-page scaling has to compress all selected content into the available paper. First set a smaller print area that excludes notes or extra columns, then try landscape orientation and narrower margins. If the sheet is still too dense, do not force it onto one page: choose Fit All Columns on One Page to keep the columns together while allowing multiple pages vertically, or print selected sections on separate pages.
Rows or columns are missing. Check whether a print area is excluding them by choosing Page Layout > Print Area > Clear Print Area, then preview again. Also inspect hidden rows and columns; hidden content normally does not appear in print. If the missing information is in another worksheet, select that sheet and preview it separately.
The paper copy differs from the preview. Confirm the printer selected in Excel, its paper size, and its orientation. In Windows, printer-specific options may be available through the printer properties link in the Print screen. Check that the printer is not set to a different paper size or a separate scaling mode. Printing the workbook to PDF can help determine whether the layout problem is in Excel’s page setup or in the physical printer settings.
The edges are cut off. Increase the margins, select a paper size supported by the printer, or reduce the print area slightly. Some printers cannot print to the very edge of a page. If only a small strip is lost, avoid using minimum margins and confirm the preview shows a margin around the content.
Frequently Asked Questions
How do I print only one worksheet on one page?
Click the worksheet tab, then use File > Print and choose Fit Sheet on One Page. Check that the Print Active Sheets setting is selected, rather than printing the entire workbook.
What is the difference between Fit Sheet and Fit All Columns?
Fit Sheet on One Page scales both the width and height to one page. Fit All Columns on One Page keeps columns together horizontally but may create several pages down the sheet.
Can I fit only selected cells onto one page?
Yes. Select the cells, then choose File > Print and select Print Selection under Settings. Preview the result and choose the one-page scaling option if it is available in the scaling menu.
Will printing on one page change my worksheet?
No. Scaling changes how Excel lays out the sheet for printing; it does not delete rows, columns, or values. It may change page setup settings stored with the workbook.
Why is Fit Sheet on One Page missing?
In desktop Excel for Windows, find it in the scaling menu under File > Print. Excel for the web and some Mac print-dialog layouts may offer different controls. Open the workbook in desktop Excel and use the Page Layout tab if you cannot find the option.
Related
- Merge Two Excel Files in Power Query: Step-by-Step
- How to Move Cells in Excel Without Overwriting Data
- Merge Names in Excel from 3 Cells
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Alphabetize in Excel and Google SheetsTo alphabetize a list, select a cell in the column and choose an A-to-Z sort; to keep related…
- How to Add a Bottom Header in Microsoft Word EasilyTo put text at the bottom of a page in Word, add a footer: choose Insert > Footer,…
- Excel Cell Multiple Lines: Add Line Breaks and Wrap TextTo put multiple lines in one Excel cell, edit the cell, place the cursor where the next line…
- How to Delete an Excel File Online in OneDrive or TeamsTo delete an Excel file online, open the OneDrive or SharePoint location where it is stored, select the…
- How to Animate a Text Box in PowerPointTo animate a text box in PowerPoint, select its border, open the Animations tab, choose an effect, then…
- Excel Force Page Breaks: How to Insert and Control ThemTo force a page break in Excel for Microsoft 365 on Windows, select the row below where a…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.