Your Excel data gets cut off when printing, leaving important rows or columns on a separate page. This happens because Excel’s automatic page breaks are placed based on your printer’s paper size and margins. This article explains how to manually adjust these page break lines in Print Preview to control exactly what prints on each page.
Key Takeaways: Adjusting Page Breaks in Excel
- View > Page Break Preview: Switch to a special view where you can see and drag blue dashed lines to define page boundaries.
- File > Print > Page Setup > Margins: Reduce top, bottom, left, or right margins to fit more content on a single page.
- Page Layout > Scale to Fit > Width/Height: Shrink your worksheet to fit a specific number of pages automatically.
Understanding Page Breaks and Print Preview
Excel divides your worksheet into pages for printing. Automatic page breaks appear as faint dashed lines in Normal view. These lines are calculated using your current paper size, orientation, and margin settings. When content like a table or chart is split across a page break, it prints on two separate sheets. Print Preview shows you exactly how these pages will look when printed. The Page Break Preview mode makes these break lines visible and movable, giving you manual control over pagination. This is essential for creating clean, professional printouts where logical data groups stay together.
Steps to Manually Adjust Page Breaks
The most direct method is using Page Break Preview. This mode lets you drag the break lines to new positions.
- Switch to Page Break Preview
Go to the View tab on the ribbon. In the Workbook Views group, click Page Break Preview. Excel may show a welcome dialog; click OK. - Identify the Page Breaks
Your worksheet will display with a white background for the print area and a gray background for non-printing space. Solid blue lines are manual page breaks you set. Dashed blue lines are automatic breaks set by Excel. - Move an Automatic Page Break
Hover your mouse cursor over a dashed blue line. The cursor will change to a double-headed arrow. Click and drag the line to a new row or column boundary. Dragging it left or up moves content onto the previous page. Dragging it right or down moves it to the next page. - Insert a Manual Page Break
Select the cell where you want the new page to begin. For a horizontal break, select a cell in column A. For a vertical break, select a cell in row 1. Go to the Page Layout tab. In the Page Setup group, click Breaks and select Insert Page Break. A solid blue line will appear. - Check Your Layout in Print Preview
Go to File > Print. The preview pane on the right shows your adjusted page layout. Use the page navigation arrows at the bottom to check all pages.
Using Scale to Fit as an Alternative
If moving breaks does not solve the cut-off issue, try scaling the sheet to fit.
- Access Scale to Fit Settings
Go to the Page Layout tab on the ribbon. Find the Scale to Fit group. - Set the Width and Height
Use the Width dropdown to force the sheet to fit on 1 page wide. Use the Height dropdown to fit it on 1 page tall. Selecting 1 page for both will shrink everything onto a single sheet. - Use a Custom Scale Percentage
Alternatively, click the dialog launcher in the Page Setup group. In the Page tab, under Scaling, select Adjust to and enter a percentage like 95% to slightly reduce the printout.
Common Mistakes and Limitations
Page Breaks Won’t Move or Are Solid Blue
If a page break line is solid blue and cannot be dragged, it is a manual break. You can only remove it, not move it. Select a cell immediately below or to the right of the solid blue line. Go to Page Layout > Breaks > Remove Page Break. You can then set a new automatic break or insert a manual break in the correct location.
Data Still Gets Cut Off After Adjusting Breaks
Check your margin settings. Large margins reduce the printable area on the page. Go to File > Print. Click Page Setup at the bottom. In the Margins tab, try reducing the Top, Bottom, Left, and Right values. Also, ensure the header and footer margins are not larger than the top and bottom margins.
Page Break Preview Shows Too Many Pages
This often means your print area is incorrectly set to include entire columns or rows. In Page Break Preview, the print area is bordered by a solid black line. Drag the corners of this black line inward to surround only the cells you need to print. You can also set it formally by selecting your desired range, then going to Page Layout > Print Area > Set Print Area.
Manual Adjustment vs. Scaling: Key Differences
| Item | Manual Page Break Adjustment | Scale to Fit Feature |
|---|---|---|
| Primary Use | Control exact content on each page | Force content to fit a set number of pages |
| Effect on Print Size | Keeps original font and object sizes | Reduces overall size, making text smaller |
| Best For | Reports where formatting must not change | Quickly fitting a wide table onto one page |
| Flexibility | High, allows per-break customization | Low, applies uniform scaling to all content |
| Access Path | View > Page Break Preview | Page Layout > Scale to Fit |
You can now prevent Excel from cutting off your data when printing. Use Page Break Preview to drag break lines and keep related information together. For a quick fix, try the Scale to Fit settings on the Page Layout tab. Remember that you can hold the Alt key while dragging a page break line to snap it precisely to a cell border.