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 File > Print before printing. This scales the selected print area to fit one sheet of paper; it does not remove the unprintable margins most printers need. If the content becomes too small, adjust the layout or print only the relevant columns instead.
What You’ll Need
- An Excel workbook and access to a printer, or a printer driver that can create a PDF.
- The correct paper size, such as Letter or A4, for the paper loaded in the printer.
- A clear idea of which cells should appear on the page. If the sheet contains unrelated data, decide which range you want to print first.
You can set up a page and inspect the preview without having a printer connected. The printer itself determines the printable area and may have larger minimum margins than Excel shows, so the final preview and print dialog are worth checking.
Step-by-Step
- Open the worksheet you want to print. Click its sheet tab and look over the data. If you only need one block of cells, select that range with the mouse before setting up the page. For a whole worksheet, you can leave the selection alone. Check that hidden rows or columns are not hiding information you expect to print; Excel normally does not print hidden cells.
- Set the print area if you are printing only part of the sheet. With the desired cells selected, go to Page Layout > Print Area > Set Print Area. Excel will treat that selection as the printable range. To remove an earlier print area and print the whole sheet, choose Page Layout > Print Area > Clear Print Area. This matters because an old print area can make the preview look incomplete even when the worksheet contains more data.
- Choose the paper size and orientation. On the Page Layout tab, open Size and choose the paper that is actually in the printer, commonly Letter or A4. Then choose Orientation and select Landscape for a wide table or Portrait for a narrow or tall one. Landscape gives columns more horizontal room, but it does not automatically make the text larger; the scaling setting controls how the sheet fits.
- Set the scaling to one page. On Page Layout, find the Scale to Fit group. Set Width to 1 page and Height to 1 page. Excel reduces or enlarges the printout as needed so the print area fits on one page. If the controls are unavailable or hard to find, open File > Print, click the scaling option that may say No Scaling, and choose Fit Sheet on One Page.
- Check the margins. On the Page Layout tab, choose Margins and try Narrow if you need a little more room. You can choose Custom Margins to adjust the top, bottom, left, or right margins, or to center the content horizontally or vertically. Keep enough margin for your printer to feed the paper and avoid cutting off the edges. Narrow margins help with fit, but they cannot make an ordinary printer print to the very edge.
- Open Print Preview. Press Ctrl+P on Windows, or go to File > Print. The preview shows the pages Excel intends to produce. Confirm that there is one page, the expected cells are present, the selected printer and paper size are correct, and headings or values are not clipped. Use the previous and next page arrows if the preview shows more than one page.
- Judge the text size before printing. A worksheet with many rows and columns may technically fit on one page but become too small to read. Use the preview zoom to inspect the print, not as a substitute for changing the actual layout. If text is hard to read, return to the worksheet and reduce unnecessary columns, shorten overly wide headings, use landscape orientation, or print a selected range. You can also use a larger paper size if your printer supports it.
- Print or save a PDF. Once the preview looks right, check the printer, number of copies, and paper settings in the Print screen, then click Print. To make a PDF instead, choose a PDF printer such as Microsoft Print to PDF in the printer list, then click Print and choose where to save the file. Open the resulting PDF to verify its page count and readability before sharing it.
Excel for Mac has similar page setup controls on the Page Layout tab, including orientation, paper size, margins, and scaling. If you do not see the same Scale to Fit group, open File > Print and use the scaling choices available in the print dialog. In Excel for the web, use File > Print and review the browser or Excel print preview; some page setup options differ from the desktop app, so open the workbook in desktop Excel if you need more control.
Common Mistakes
- Setting width to one page but leaving height at one page unintentionally, or vice versa. If you want every row and column on a single sheet of paper, both dimensions must be one page. If you only need the columns to fit, leave height automatic so rows can continue onto additional pages at a more readable size.
- Forgetting an existing print area. Excel may print only a previously defined range, even if you now expect the full worksheet. Clear the print area or set it again to the correct cells, then check the preview.
- Assuming fit to one page means fill the paper edge to edge. Scaling fits the content inside the printable region. Most standard printers leave margins, and Excel cannot override the printer’s physical limits.
- Printing without checking text size. Excel can shrink a very large range dramatically. A one-page result is not useful if the values cannot be read, so inspect the preview and consider splitting the sheet into sections.
- Using the wrong paper size or orientation. A workbook set to A4 but printed on Letter, for example, may be scaled or clipped unexpectedly. Match Excel’s page size to the printer’s loaded paper.
Tips
- Use Fit All Columns on One Page when readability matters. In File > Print, the scaling menu includes Fit All Columns on One Page. This keeps the width together but allows the rows to span multiple pages. It is often better than forcing a long report onto a single page.
- Check page breaks before changing the layout. Choose View > Page Break Preview to see how Excel divides the worksheet. You can drag blue page-break lines to adjust the divisions. Return to View > Normal when finished.
- Improve the worksheet before shrinking it. Remove blank columns within the data, use concise headings, and set sensible column widths. If a few columns contain notes or long descriptions, consider moving them to another printout rather than reducing every cell to fit them.
- Repeat column headings on multi-page prints. When you choose to fit columns across pages but let rows continue, use Page Layout > Print Titles and set rows to repeat at the top. This keeps labels visible on each printed page. It is not necessary for a true one-page print, but is useful if you decide that one page is too cramped.
- Save the workbook after changing page setup. Print settings are saved with the worksheet, so saving helps preserve the orientation, print area, margins, and scaling for the next time you print.
Troubleshooting
The preview shows multiple pages. Confirm that both Width and Height are set to one page in the Scale to Fit group, and check that the active sheet is the one you changed. Also look for separate print areas, page breaks, or a selection that includes a second worksheet. In the Print screen, verify that the scaling choice is not set to No Scaling.
The worksheet fits, but the print is tiny. This usually means the selected range is too large for one page. Switch to landscape, use narrower margins, or define a smaller print area. If the sheet is long, use Fit All Columns on One Page and let it print on multiple pages vertically. Another option is to increase the paper size, provided the printer supports it.
Some cells are missing from the preview. Check whether the cells lie outside the print area, in hidden rows or columns, or on a different worksheet. Use Page Layout > Print Area > Clear Print Area to remove a restrictive setting, then inspect the preview again. If only part of the sheet is needed, select the intended range and set the print area anew.
Content is cut off at the edge. Match the paper size in Excel to the paper loaded in the printer, and try wider margins. Printer drivers can impose non-printable edges even when the Excel preview appears close to the page boundary. If clipping persists, reduce the print area slightly or use the printer driver’s borderless option only if the printer supports it.
The scaling controls seem to reset. Excel can adjust scaling when you change page setup options or switch printers. Set the paper size and orientation first, then set Width and Height, and check the preview again. If printing to PDF looks different from the physical printer, select the intended printer before reviewing the final preview.
Frequently Asked Questions
How do I print an Excel sheet on one page without making it unreadable?
First try landscape orientation, the correct paper size, and narrower margins. If the range is still too large, print only the important columns or use Fit All Columns on One Page so rows can continue onto other pages. Excel cannot keep all content at its original size and force an oversized range onto one sheet.
What is the difference between Fit Sheet on One Page and Fit All Columns on One Page?
Fit Sheet on One Page scales both the width and height to one sheet, so the whole print area becomes one page. Fit All Columns on One Page fits the width but may create several pages down the length of the sheet. The latter is often more legible for long lists.
Can I print just a selected range in Excel?
Yes. Select the cells, then choose Page Layout > Print Area > Set Print Area. Open File > Print to confirm that only the intended cells appear. Clear the print area when you later want to print the entire worksheet.
Why does Excel leave white space around the page?
Excel respects page margins and the printer’s printable area. Standard printers usually cannot print all the way to the paper edges. Choose narrower margins if suitable, but true edge-to-edge output requires a printer and paper setup that support borderless printing.
Will printing one page change how my worksheet looks on screen?
No. Scaling is a page setup setting and changes the printed output, not the cell sizes or values in the worksheet. You can adjust or clear the scaling later without changing the underlying data.
Can I print an Excel worksheet to one page as a PDF?
Yes. Set the scaling, inspect File > Print, and select a PDF printer such as Microsoft Print to PDF. Save the file, then open it to confirm that it has the expected page count and that text remains readable.
Related
- Merge in Excel Without Merging: Center Across Selection
- How to Merge Cells in Google Sheets Without Losing Data
- How to Merge Excel Files Using Power Query in Excel
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Data Validation Custom Lists: Setup and TipsIn Excel for Microsoft 365 on Windows, create a custom drop-down by selecting the cells, choosing Data >…
- Wrap Text in Excel and Google Sheets: Step-by-StepTo wrap text, select the cell or range, then turn on wrapping: in Excel for Microsoft 365 on…
- Building a Heat Map in Excel: Steps, Scales, and TipsTo build a heat map in Excel, select the numeric cells, then choose Home > Conditional Formatting >…
- How to Delete Highlighted Cells in ExcelTo delete cells highlighted with a particular fill color in Excel for Microsoft 365 on Windows, use Home…
- Best Way to Compare Data in Two Excel Sheets: 5 MethodsFor most people, the best way to compare data in two Excel sheets is to match records using…
- How to Make Two Numbered Columns in Microsoft WordTo make two numbered columns in Word, choose Layout > Columns > Two, then start or select one…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.