Excel Not Printing All Rows? Fix the Print Settings

Errors & fixes · Updated November 18, 2026

If Excel is not printing all rows, check that File > Print is not set to print only a selection or a limited page range, then clear any print area and unhide or unfilter the missing rows. In Excel for Microsoft 365 on Windows, these checks solve many cases; Print Preview helps show whether rows are excluded or simply continue onto another page.

Start with Print Preview and the print scope

Open File > Print, or press Ctrl+P on Windows (Command+P on Mac). Look at the preview and the Settings area before sending the job to a printer. If rows are absent from the preview, the cause is usually in the worksheet’s print settings or visibility. If the preview contains them but the paper does not, check the printer, paper, and page-range settings.

Under Settings, confirm the option matches what you mean to print:

  • Print Active Sheets prints the currently active worksheet or selected worksheets.
  • Print Entire Workbook includes every worksheet in the workbook, not just the visible sheet.
  • Print Selection prints only the cells selected before opening Print.

If Print Selection is selected, Excel will leave out rows outside the highlighted range. Choose Print Active Sheets to print the full active sheet instead. Also check the Pages boxes in the print screen: if a starting and ending page have been entered, Excel prints only that page range. Clear those limits if you want the complete output. The preview’s page counter can help distinguish a missing-row problem from a document that spans more pages than expected.

Clear a print area that stops before the last row

A print area is a saved worksheet setting that tells Excel which cells to include when printing. If it covers rows 1 through 40 but your data continues to row 75, the remaining rows may be missing even though they are visible on screen. This can happen when someone set a print area for an earlier report and later added more records.

To remove that restriction in Excel for Windows, select the affected sheet and choose Page Layout > Print Area > Clear Print Area. Then open File > Print again and inspect the preview. Clearing the print area lets Excel determine the printable range from the sheet’s contents and current print settings.

If you need a specific range, select all the cells you want included and choose Page Layout > Print Area > Set Print Area. For example, if a report has a title and records in rows 1 through 75, select the intended columns and rows through 75 before setting the area. Remember that a print area applies to the worksheet, so adding new rows below it does not necessarily expand it automatically. Clear or reset it when the report grows.

When a sheet has more than one print area, Excel can treat the separate areas as separate print ranges. That may produce unexpected pages or gaps. Clearing the saved area and setting one continuous range is a useful test when the preview looks fragmented.

Check for hidden, filtered, or collapsed rows

Excel does not print rows hidden by a filter, manually hidden, or concealed inside a collapsed outline. Those rows may still exist in the worksheet, so scrolling or checking the row numbers can reveal the issue. A jump in the row headings—for example, from 18 to 24—often indicates that rows 19 through 23 are hidden.

For manually hidden rows, select the row headings on either side of the gap, right-click, and choose Unhide. To unhide all rows, click the select-all corner above row 1 and left of column A, then choose Home > Format > Hide & Unhide > Unhide Rows. This changes visibility on the sheet, so use it only if you want those rows visible as well as printable.

For filtered lists, look for filter arrows with criteria applied. Choose Data > Sort & Filter > Clear to clear the active filter criteria while retaining the filter controls. Alternatively, open the relevant column’s filter menu and select all items. If a worksheet uses an outline, expand the collapsed group with its plus sign or outline-level control. After changing visibility, return to Print Preview; rows excluded by a filter should appear once the filter is cleared.

A common misconception is that a row that is not on the first printed page has been lost. Excel may simply have continued it onto a later page. Use the preview’s next-page control and check the page count before changing the worksheet.

Adjust scaling without shrinking the report too far

Scaling controls how worksheet content fits on printed pages. It usually changes the size or page layout rather than deleting rows. In File > Print, the scaling menu may offer options such as Fit Sheet on One Page and Fit All Columns on One Page. The first compresses both the width and height onto a single page; a long sheet can become too small to read. The second fits the columns across the page while allowing the rows to continue onto additional pages.

You can set this more explicitly on the ribbon. Choose Page Layout and, in the Scale to Fit group, set Width to 1 page and Height to Automatic when the main problem is columns spilling onto extra pages. This keeps the rows flowing across as many pages as needed. If Height is set to 1 page, Excel tries to squeeze all rows vertically onto one page, which can make the text extremely small.

Paper size and orientation affect how much fits on each page. A wide table may be easier to read with landscape orientation or a larger paper size, if the printer supports it. Choose Page Layout > Orientation > Landscape to test the orientation. Check Print Preview afterward: a layout that fits the width may still require multiple pages vertically, which is normal for a long list.

