To print an Excel worksheet on one page, open Page Layout and set Width to 1 page and Height to 1 page in the Scale to Fit group; then check File > Print preview before printing. This shrinks the sheet to fit the paper, which can prevent columns or rows from spilling onto extra pages. Have the workbook and the correct printer or a PDF option available, and decide whether you need the entire sheet or only selected data.
What You’ll Need
- A workbook open in Microsoft Excel for Microsoft 365 on Windows.
- A printer, or the option to save or print to PDF, if you want a digital copy.
- A moment to check the print area, paper size, and page orientation so Excel scales the content you actually want.
Step-by-Step
- Choose the worksheet and the content to print. Click the worksheet tab you want to print. If you want only a particular block, select those cells first. If you want the whole sheet, leave the selection alone. To prevent unrelated cells or formatting far down the sheet from affecting the output, select the required range, then go to Page Layout > Print Area > Set Print Area. The print area stays in effect until you clear it using Page Layout > Print Area > Clear Print Area. Excel prints the active sheet by default, not every sheet in the workbook.
- Set the paper orientation. Go to Page Layout > Orientation and choose Portrait or Landscape. Landscape is often more suitable for tables with many columns; Portrait may work better for a long, narrow list. Orientation changes the available printable width, so it can substantially affect how much Excel needs to shrink the sheet. If the paper size is wrong, use Page Layout > Size and select the size your printer or PDF output will use, such as Letter or A4.
- Set the scaling to one page wide and one page tall. On the Page Layout tab, find the Scale to Fit group. Set Width to 1 page and Height to 1 page. Excel adjusts the print scale so the defined print area fits within a single sheet of paper. You can also open the Page Setup dialog with the small dialog box launcher in the Page Setup group, choose the Page tab, select Fit to under Scaling, and enter 1 page wide by 1 tall. Avoid setting a separate percentage in the same dialog when using Fit to, because those are alternative scaling choices.
- Use a one-page-wide option if a single page tall would make text too small. Fitting a large worksheet onto exactly one page can reduce the font dramatically. If the goal is to keep columns together but let a long report continue onto multiple pages, set Width to 1 page and Height to Automatic in Scale to Fit. This keeps the width to one printed page while allowing additional pages vertically. The related shortcut is File > Print, then open the scaling menu that may show No Scaling and choose Fit All Columns on One Page.
- Review margins and centering. Go to Page Layout > Margins and choose a preset such as Narrow if the printer supports it and the content needs more room. Use Custom Margins to enter specific values or center a small table: open Custom Margins and, under Center on page, select Horizontally or Vertically. Smaller margins increase printable space, but they cannot override a printer’s non-printable edge area. Check the preview afterward because available margins vary by device.
- Check the print preview. Press Ctrl+P on Windows, or choose File > Print. Review the preview pages and look at the page count, text size, clipped edges, and any blank pages. The settings displayed under Print Settings offer scaling choices such as Fit Sheet on One Page, Fit All Columns on One Page, or Fit All Rows on One Page. Choose the one that matches your goal. The preview is the best way to catch a bad fit before using paper.
- Adjust page breaks if the layout needs more control. If you are allowing more than one page, go to View > Page Break Preview to see where Excel divides the sheet. Drag a blue page-break line to change the division, or use Page Layout > Breaks to insert or remove a break. A manual break can help keep related columns or rows together, but it does not make the content larger. Return to Normal view when finished, then reopen Print Preview to check the result.
- Print or save the output. In File > Print, verify the selected printer, the paper size, and whether the setting says Print Active Sheets, Print Entire Workbook, or Print Selection. Use the page arrows in the preview to check every page, then choose Print. To make a PDF instead, choose a PDF printer or use Excel’s available PDF export option. On a Mac, use Command+P to open printing; ribbon labels and the print dialog can differ slightly, but Page Layout scaling and the preview remain the key checks.
Common Mistakes
Fitting everything to one page when the worksheet is large. The setting works, but the result may be unreadably small. Fit All Columns on One Page is often a better choice for a wide table, because it allows the rows to continue across multiple printed pages. If it is still too small, consider landscape orientation, narrower margins, or reducing unnecessary columns rather than forcing a one-page result.
Using the wrong print scope. Choosing Print Selection when nothing useful is selected can produce a blank or incomplete printout. Choosing Print Entire Workbook when you only wanted one sheet can waste paper and include hidden or unrelated tabs. Confirm the scope in File > Print every time, especially after selecting a range or changing worksheets.
Leaving an old print area in place. A previously defined print area may exclude new columns or rows you expect to print. Select the intended range and set a new area, or use Page Layout > Print Area > Clear Print Area to remove the restriction. Also check that accidental formatting far from the data has not expanded the apparent used area.
Assuming the preview is optional. A worksheet that looks fine on screen can print with tiny type, clipped columns, or an unexpected extra page. Scaling, margins, paper size, and printer limits all affect the result. Always inspect the preview rather than relying on the worksheet grid.
Tips
- For a wide data table, try Landscape plus Width 1 page and Height Automatic first. This usually preserves a more readable font than squeezing both dimensions onto one page.
- Hide columns that are not needed in the printed report, or adjust column widths before scaling. Do not delete source data just to improve the print layout.
- Use Print Titles when column headings need to repeat on every page: go to Page Layout > Print Titles, then set rows to repeat at top or columns to repeat at left. This is especially useful when the sheet spans several pages.
- Use the Page Layout view to get a closer sense of page boundaries while editing. Return to Print Preview to see the actual output choices and page count.
- Excel for Mac uses the same general approach through Page Layout scaling and File > Print, though the dialog arrangement can vary. Excel for the web has a different print workflow and fewer layout controls in some environments; if exact scaling or page breaks matter, open the workbook in the desktop app.
Troubleshooting
The content prints on multiple pages despite choosing Fit to One Page. Confirm you changed both Width and Height to 1 page, and check that the print area does not extend beyond the intended data. In File > Print, verify that scaling is not set to No Scaling or another option that conflicts with your intended layout. Confirm the paper size and orientation match the printer. If the sheet is still divided, reopen the Page Setup dialog and check that Fit to is selected rather than Adjust to.
The text is too small to read. That is a sign the content does not comfortably fit on one sheet at the chosen paper size. Change Height to Automatic while keeping Width at 1 page, or print on a larger paper size if available. You can also remove nonessential columns, reduce oversized blank spacing, or split the report into logical sections. Avoid shrinking font size excessively just to satisfy a one-page target.
Some columns or rows are missing. Check whether a print area is limiting the output and whether Print Selection is active. Hidden rows and columns normally will not appear in print, so unhide any required data. In the preview, use the page navigation controls to determine whether the missing content moved to another page rather than disappearing.
A blank page appears or the content is unexpectedly spread out. Look for stray formatting or a cell far outside the main table that may enlarge the print area. Clear an old print area, then set it again around the intended content. In Page Break Preview, inspect for manual page breaks. If a printer reports an error or clips the page edge, confirm its paper size and printable margins; Excel cannot print beyond the hardware’s limits.
Frequently Asked Questions
How do I fit an Excel sheet on one page without changing the cell sizes?
Use Page Layout > Scale to Fit and set Width and Height to 1 page, or choose Fit Sheet on One Page under File > Print scaling. These options change print scaling, not the worksheet’s row heights or column widths. The printed text may therefore be smaller.
How can I fit all columns on one page but print multiple pages down?
Set Width to 1 page and Height to Automatic in the Scale to Fit group. In the print screen, choose Fit All Columns on One Page. Excel keeps the columns together across the width and allows the sheet to continue vertically.
Can I fit only a selected range to one page?
Yes. Select the cells, then choose Page Layout > Print Area > Set Print Area. Set the scaling, and check Print Preview. In File > Print, make sure the intended scope is selected; Print Selection prints the current selection, while the saved print area defines a range for the sheet.
Why does Fit to Page make my spreadsheet unreadable?
Excel is shrinking the content to fit the chosen number of pages. Try Landscape, narrower margins, or Width 1 page with Height Automatic. If the report is still too dense, print it across more pages or simplify the printed view instead of forcing everything onto one sheet.
Does Fit to Page change my worksheet data or formatting?
No. It changes how Excel scales the sheet for printing, not the underlying values or cell formatting. You can change the scaling settings later. Still, check the preview after changing them because the printed appearance can differ substantially from the on-screen grid.
Can I use Fit to Page in Excel for the web?
Excel for the web supports printing, but the available layout controls can differ from the Windows desktop app. For exact one-page scaling, page breaks, or print-area adjustments, open the workbook in Excel for Microsoft 365 on Windows or Mac and configure the print layout there.
Related
- How to Insert an Image in Excel From a Link in Microsoft 365
- How to Insert an Image in an Excel Cell and Make It Fit
- How to Open an Excel File That Is Too Large
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Can You Import Excel and CSV Files Into QuickBooks?Yes. QuickBooks can import Excel and CSV files for certain kinds of data, but the accepted format depends…
- Compare Two Sheets for Matches in Excel: A Practical GuideTo compare two Excel sheets for matching records, use a shared key such as an ID or email…
- Can You Make Columns in Word? A Quick GuideYes. In Microsoft Word for Microsoft 365 on Windows, select the text you want to format, then choose…
- How to Find the Average Percentage in Excel CorrectlyTo average percentages in Excel, enter the percentage values in a range and use =AVERAGE(C2:C6). This formula assumes…
- How to Set an Out of Office Reply in Microsoft OutlookTo set an out-of-office reply in Outlook, open Automatic Replies, turn them on, write your message, and—if available—choose…
- Merge Cells in Google Sheets: Formula vs. Menu OptionNo Google Sheets formula can merge cells in the spreadsheet layout. To combine the contents of cells in…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.