Excel Page Break Preview: How to View and Adjust Pages

Excel Page Break Preview shows how a worksheet will be divided into printed pages. In Excel for Microsoft 365 on Windows, open the worksheet and choose View > Page Break Preview; you can then inspect the page boundaries and, where appropriate, drag them to change how the sheet is divided.

What Page Break Preview shows

Page Break Preview is a worksheet view focused on print pagination. It displays the printable pages as separate regions, with page numbers overlaid and break lines marking where one printed page ends and the next begins. This makes it easier to spot a column or a group of rows that would otherwise be split awkwardly across pages.

Excel creates automatic page breaks based on factors such as the paper size, page orientation, margins, scaling, print area, and printer settings. In the preview, automatic breaks are generally shown as dashed blue lines, while manually inserted breaks appear as solid blue lines. The precise layout can change when those print settings change, so the preview is a guide to the current setup rather than a permanent map of the worksheet.

This view does not change cell values or rearrange the worksheet data. It changes how Excel presents the sheet while you work on its printed layout. You can return to the regular grid afterward without losing your edits to page breaks.

How to open and leave the view

In Excel for Microsoft 365 on Windows, select the worksheet tab you want to inspect, then choose View > Page Break Preview on the ribbon. You can also use the view buttons on the status bar near the lower-right corner of the Excel window, if they are visible. Choose Normal on the View tab or click the Normal view button to return to the standard worksheet grid.

Excel for Mac also provides Page Break Preview from the View menu or the view controls, though the ribbon arrangement and status-bar controls can differ slightly by version. Excel for the web has fewer page-layout and printing controls than the desktop application; if Page Break Preview is not available in your web version, open the workbook in desktop Excel to inspect and adjust page breaks. A print preview in the web app may show the print result, but it is not a substitute for the desktop page-break editing view.

If the view buttons are missing, the ribbon path is the dependable option. Selecting the correct worksheet first matters: page breaks belong to a particular sheet, and switching sheets can show a different print layout.

Reading page boundaries and page numbers

In Page Break Preview, the outlined regions represent pages that Excel expects to print. Large page numbers help you see the sequence, especially when a report spans several rows and columns. A vertical boundary indicates a split between columns; a horizontal boundary indicates a split between rows. For example, if a sales table has twelve columns and the page width only accommodates eight at the current scale, Excel may print the remaining four columns on another page.

That arrangement is not necessarily the most readable one. A break between a customer name and its address, or between a table heading and the rows it labels, can make printed output difficult to follow. Preview helps reveal these divisions before printing or saving a PDF. It can also show that a sheet has unexpectedly expanded to many pages because of a formatting mark or stray content far from the main table.

Page numbers in this view are visual guides to sheet pagination. They are not the same as page-number headers or footers. To add printed page numbers, use the header and footer options on the Page Layout tab or the corresponding settings in the Page Setup dialog.

Changing page breaks

You can adjust a break by pointing to its line in Page Break Preview and dragging it to a new row or column boundary. For instance, if a report’s last two columns are being printed on a separate page, moving a vertical break may bring those columns onto the preceding page, provided the resulting scale and paper width allow it. Moving a horizontal break can keep a group of related rows together on one page.

Dragging a boundary changes pagination, not the order of worksheet cells. A manual break can also affect the neighboring page: making one page larger usually makes the next page smaller or shifts where subsequent content begins. If Excel cannot fit the requested layout under the current print settings, it may still create additional pages or apply scaling that makes the text too small.

For more precise control, use the Page Layout tab:

Select a cell at the row or column boundary where you want the split. To insert a horizontal break, select the first row that should start on the next page. To insert a vertical break, select the first column that should start on the next page. Selecting a cell that is both below and to the right of the intended split can insert both types of break.
Choose Page Layout > Breaks > Insert Page Break. Excel inserts the break above and to the left of the selected cell, as applicable.
To remove a particular manual break, select a cell adjacent to it and choose Page Layout > Breaks > Remove Page Break. The exact selection affects which break Excel removes, so inspect the result in Page Break Preview.
To discard manual page breaks on the sheet, choose Page Layout > Breaks > Reset All Page Breaks. This restores automatic pagination; it does not erase worksheet data.

Automatic breaks are recalculated as print settings change. If a line you moved seems to return or shift, check the scaling, paper size, margins, and printer selection before adding more manual breaks.

Settings that affect pagination

Page breaks are connected to several print settings, so adjust those before trying to force every boundary manually. On the Page Layout tab, Orientation changes whether the page is portrait or landscape, while Size selects the paper format. Margins change the space available for content. A wider landscape page or narrower margins can sometimes fit an extra column without making the text smaller.

