To print an Excel worksheet on a single page, open Page Layout, set Width and Height in the Scale to Fit group to 1 page, then check the result in File > Print. This scales the worksheet to fit one sheet of paper. Before printing, check the print area, page orientation, and preview so the result includes the right cells and remains readable.
What You’ll Need
- A workbook open in Microsoft Excel for Microsoft 365 on Windows.
- A printer, or a PDF option such as Microsoft Print to PDF, if you want to save the one-page layout as a file.
- The correct paper size for your printer, such as Letter or A4. If you are printing a large worksheet, landscape orientation may help.
Step-by-Step
- Open the worksheet you want to print. Click its sheet tab at the bottom of the workbook. The fit-to-page setting applies to the active worksheet, not automatically to every sheet in the workbook. If you need multiple sheets printed, set up and check each one separately, or select the relevant sheet tabs together before applying settings. Grouped sheets share layout changes, so ungroup them afterward by right-clicking a selected tab and choosing Ungroup Sheets.
- Decide what should appear on the page. If the worksheet contains notes, old calculations, or formatting far beyond your data, select only the cells you intend to print. To make a range the print area, select it, then choose Page Layout > Print Area > Set Print Area. To remove a print area that was set earlier, choose Page Layout > Print Area > Clear Print Area. A print area can prevent unrelated cells from making the page smaller.
- Choose the paper orientation and size. On the Page Layout tab, choose Orientation > Landscape for a wide table, or Portrait for a narrow, tall one. Choose Size and select the paper loaded in the printer. Using the wrong paper size can cause unexpected scaling or clipping. Orientation does not change the worksheet data; it changes how the page is laid out.
- Set practical margins. Choose Page Layout > Margins and select a preset such as Narrow if you need more room for columns. Avoid margins that your printer cannot handle. If you want the table centered, open Margins > Custom Margins and, under Center on page, select Horizontally or Vertically as appropriate. Centering can improve the appearance but does not make text larger.
- Fit the worksheet to one page. On Page Layout, find the Scale to Fit group. Set Width to 1 page and Height to 1 page. Excel will reduce or enlarge the printout as needed to fit the used print area on one sheet. If these controls are set to Automatic or No scaling, open their dropdowns and choose 1 page. You can also use File > Print and choose Fit Sheet on One Page from the scaling options in Settings.
- Check the print preview before printing. Press Ctrl+P on Windows, or choose File > Print. Review the preview and confirm it shows one page, the intended cells, and the correct orientation. Look closely at the smallest labels and numbers: fitting a very large table onto one page can make them too small to read. If the preview shows blank pages, extra content, or cut-off columns, use the troubleshooting section below before printing.
- Print or save the result. Select the correct printer and check the printer’s paper-size setting. If you want a PDF instead, select Microsoft Print to PDF as the printer and print, then choose a file name and location when prompted. In the print settings, confirm you are printing the active sheet rather than the entire workbook unless you intend to print every sheet. Click Print when the preview is correct.
On Mac: The same fit-to-page idea applies, but the controls may be arranged differently. Open File > Page Setup and use the page scaling options to fit the sheet to one page; check orientation and paper size there as well. Use Command+P for print preview. Menu wording and the location of scaling controls can vary by Excel for Mac release.
In Excel for the web: Use File > Print and review the print settings and preview for a scaling choice such as fitting the sheet to one page. If the option you need is not available in the browser interface, choose Open in Desktop App and use the Windows or Mac steps above. Browser and printer settings can affect the available print options.
Common Mistakes
- Setting only the width or only the height. Width set to one page keeps all columns together, but the worksheet may still print on several pages vertically. To force one page total, set both Width and Height to one page.
- Trying to print the whole workbook by fitting one sheet. The setting applies to a worksheet. Other tabs may have different print areas, orientations, or scaling, so check each one that you plan to print.
- Leaving a large or accidental print area. A stray formatted cell far from the data can expand the output and shrink everything. Clear the print area or set a new one around the intended content.
- Assuming one page means readable text. Excel obeys the scaling instruction even if it must shrink a wide or long sheet dramatically. Preview the page at a useful zoom and inspect small text before printing.
- Ignoring the printer’s paper settings. A mismatch between Excel’s selected paper size and the printer’s loaded paper can change the layout. Match them and check the print preview again.
Tips
- Prefer one page wide when readability matters. If fitting everything to one page makes the text too small, set Width to 1 page and Height to Automatic. The columns will stay together, while rows can continue onto additional pages. This is often a better practical printout than forcing a long report onto one sheet.
- Make wide tables easier to fit. Try landscape orientation, narrower margins, shorter column headings, and removal of empty columns before relying on extreme scaling. You can also hide columns that are not needed in the printout.
- Repeat headings on multi-page alternatives. If you decide that the worksheet is too long to fit on one page, use Page Layout > Print Titles to repeat a header row on each printed page. This is more useful than shrinking the whole report until its headings are illegible.
- Use page breaks to control splits. Choose View > Page Break Preview to see where pages divide. You can adjust breaks when printing over more than one page. With one-page scaling, Excel may override the natural page breaks to make the full print area fit.
- Save the workbook after changing its layout. Page setup is stored with the workbook. Saving preserves the settings for the next time you open it, though another computer or printer may use different paper or printer capabilities.
Troubleshooting
The preview still shows more than one page. Confirm you are looking at the correct sheet and that both Width and Height are set to one page in Page Layout > Scale to Fit. Then reopen File > Print and check the scaling option there. If a print area contains multiple separated ranges, the output can behave unexpectedly; clear it and set one continuous range if appropriate.
The printout is too small to read. There is no setting that can place a very large worksheet on one physical page without reducing its scale. Use landscape orientation, narrow margins, or a smaller print area to recover space. If that is not enough, choose Width = 1 page and Height = Automatic, or split the report across multiple pages. Increase font size or simplify the sheet if readers need to work from the paper copy.
Some columns or rows are missing. Check whether you chose Print Selection instead of printing the active sheet, and make sure the intended cells are inside the print area. Also look for hidden rows or columns and unhide any that should appear. In the preview, use the page navigation controls to confirm you are not viewing only the first page of a multi-page print job.
Excel prints extra blank pages. A cell with formatting far below or to the right of the visible data can make Excel treat a much larger area as used. Clear unnecessary formatting outside the data, or explicitly set a print area around the content. Then check the preview again. If the issue persists, clear the print area and set it anew rather than relying on an old range.
The page looks different from the preview. Check that the printer uses the same paper size and orientation selected in Excel. Printer drivers may impose non-printable margins or handle scaling differently. Confirm the selected printer in File > Print, then check its paper settings and print a test page or save to PDF to compare the layout.
Frequently Asked Questions
Can I fit an Excel sheet to one page without changing the data?
Yes. Fit-to-page changes the print scaling, not the values in cells. It does not delete rows or columns. The printed text may become smaller, so always review the preview.
How do I print all columns on one page but allow several pages of rows?
Set Width to 1 page and Height to Automatic in the Scale to Fit group. Check the preview to confirm the columns stay together and the rows flow onto additional pages.
Does this print every sheet in the workbook on one page?
No. It fits the active worksheet’s print area onto one page. Each worksheet has its own print layout. Configure and preview each sheet you want to print, or select the required sheets together and verify the result carefully.
Can I print just part of a worksheet on one page?
Yes. Select the range, then choose Page Layout > Print Area > Set Print Area. In File > Print, make sure the settings are for printing the active sheet. Alternatively, choose the print-selection option if it is shown and confirm the preview contains only the selected cells.
Why is the Fit Sheet on One Page option unavailable?
The exact options depend on the Excel version, selected printer, and whether you are using the desktop app or browser. In desktop Excel for Windows, set Width and Height to one page in Page Layout > Scale to Fit. If using Excel for the web, open the workbook in the desktop app if the required scaling control is missing.
Related
- Keep 0 in Front of a Number in Excel Without Losing It
- Excel Share Mode: How to Keep Your Workbook Shared
- Excel Insert Row Shortcut: Steps for Windows and Mac
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Budget Spreadsheet App: How to Choose and Use It WellA budget spreadsheet app is a spreadsheet program you use to plan income, track spending, and see how…
- Outlook 2010 Rules by Subject: Setup and TroubleshootingYes. In Outlook 2010, create a rule that checks incoming messages for words in the subject, then choose…
- Why Did My Excel File Get Corrupted? Causes and FixesYour Excel file most likely became corrupted because Excel or another program could not finish saving it correctly,…
- Print Freeze Panes in Excel: Repeat Rows on Every PageTo print frozen rows or columns on every page in Excel, use Page Layout > Print Titles and…
- How to Make Every Other Line a Color in Excel QuicklyTo make every other line (row) a color in Excel, select your data rows, then choose Home >…
- Excel Basic Keyboard Shortcuts: A Guide for WindowsIn Excel for Microsoft 365 on Windows, the basic keyboard shortcuts to learn first are Ctrl+C, Ctrl+V, Ctrl+Z,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.