To print an Excel worksheet without clipped columns or missing rows, open File > Print, check the preview, then adjust orientation, paper size, margins, or scaling under Page Layout. For most wide sheets, set the page to landscape and choose Fit All Columns on One Page; check that the text remains readable before printing. You will need access to the workbook and a printer or PDF option.
What You’ll Need
- The Excel workbook you want to print, preferably with the data already arranged and formatted.
- A printer with paper loaded, or a PDF destination such as Microsoft Print to PDF.
- The paper size you plan to use, such as Letter or A4. Excel’s selected paper size should match the printer’s paper.
The instructions below are for Excel for Microsoft 365 on Windows. Excel for Mac has similar Page Layout and print-preview controls, though some dialog layouts differ. Excel for the web has fewer page setup options; if a control described here is unavailable, open the workbook in the desktop app.
Step-by-Step
- Check the print preview before changing anything. Select File > Print or press Ctrl+P. The preview shows what Excel intends to print, including page boundaries and the selected printer. Use the next-page and previous-page arrows below the preview to inspect every page, not just the first. If a column is cut off, or the preview shows an unexpected blank page, note where the problem occurs. Press Esc to return to the worksheet without printing. On Mac, use Command+P to open the print screen.
- Confirm the printer and paper size. In the Print screen, choose the correct printer, or select Microsoft Print to PDF if you want to inspect or share a PDF first. Under printer settings, check that the selected paper size matches the paper loaded in the printer. If the printer is set to Letter but the worksheet setup uses A4, or vice versa, Excel may shift content or add pages. If the correct paper size is not available, check the printer driver or use the size the printer supports.
- Set the page orientation. Return to the sheet, select Page Layout > Orientation, and choose Landscape for a worksheet with many columns. Use Portrait for a narrow table or a mostly vertical report. Orientation gives the sheet more room in one direction, but it does not itself shrink content or guarantee that every column will fit. Reopen File > Print and check the preview after changing it.
- Choose the paper size and margins. On the Page Layout tab, select Size and choose the paper that will actually be used. Then choose Margins. Try Narrow if the content is only slightly too wide or tall; keep Normal margins if the printer needs more space near the edges. Avoid entering very small custom margins unless the printer supports borderless printing. A printer’s unprintable edge area can still leave a white border even when the worksheet margins are narrow.
- Scale the sheet to fit the page width. For a wide worksheet, choose Page Layout > Scale to Fit and set Width to 1 page. Leave Height set to Automatic so Excel can continue the sheet onto additional pages vertically. This is usually more readable than forcing a long worksheet onto one sheet of paper. In some ribbon layouts, the scaling controls appear as Width, Height, and Scale boxes in the Scale to Fit group. You can also use the scaling menu in File > Print and select Fit All Columns on One Page.
- Use a one-page fit only when the content is small enough. If the entire worksheet is short and narrow, select Fit Sheet on One Page in the Print screen. This reduces both the width and height to fit a single page, which can make text extremely small on a large worksheet. For a long table, select Fit All Rows on One Page only if the resulting preview remains readable. If it does not, return to No Scaling or use only the one-page-wide setting. Excel’s scaling changes print size; it does not change the worksheet’s on-screen column widths.
- Set a print area if only part of the sheet belongs on paper. Select the cells you want printed, then choose Page Layout > Print Area > Set Print Area. Excel will print that range rather than every used cell on the sheet. To remove an old or incorrect selection, choose Page Layout > Print Area > Clear Print Area. Check the preview afterward: content outside the selected range will not print, even if it is visible on the worksheet. If separate sections need different layouts, it may be simpler to print them separately.
- Review page breaks and repeat headings when needed. Select View > Page Break Preview to see where Excel divides the worksheet. Drag a blue page-break line to adjust a break, or use Page Layout > Breaks > Reset All Page Breaks if manual breaks are causing awkward splits. For a multi-page table, select Page Layout > Print Titles. In the Page Setup dialog, use Rows to repeat at top and select the row or rows containing column headings. Return to Print Preview and move through the pages to confirm the headings repeat and the data is not split in an inconvenient place.
- Print a test page or save a PDF. When the preview looks right, print one copy first, especially for a long report or an unfamiliar printer. Alternatively, choose Microsoft Print to PDF and inspect the resulting file at normal zoom. Confirm that no text is clipped, the last column is present, and page numbers or repeated headings are where you expect them. If the result is good, return to File > Print, confirm the number of copies, and print the full set.
Common Mistakes
- Fitting everything onto one page automatically. This can shrink a worksheet with many rows and columns until the printed text is difficult to read. Usually, fit the width to one page and let the height use as many pages as needed. If necessary, divide a very large table into sections.
- Changing the worksheet view instead of print settings. Hiding gridlines or changing zoom does not fix a page that is too wide. Zoom affects how large the sheet looks on screen, while print scaling, orientation, paper size, and margins control the printed layout. Use Print Preview to judge the actual output.
- Printing the wrong range. A print area left over from an earlier job can omit new columns or rows. Conversely, stray formatting far below or to the right of the real data can make the printout include extra blank pages. Clear the print area when needed, and inspect the preview page count and contents.
- Ignoring the printer’s paper and margins. Selecting A4 in Excel while the printer is loaded with Letter paper can cause unexpected scaling or page breaks. Margins that are too small for the printer can also result in edges being cut off. Match the paper settings and leave a printable margin.
Tips
- Make the table more compact before shrinking it. Widen only columns that need to display their contents, shorten unnecessarily long headings, and wrap text selectively. This can preserve legibility better than aggressive scaling. If a column is cut off in the worksheet itself, resizing it may solve the issue before you print.
- Use landscape selectively. Landscape is helpful for wide tables, but it gives a narrow report less vertical space and may create more pages. Choose orientation based on the shape of the data, then check the preview rather than assuming one setting fits every worksheet.
- Keep headings with the data. Repeat column-heading rows on multi-page printouts so readers can identify each column on later pages. If a row is splitting between pages, adjust the page break or row height and preview again. For a report with a title, include it in the print area or set it as a repeating row if it should appear on every page.
- Check the page count and print range together. A sudden increase in pages can signal a stray formatted cell, an incorrect print area, or a scaling choice. Use Page Break Preview to identify the extra area, then clear or reset the relevant setting instead of printing multiple blank pages.
Troubleshooting
The last column is still missing. Confirm the print area includes it, then try landscape orientation and set Width to 1 page. Check that the paper size matches the printer. If the column appears only after scaling, zoom into the preview to make sure the text is still readable; otherwise, consider printing that section separately or using larger paper.
The print is tiny. In File > Print, check whether Fit Sheet on One Page or another scaling option is selected. Switch to Fit All Columns on One Page, or choose No Scaling and let Excel use more pages. You can also reduce unnecessary column widths or split the worksheet into smaller print areas.
There are blank pages or unexpected extra pages. Inspect Page Break Preview for stray page breaks, and use Page Layout > Breaks > Reset All Page Breaks if needed. Check whether the print area extends beyond the data. If a formatted cell far from the table is making the used range large, clear unwanted formatting from the extra rows or columns, save the workbook, and check the preview again.
The preview looks right but the printer cuts off an edge. Verify the printer’s paper size and print settings, then leave wider margins. Some printers cannot print close to the edge of the paper. A PDF can help distinguish an Excel layout issue from a printer-specific limitation: if the PDF looks correct but paper output does not, check the printer driver and its printable-area settings.
The Page Layout controls are unavailable or different. In Excel for the web, open the file in the desktop app if you need options such as detailed page breaks or print titles. On Mac, look for the same orientation, size, margins, and scaling choices on the Page Layout tab or in the print dialog; exact dialog placement can vary by Excel version and printer.
Frequently Asked Questions
How do I print all Excel columns on one page?
Choose File > Print > Fit All Columns on One Page, or set Page Layout > Scale to Fit > Width to 1 page. Leave Height as Automatic if the sheet needs multiple pages vertically, and check readability in the preview.
Why does Excel cut off the last column when printing?
The sheet may be too wide for its current orientation, paper size, margins, or scaling. A print area may also exclude that column. Check the preview, switch to landscape if useful, confirm the print area, and fit the width to one page if the type stays readable.
How can I print a large spreadsheet without making the text too small?
Avoid fitting both width and height to one page. Fit only the columns across one page, allow rows to continue on additional pages, and repeat the heading row. If that is still too small, print in sections or use larger paper rather than reducing the scale further.
How do I print only selected cells?
Select the cells, then choose Page Layout > Print Area > Set Print Area. Verify the selection in Print Preview. To return to printing the sheet normally, choose Page Layout > Print Area > Clear Print Area.
Can I save the layout as a PDF before printing?
Yes. In File > Print, select Microsoft Print to PDF as the printer, then save the file. Review the PDF at normal zoom to check for missing columns, clipped text, unwanted blank pages, and legibility before sending it to a physical printer.
Related
- How to Keep Spaces Between Text When Concatenating in Excel
- How to Keep the Top Row Visible on Every Excel Print Page
- How to Keep Excel in Share Mode for Multiple Users
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Google Sheets FILTER: Array Formulas ExplainedIn Google Sheets, use FILTER to return rows or columns that meet conditions; it expands its results automatically,…
- Excel Freeze Panes in the Middle of a Sheet: How It WorksYes. In Excel for Microsoft 365 on Windows, select the cell immediately below and to the right of…
- How to Double Space a Header in Microsoft Word 365To double space a header in Word, open the header, select its text, then choose Home > Line…
- How to Change Your Name on Track Changes in Microsoft WordTo change the name Word attaches to new tracked edits, update the Office user name: in Word for…
- Replace Data in Excel: Find and Replace GuideTo replace data in Excel, press Ctrl+H, enter the existing content in Find what and the new content…
- Google Sheets Checkbox and Text in One Cell? OptionsNo—a Google Sheets cell cannot display its native, clickable checkbox and separate label text at the same time.…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.