How to stop Excel being cut off in PDF and print
Excel is usually cut off because the worksheet’s print area, scaling, orientation or paper size does not match the range you want to output. Open File > Print first: if columns or rows are already missing in the preview, correct the page setup in Excel before printing or creating the PDF. If other documents are also affected, use the broader printing problems guide to check the printer, PDF viewer and physical paper settings.
Excel divides the worksheet according to its page setup
An Excel worksheet has no fixed paper boundary while you edit it. You can continue adding columns and rows far beyond the width or height of a printed page. When you print the sheet or turn it into a paginated PDF, Excel has to divide that grid into pages.
Excel calculates those divisions from several settings:
- the cells included in the print area;
- the selected paper size, such as A4 or Letter;
- portrait or landscape orientation;
- page margins and space reserved for headers or footers;
- the scaling percentage or number of pages specified;
- automatic or manual page breaks;
- whether you are printing the active sheet, the whole workbook or only a selection.
This means “cut off” can describe two different results. The distinction matters because they require different fixes.
In the first case, the missing columns or rows are not included in the output at all. This commonly happens when the worksheet has an old print area or when Print Selection is active. Scaling cannot recover data that Excel was never instructed to print.
In the second case, the content is included but divided across additional pages. A wide sheet might put columns A to G on page 1 and columns H to M on page 2. If you view, share or print only the first page, the right side appears to have been cut off even though it exists later in the output.
A defined print area is saved with the workbook. Someone may therefore set a print area for an earlier version of a report, add more columns later and forget to expand the saved range. Excel continues printing the saved area until it is changed, cleared or explicitly ignored.
A worksheet can also contain more than one print area. If those areas are not adjacent, Excel treats them as separate ranges and prints each one on a separate page. That can create an unexpected PDF in which related parts of a report are separated.
Scaling changes how the included cells fit onto pages. Setting the worksheet to 1 page wide reduces its width until all included columns fit across one page, while allowing the rows to continue onto as many pages as necessary. Setting both width and height to one page forces the entire range onto a single sheet, which can make a large spreadsheet too small to read.
Orientation and paper size determine how much horizontal space is available before scaling is applied. Landscape orientation gives a wide table more room than portrait orientation. A larger paper size provides more space, but only if the printer, Excel page setup and actual paper agree on that size.
Margins reduce the printable area inside the sheet of paper. Narrowing them can recover some space, but margins should not be treated as the main solution for a worksheet that is much wider than the page. The printer may also have a non-printable border that Excel cannot use.
The print preview shows which setting is causing the problem
Use File > Print or press Ctrl+P before changing several settings at once. The preview shows the page divisions Excel currently intends to use, making it easier to separate an excluded range from a scaling or paper-size problem.
Missing cells point to the print area or print selection
Look at the final used column and row in the worksheet, then compare them with the preview. If data is completely absent from every previewed page, check what Excel has been told to print.
Under Settings, confirm that the correct option is selected:
- Print Active Sheets prints the selected worksheet or worksheets.
- Print Entire Workbook includes every worksheet in the workbook.
- Print Selection includes only the cells selected before the print window was opened.
You can inspect the permanent setting from Page Layout > Print Area. A print area that ends at column G will exclude columns H onward even if those later columns contain data. Clearing the print area returns the sheet to its full used range; setting it again lets you define the exact report that should be printed.
Check for multiple print areas as well. Non-adjacent ranges are output separately rather than being joined into one continuous table.
Extra horizontal pages indicate a width problem
Use the page arrows in Print Preview to inspect every page, not just the first one. If the missing columns appear on page 2, 3 or later, Excel has included them but cannot fit the full width into the current page geometry.
Open View > Page Break Preview to see those divisions on the worksheet. Dashed lines represent automatic page breaks calculated by Excel. Solid lines represent page breaks that were added manually.
A vertical break through the table shows where the next printed page begins. Before forcing everything onto one page, consider whether the sheet would remain readable. For a long but moderately wide report, 1 page wide by Automatic pages tall is usually more practical than putting the entire worksheet on one page.
Very wide tables may need a structural change. Removing empty or unnecessary columns from the print area, reducing unusually large column widths or splitting unrelated groups of data can produce a clearer document than extreme scaling.
Tiny text means the sheet is being over-scaled
If all the columns appear but the text is extremely small, look for a setting such as Fit Sheet on One Page. Excel is doing what that option requests: reducing the complete print area until both its width and height fit on one page.
This can work for a compact table. It is rarely suitable for a worksheet with dozens of columns, hundreds of rows or both. A low scaling percentage is a warning that the output may technically fit while remaining impractical to read.
Change the setting to fit only the width:
- Set Width to 1 page.
- Set Height to Automatic.
The columns then stay together across the page width, while the rows can continue onto later pages at a more readable size. If the worksheet contains only a few extra columns, changing to landscape orientation or choosing narrower margins may allow a less aggressive reduction.
A preview mismatch points to paper or printer settings
Confirm the paper size in Excel before exporting or printing. A worksheet arranged for A4 can divide differently when the selected printer expects US Letter paper, and the reverse is also true. The formats have different dimensions, so changing between them can move page breaks or require a different scaling percentage.
Check the paper size in both Page Layout > Size and the selected printer’s properties. The printer must also contain the paper size specified. Microsoft notes that if the printer’s paper setting differs from the paper loaded in the device, Excel may adjust the output and the printed result may not match the preview.
If the Excel preview looks correct but the physical print is clipped, test the same worksheet by creating a PDF. A correct PDF paired with an incorrect physical print points away from the workbook and toward the printer driver, paper selection, printable margins or a second scaling option in the printer properties.
Correct the range first, then fit it to the intended paper
Fix the settings in a logical order. If you start with scaling before confirming the range, you may create a neat one-page output that still omits required data.
Set the cells that belong in the output
If the whole used sheet should print, clear any obsolete print area:
- Open the affected worksheet.
- Select Page Layout > Print Area > Clear Print Area.
- Open File > Print and check whether all required rows and columns appear.
If only part of the worksheet should be included, select that continuous range and choose Page Layout > Print Area > Set Print Area. Include headings, totals, notes and any blank spacing that has a deliberate role in the report.
When several disconnected selections are added as print areas, Excel prints each area separately. If the content is meant to form one report, use one adjacent rectangular range where possible.
Also confirm that you are printing the intended sheet rather than a temporary cell selection. Choose Print Active Sheets for the current worksheet or Print Entire Workbook when every worksheet belongs in the output.
Match the layout to the shape of the worksheet
Choose page geometry based on the report rather than automatically selecting “fit everything.”
For a table that is wider than it is tall:
- Select Page Layout > Orientation > Landscape.
- Select the intended paper size under Page Layout > Size.
- Set Width to 1 page.
- Leave Height set to Automatic.
- Review every page in File > Print.
This keeps all columns together while allowing the report to extend downward. It is often the clearest way to print an Excel spreadsheet on one page horizontally without compressing hundreds of rows into unreadable text.
For a genuinely small table that must occupy one physical page, set both width and height to one page, then inspect the preview at a realistic size. If the text becomes too small, return the height to Automatic or reduce the print area.
For a report that should remain at a predictable text size, use Adjust to in Page Setup and choose a percentage rather than a fixed page count. The exact useful percentage depends on the table, paper and margins, so confirm the result in preview rather than assuming that a particular value will work for every sheet.
Margins can provide a modest amount of extra room. Try the built-in narrow setting or use custom margins, but keep enough space for the selected printer’s non-printable edges. Headers and footers also consume vertical page space and can affect where rows break.
Review page breaks before creating the PDF
Open View > Page Break Preview after setting the range, orientation, paper and scaling. This view shows exactly where Excel divides the worksheet.
Manual breaks are not effective when the Fit to scaling option controls the number of pages. Excel ignores them in that mode because the fit setting recalculates the page divisions. If a manual break seems to have no effect, decide which control should take priority:
- use Fit to when the required page count is more important;
- use Adjust to when manually chosen breaks and a predictable scale are more important.
Check the complete preview after every significant change. Confirm that the first and last columns are present, totals have not moved to an isolated page, headings remain associated with their data and the text is large enough to read.
When the preview is correct, print the worksheet or save it as a PDF. Open the finished PDF and inspect every page before sharing it. Converting to PDF preserves the paginated output; it does not correct an excluded print area or an unreadably small scale after the fact.
If the PDF contains all the worksheet data but uses the wrong page dimensions, resizing the PDF may adapt those existing pages for another paper size. If columns or rows are absent from the PDF, return to Excel and export it again because resizing cannot restore content that was never included.
Source: Excel print-area behavior from Set or clear a print area on a worksheet, worksheet scaling and fit settings from Scale a worksheet, page-break behavior from Insert, move, or delete page breaks in a worksheet, and print layout, paper, margin and range options from Page Setup and Quick start: Print a worksheet, Microsoft Support. Page last checked 2 October 2026.