If an Excel print area is cut off, first check the worksheet in File > Print to see what is missing, then adjust the print area, page orientation, margins, or scaling on the Page Layout tab. A missing edge may mean the selected range is wrong, the content has flowed onto another page, or the printer cannot print close to the paper edge; the fix depends on which one you see in Print Preview.
Identify what “cut off” means
Excel separates a worksheet into printed pages according to the paper size, margins, orientation, scaling, and page breaks. A table wider or taller than one page may continue onto another page rather than disappear. If you are looking at only the first page in the preview, columns or rows may be on a later page. Conversely, if the preview itself shows text or a border clipped at the page edge, the print layout needs adjustment.
Open File > Print, or press Ctrl+P on Windows (Command+P on Mac), and inspect every page using the preview navigation. Check the selected printer and paper size as well. This distinction saves time: changing a print area will not solve a table that is simply split across pages, and scaling will not restore cells that were excluded from the print area.
- Missing rows or columns in every preview page: check the print area and hidden rows or columns.
- Some columns appear on a second page: change orientation, margins, or width scaling.
- Content is visible in preview but missing on paper: check the printer, paper size, printable margins, and printer settings.
- A boundary cuts through a table: inspect page breaks and scaling.
Check, set, or clear the print area
A print area is a range Excel is instructed to print. If a print area is set, Excel may omit other worksheet cells even when they contain data. On Windows, select the worksheet and choose Page Layout > Print Area > Clear Print Area to remove the saved range and test whether that is the cause. Then open Print Preview again. Clearing the print area does not delete worksheet content; it returns printing to the normal used content on that sheet.
To define a fresh area, select the cells to print and choose Page Layout > Print Area > Set Print Area. For example, if a report occupies A1:G38, select that range before setting it. Excel outlines the print area on the sheet. You can also use Page Layout > Print Area > Add to Print Area to include another selected range. Separate, nonadjacent print areas may print as separate areas rather than as one continuous table, so check the resulting page order in preview.
Print areas are associated with individual worksheets. If a workbook has several tabs, verify the active sheet and repeat the check on each sheet that prints incorrectly. A print area can also remain saved in the workbook after cells are edited, so a range that made sense earlier may now exclude newly added columns or rows. If you want all current content printed, clearing the area is often the quickest diagnostic step.
Fit the content to the page without making it unreadable
For a wide report, changing the orientation or fitting the width is usually better than shrinking the entire sheet to one page. On the Page Layout tab, set Orientation > Landscape to use the wider side of the paper. Then, in Scale to Fit, set Width to 1 page and leave Height as Automatic if the table can continue down additional pages. This keeps all columns together while allowing rows to flow onto subsequent pages.
Setting both Width and Height to one page forces the whole print area onto a single sheet of paper. That can solve a small, compact report, but it can make a large worksheet too tiny to read. Check the preview at actual page size before printing. Excel’s scaling affects the printed layout, not the displayed cell values or the underlying row and column sizes.
Another option is to open the Page Setup dialog using the small dialog box launcher in the Page Setup group on the Page Layout tab, then use the Page tab’s scaling choices. The labels and layout can vary somewhat by Excel version, but the same trade-off applies: fit to a specified number of pages, or set a percentage scale. If a spreadsheet is only slightly too wide, a modest reduction may preserve readability better than fitting a very large range onto one page.
Adjust paper size, margins, and printer limits
Confirm that Excel’s paper size matches the paper loaded in the printer. Choose Page Layout > Size and select the intended size, such as Letter or A4, where available. The paper-size list can depend on the selected printer and its driver. A mismatch can change page boundaries: a workbook laid out for Letter may wrap differently when printed on A4, for example.
Margins determine how much of each page is available for worksheet content. Choose Page Layout > Margins and try Narrow or Custom Margins if the preview shows a small portion spilling onto another page. Do not assume that setting every margin to zero will work. Many printers have a nonprintable edge, and the driver may enlarge or reposition the printable area, clip content, or warn that margins are outside the printable region.
If the preview looks correct but the physical print loses a narrow edge, check the printer’s paper-size setting and print scaling options as well as Excel’s. Avoid selecting a printer option that enlarges the page to fill the paper when the worksheet already sits close to the edges. The exact wording depends on the printer. Mac users can make page layout choices in Excel and review the macOS print dialog, where printer-specific paper and scaling options may be presented differently.
Use page breaks to control where pages split
Page breaks decide where Excel divides a worksheet into printed pages. Choose View > Page Break Preview to see the page boundaries. A solid line generally marks a page break, while a dashed line can show an automatic break; the display can depend on whether breaks have been adjusted. If a break cuts through a group of related columns or rows, you can drag a break in Page Break Preview to change the division. You can also use Page Layout > Breaks to insert, remove, or reset page breaks.
Manual breaks can be useful when a report has natural sections, but they can also cause unexpected extra pages after scaling or changing paper size. If the layout has become confusing, reset the page breaks and inspect the automatic layout again. On Windows, use Page Layout > Breaks > Reset All Page Breaks. A reset removes manual page-break choices; it does not erase worksheet data or clear the print area.
For a long list with many pages, consider whether column headings should repeat at the top of each page. Open Page Layout > Print Titles and set rows to repeat at top or columns to repeat at left in the Page Setup dialog. This does not prevent clipping, but it makes multi-page printouts easier to interpret. It is especially useful when the first page contains headings that otherwise do not appear on later pages.
Check hidden content, selection, and workbook state
Rows and columns hidden on the worksheet are generally not printed as visible content. Unhide any data that should appear, then check Print Preview again. Also make sure the content is actually inside the print area: formatting, borders, or a nearby blank column do not necessarily mean Excel includes every surrounding cell in the intended range. A chart or object that extends beyond the print range may also need its position or size adjusted.
In the Print screen, check the print scope setting. Excel can print the active sheet, the entire workbook, or a current selection. If Print Selection is chosen, only the selected cells are sent to print; if you meant to print the whole sheet, choose the active-sheet option instead. When printing several worksheets, confirm that the correct tabs are selected and that each sheet has the desired page setup. These settings are separate from whether a print area exists.
Before changing a complex workbook, save a copy if its page layout is important. Print setup can be saved with the workbook, and changing orientation, scaling, or breaks may affect the layout other people see when they open it. Excel for Mac has comparable page-layout and print-preview controls, though ribbon organization and the system print dialog differ. In Excel for the web, available print and page-layout controls can differ from the Windows desktop app; use the desktop app when you need the full range of page setup options.
A practical troubleshooting order
Use this sequence to avoid changing several settings at once and losing track of the cause:
- Open File > Print and inspect all preview pages, not just the first one.
- Confirm the print scope, active worksheet, printer, and paper size.
- Clear the print area temporarily to see whether excluded cells reappear; reset it to the intended range if needed.
- For a wide table, try Landscape orientation, then set Width to one page and Height to Automatic.
- Adjust margins only if the preview shows that a small amount of content needs more room.
- Inspect Page Break Preview and reset or reposition breaks if a page boundary divides the report badly.
- Review the final preview at readable size before printing, and check the printer dialog if paper output differs from the preview.
For example, suppose a sales table runs from A1 through H42, but the first printed page shows only columns A through F. If the preview shows columns G and H on page two, the print area is not necessarily wrong: switch to Landscape and fit the width to one page while leaving height automatic. If G and H are absent from every page, clear the print area and check whether the saved range ends at column F. If all eight columns appear in preview but the printer clips the right border, check paper size, margins, and the printer’s own scaling or printable-area settings.
Frequently Asked Questions
Why is Excel printing only part of my spreadsheet?
Excel may have a print area set, the Print screen may be set to print a selection, or the rest of the content may be on another page. Check File > Print, then clear the print area temporarily and inspect all preview pages.
How do I fit all columns on one page but keep multiple pages tall?
On the Page Layout tab, set Scale to Fit > Width to 1 page and leave Height as Automatic. Review the preview to confirm the text remains readable.
Will clearing the print area delete cells?
No. Page Layout > Print Area > Clear Print Area removes the instruction that limits what Excel prints; it does not remove data, formulas, or formatting from the worksheet.
Why does Excel show the whole page in preview but the printer cuts off an edge?
The printer may have a nonprintable margin, or its paper size or scaling may differ from Excel’s settings. Compare the selected paper size in Excel and the printer dialog, and avoid border-to-border layouts unless the printer supports them.
Why did my print layout change after adding columns?
A saved print area may still end at the earlier column, or the added columns may push the sheet onto another page. Update or clear the print area, then review orientation, scaling, and page breaks in Print Preview.
Related
- Wedding Budget Spreadsheet: Free Online Options and Setup
- Excel Power Query: How to Split Text into Separate Columns
- Wedding Budget Planner Spreadsheet Free: How to Use It
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Microsoft Excel Formula Not Calculating? Fix ItIf a Microsoft Excel formula is not calculating, first check Formulas > Calculation Options and select Automatic. If…
- Ctrl+F Not Working in Excel? Common Causes and FixesIf Ctrl+F is not finding what you expect in Excel for Microsoft 365 on Windows, open Home >…
- Excel Cell Height Not Adjusting? Fix the Common CausesIf an Excel cell’s height is not adjusting, select the affected row or rows and choose Home >…
- VLOOKUP Not Working? Common Excel Causes and FixesVLOOKUP usually fails because the lookup value and the first column of the search range do not match…
- Why COUNTIF Isn’t Working in Excel and How to Fix ItCOUNTIF usually appears not to work because its criteria do not match the cells exactly, the data contains…
- Data Table Input Cell Reference Is Not Valid in ExcelIn Excel, “Data table input cell reference is not valid” usually means the Row input cell or Column…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.