Scaling is another important factor. Under Page Layout, the Scale to Fit controls can scale a sheet to a chosen number of pages wide or tall. Setting a wide report to fit on one page can prevent horizontal page splits, but it may shrink the text substantially. A common compromise is to set the sheet to one page wide while allowing it to span multiple pages tall. Check the printed size in preview rather than assuming that fewer pages are automatically better.

A print area can limit which cells are included in printed output. Select the intended range and choose Page Layout > Print Area > Set Print Area. If an old print area is restricting or excluding content, choose Page Layout > Print Area > Clear Print Area. Also check for hidden rows or columns if expected information is absent from the printout.

Checking the result before printing

Page Break Preview is useful for arranging page divisions, but check the actual print result too. Choose File > Print to open the print screen and review the preview. Confirm the selected printer, paper size, orientation, page range, and scaling option. A different printer or paper size can cause Excel to recalculate automatic breaks, so a layout that looked right under one setup may change under another.

For a long worksheet, review more than the first page. Use the print preview navigation to inspect later pages and look for blank pages, clipped columns, headings stranded at the bottom of a page, or totals separated from the data they summarize. If the workbook will be shared as a PDF, check the PDF output as well; the recipient’s printer settings will not control that file, but the workbook’s page setup still matters.

Repeating row or column labels can make multi-page reports easier to read. On the Page Layout tab, choose Print Titles to specify rows to repeat at the top or columns to repeat at the left of printed pages. This does not change the page breaks themselves, but it provides context when a table continues across pages.

Common problems and practical fixes

The worksheet suddenly has many pages: Check for an unexpectedly large print area, content or formatting far to the right or below the main table, and scaling set to a high page count. Clear an unwanted print area and review the last used rows and columns.
Text becomes too small: Avoid forcing a very wide sheet onto one page. Try landscape orientation, narrower margins, or setting only the width to one page while letting the sheet use more pages vertically.
Breaks move after changing settings: This is expected when paper size, margins, orientation, scaling, or printer settings change. Finalize those choices first, then make manual adjustments.
A manual break is hard to remove: Select a cell next to the break and use Page Layout > Breaks > Remove Page Break, or use Reset All Page Breaks if you want to start over with automatic pagination.
The printed page differs from the worksheet view: Normal view is designed for editing cells, not showing the final printed page. Check Page Break Preview and File > Print instead.

One frequent misconception is that moving a page-break line makes the printed page larger without any trade-off. It changes where Excel divides the content, but it cannot create more physical paper space. To fit more content, Excel must use a larger page, smaller margins, a smaller print scale, or another page.

Page Break Preview compared with other views

Normal view is best for entering and reviewing worksheet data. It does not emphasize printed page boundaries, although Excel may show page-break lines after a print operation. Page Break Preview is the more direct choice when the main question is where pages divide and whether breaks need adjustment.

Page Layout view shows the sheet in a page-oriented arrangement, including items such as margins and headers or footers. It can be useful when working on the appearance of a page, but Page Break Preview makes the division into multiple printed pages especially clear. File > Print is the final check of the print job, including printer and page-range options. These views serve related but distinct purposes; switching among them is often more useful than trying to do every layout task in one view.

Frequently Asked Questions

How do I turn on Page Break Preview in Excel?
Choose View > Page Break Preview on the ribbon in Excel for Microsoft 365 on Windows. You can also select its view button on the status bar if available.

How do I get out of Page Break Preview?
Choose View > Normal or click the Normal view button near the lower-right corner of the Excel window. Returning to Normal view does not remove manual page breaks.

Why are some page-break lines dashed and others solid?
Dashed lines generally mark automatic breaks that Excel calculates from the current print setup. Solid lines generally indicate manual breaks that someone inserted or adjusted.

How do I remove all page breaks in Excel?
On the worksheet, choose Page Layout > Breaks > Reset All Page Breaks. Excel removes manual breaks and returns to automatic pagination; the worksheet contents remain unchanged.

Can I use Page Break Preview in Excel for the web?
The web version has more limited page-layout controls than desktop Excel, and the desktop Page Break Preview editing workflow may not be available. Open the workbook in Excel for Windows or Mac if you need to inspect and adjust page-break lines directly.

A reliable page-layout workflow

For a clean printout, first decide what content should print and set the print area if needed. Choose the paper size and orientation, adjust margins, and decide whether the report should scale to a particular width. Then open Page Break Preview, inspect the boundaries, and add or move manual breaks only where they improve readability. Finally, review every page in File > Print and verify that the text remains legible.

This sequence reduces repeated adjustments because it deals with the settings that determine automatic pagination before manual breaks are added. It also helps distinguish a genuine page-break issue from a print-area or scaling problem. Once the layout is right, save the workbook so the print setup travels with it.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.