Review page breaks and the selected page range

Page breaks divide a worksheet across printed pages. Automatic breaks are calculated from the paper size, margins, scaling, and content; manual breaks are breaks added by a user. A manual break can make a report paginate unexpectedly, but it does not normally erase rows. In Print Preview, inspect later pages and check the Pages boxes to make sure the output is not restricted to only the first page.

To review the layout on the sheet, choose View > Page Break Preview. The blue lines show page boundaries, and content outside the printable pages may appear in a different area. If an unexpected manual break is the issue, choose Page Layout > Breaks > Reset All Page Breaks, then review the preview again. Resetting breaks can change where pages divide, so it is worth checking the report’s headings and totals afterward.

If only a few pages are missing from the printed result, compare the page numbers in Excel’s preview with the page range in the print dialog and with any page-range option in the printer’s own dialog. Those are separate controls: Excel can create the full document while the printer is instructed to output only selected pages.

Check repeated headings and page setup

Repeated title rows can make a multi-page report easier to follow, but they do not determine which data rows print. If column labels appear only on the first page, set them to repeat: choose Page Layout > Print Titles, then enter the row range in Rows to repeat at top. For example, entering $1:$2 repeats the first two rows on each printed page. Confirm the result in Print Preview.

Do not confuse repeated headings with a print area. Print Titles repeats selected rows or columns on pages; it does not add rows outside the print area or reveal filtered data. If a table appears to start partway down a page, check margins and page breaks as well as the print area. If text is cut off inside a cell, adjust column width, row height, wrapping, or scaling; that is different from a row being omitted entirely.

When the preview is right but the paper is not

If the preview includes every row but the physical output does not, the worksheet may be configured correctly. Check whether the printer is paused, out of paper, or showing an error, and verify that the expected printer is selected. Review the printer’s own page range and paper-size options, then compare its job status with the number of pages shown in Excel’s preview. A printer can receive a job successfully but stop before all pages finish.

Try printing the workbook to PDF if that option is available, then inspect the resulting pages. If the PDF contains all rows, the worksheet’s print layout is likely intact and the issue may be with the printer or its driver. If rows are missing from the PDF too, return to the print area, filters, hidden rows, and scaling checks. Excel for Mac uses File > Print and Command+P for the print screen; printer dialogs and some ribbon arrangements can differ. Excel for the web also has a browser-based print flow, so its final print options may be controlled partly by the browser.

A quick order for troubleshooting

When you are unsure where to begin, work through the checks in this order rather than changing several settings at once:

  1. Open File > Print and confirm Print Active Sheets or the intended print scope is selected.
  2. Clear any page numbers in the Pages fields if you want the full document.
  3. Choose Page Layout > Print Area > Clear Print Area.
  4. Unhide rows, clear filters, and expand any collapsed outline groups.
  5. Set scaling to fit the columns across pages without forcing every row onto one page.
  6. Review page breaks and check every page in Print Preview.
  7. If the preview is complete, troubleshoot the printer or its own print settings.

After finding the cause, save the workbook if you want the corrected print area, scaling, or page setup to remain available. If you only changed a temporary selection or printer page range, those choices may not be saved as worksheet settings.

Frequently Asked Questions

Why does Excel print only the first few rows? A saved print area, Print Selection, a page range, or hidden rows can limit the output. Check File > Print first, then clear the worksheet’s print area and inspect filters or hidden row numbers.

How do I print all rows in Excel on one page? In File > Print, choose Fit Sheet on One Page, or use Page Layout > Scale to Fit and set both Width and Height to 1 page. A long worksheet may become difficult to read when compressed, so fitting columns to one page while leaving Height set to Automatic is often more practical.

Why are filtered rows missing from my printout? Excel prints the rows currently visible after filtering, not records excluded by the filter. Clear the filter with Data > Sort & Filter > Clear, or select all items in the filter menu, then check the preview again.

How can I tell whether a row is hidden? Look for a jump in the row numbers or a narrow gap between row headings. Select the row headings around the gap, right-click, and choose Unhide. Also check whether an outline group is collapsed.

Why does Print Preview show all rows but my printer does not? Check the printer’s page range, paper supply, status, and selected device. Printing to PDF can help determine whether the missing pages come from Excel’s layout or from the printer’s settings or operation.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.