Excel Page Break View: How to Set Up Printed Pages

Excel Page Break Preview shows where a worksheet will split across printed pages, and lets you adjust those boundaries before printing. In Excel for Microsoft 365 on Windows, open the View tab and choose Page Break Preview; drag a page boundary to change where a page ends.

What Page Break Preview shows

Page Break Preview is a worksheet view focused on pagination: the way a sheet is divided into pages for printing. Blue lines mark page boundaries, and the worksheet area outside the print range may appear gray. Excel may also show large page numbers over the sheet. Those numbers are a guide to page order, not worksheet content, and they do not print.

The view is useful because a worksheet’s visible grid does not automatically correspond to a printed page. A table that looks compact on screen might span several sheets of paper, while a wide report may be divided between columns in an awkward place. Previewing the breaks helps you see those divisions while you can still change them.

Page breaks apply to the active worksheet, not to every sheet in the workbook at once. Each sheet can have its own page setup, print area, and breaks. The view does not edit cell values or rearrange the worksheet; it changes how Excel displays the sheet so you can work with its print layout.

How automatic and manual breaks work

Excel creates automatic page breaks based on the paper size, orientation, margins, scaling, print area, and the amount of content to print. In Page Break Preview, automatic breaks are generally shown as dashed blue lines, while manual breaks are shown as solid blue lines. The distinction matters: Excel can recalculate automatic breaks when the layout changes, while a manual break is an instruction you have added yourself.

A horizontal break separates rows, and a vertical break separates columns. For example, if a report has 80 rows and the first printed page can hold only 45, Excel may put an automatic horizontal break after row 45. If a table is too wide for the page, a vertical break may divide its columns. The exact position depends on the page settings and scaling, so it can change when those settings change.

Manual breaks give you more control over where a page ends. They are helpful when a new section should begin at the top of a page or when you need to keep a particular group of rows together. They are not a guarantee that every other page will have a desired shape: a break can create an extra page, and scaling or later edits can affect the overall result.

Open the view and inspect the sheet

Select the worksheet you plan to print.
Choose View > Page Break Preview.
Look at the blue boundaries and the page numbers to understand how Excel has divided the printable area.
Drag a boundary if you want to reposition it. You can also use the page-break commands on the Page Layout tab.
When you are finished, return to View > Normal to work with the usual worksheet grid.

Before adjusting a line, identify whether it is horizontal or vertical and which rows or columns you want on each page. A horizontal line controls the rows above and below it; a vertical line controls the columns on either side. If the page numbers or boundaries are hard to read, use the zoom controls at the bottom of the Excel window. Zoom changes the on-screen view, not the printed scale.

On Excel for Mac, use the View menu or View controls to switch to Page Break Preview; ribbon placement and keyboard key tips differ from Windows. Excel for the web has fewer print-layout editing controls than the desktop app, so use desktop Excel when you need to set or adjust page breaks precisely. Check the web app’s print preview for a quick review, but do not assume it exposes every desktop page-break command.

Move, insert, and remove page breaks

In Page Break Preview, dragging a blue line is the most direct way to reposition a break. Move a horizontal line to include more or fewer rows on the preceding page, or move a vertical line to include more or fewer columns. Watch the page numbers as you drag: shifting one break can change how the rest of the sheet is divided.

You can also insert a break through Page Layout > Breaks > Insert Page Break. To create a horizontal break, select the row below the place where the new page should begin. To create a vertical break, select the column to the right of the intended split. If you select a cell rather than a whole row or column, Excel can add breaks above and to the left of that cell. Review the result in Page Break Preview because the selection determines which boundaries are inserted.

To remove a manual break, select the row below a horizontal break or the column to the right of a vertical break, then choose Page Layout > Breaks > Remove Page Break. If the selection is a cell at the intersection of breaks, Excel can remove both relevant breaks. To clear manual breaks across the sheet, choose Page Layout > Breaks > Reset All Page Breaks. Resetting removes your manual break choices; Excel then lays out the sheet using automatic breaks.

Fit page breaks to the printed page

Page breaks are only one part of print layout. If a sheet is too wide or long, scaling can shrink it so more content fits on each page. On the Page Layout tab, the Scale to Fit controls let you set a width, height, or scale. For example, setting the width to one page can keep all columns together, but it may make text much smaller. Setting both width and height to one page can shrink a long report dramatically.

Use scaling deliberately. If readable text is the priority, allowing a report to span more pages is often better than forcing the entire sheet onto one page. You can also change orientation from portrait to landscape, adjust margins, or choose a larger paper size if the printer supports it. These choices alter the available printable area, so inspect Page Break Preview again after changing them.

For a wide data table, a practical approach is to fit the width to one page while leaving the height automatic. That keeps columns together but lets rows continue onto additional pages. For a long report with section breaks, leave scaling at a readable size and place manual horizontal breaks at sensible section boundaries. There is no single setting that suits every worksheet; page count, legibility, and how the data should be read all matter.

Print areas, repeating headings, and print preview

A print area tells Excel which part of a worksheet to print. If blank or irrelevant cells are creating extra pages, select the required range and choose Page Layout > Print Area > Set Print Area. The active print area affects what Page Break Preview focuses on and what is sent to print. To remove that restriction, choose Page Layout > Print Area > Clear Print Area.

For a multi-page list, repeating the header row can make later pages easier to understand. Choose Page Layout > Print Titles and set rows to repeat at the top or columns to repeat at the left. This is different from a page break: a repeated heading appears on each printed page, while a break determines where the content is divided. If the title rows seem to take up valuable space, remember that they are included on each page.

Page Break Preview is a layout aid, not a substitute for checking the final output. Open File > Print to inspect print preview, choose a printer, and review settings such as paper size and scaling. The selected printer and its printable margins can affect the result. If the preview differs from what you expected, confirm the print area, orientation, paper size, scaling, and page-break positions before printing.

Common problems and what to check

A page break seems to move by itself: It may be an automatic break. Changes to column widths, row heights, margins, paper size, or scaling can make Excel recalculate its position. Manual breaks are more stable, but other layout changes can still affect the overall pagination.
The printed text is tiny: Check whether the sheet is set to fit both width and height on one page. Try fitting only the width, changing orientation, or allowing more pages instead of shrinking everything.
Extra blank pages appear: Check for a print area that includes unused cells, stray formatting far below or to the right of the data, or a manual break that forces a nearly empty page. Inspect the print preview after correcting the cause.
A manual break does not seem to work: Confirm that you selected the row below or column to the right of the intended boundary. Then check whether scaling or the print area changes how the sheet is paginated.
Lines are visible in the view but not on paper: Page-break guides are not printed. They indicate page divisions; they are not borders added to cells.

One common misconception is that changing to Page Break Preview changes the worksheet or inserts breaks automatically. Switching views only changes the display. Excel already has automatic page breaks for printing, and you create manual ones only by dragging a boundary or using a break command. Similarly, gridlines and cell borders are separate from page-break guides: choose print settings for gridlines or apply cell borders if you need lines to appear on paper.

Page Break Preview compared with other views

Normal is the usual view for entering data, editing formulas, and working with the grid. It does not emphasize printed page boundaries, although Excel can show page-break indicators after print settings have been used. Page Break Preview makes page divisions the focus and is best for deciding where pages split.

Page Layout view displays a page-oriented view of the worksheet, including features such as margins and headers or footers. It can be useful when you want to see the sheet in a paper-like arrangement while editing. Page Break Preview is generally clearer for moving page boundaries across a large worksheet. Neither view changes the underlying data; both are ways to inspect or edit its presentation.

Use File > Print when you need to inspect the final print output and printer settings. A useful sequence is to arrange the worksheet in Normal view, set its print area and titles, adjust page divisions in Page Break Preview, then confirm the result in print preview. This separates data editing from pagination decisions and makes it easier to identify which setting caused an unexpected page.

Frequently Asked Questions

How do I turn on Page Break Preview in Excel?
Choose View > Page Break Preview on the Windows desktop version of Excel. To return to the regular grid, choose View > Normal.

How do I remove a page break in Excel?
Select the row below a horizontal manual break or the column to the right of a vertical manual break, then choose Page Layout > Breaks > Remove Page Break. Choose Reset All Page Breaks to clear all manual breaks on the active sheet.

Why are there dashed and solid lines in Page Break Preview?
Dashed lines generally indicate automatic page breaks calculated by Excel; solid lines generally indicate manual breaks. Automatic boundaries can move when print settings or worksheet dimensions change.

Do page-break lines print on the worksheet?
No. The blue guides and large page numbers in Page Break Preview are screen indicators. They do not print as cell borders or page labels.

Why does Excel print my worksheet on multiple pages?
The content may exceed the printable area defined by paper size, orientation, margins, scaling, and the print area. Review File > Print, then adjust those settings or move breaks if needed. Fitting a sheet onto fewer pages can reduce text size.

Can I use Page Break Preview in Excel for the web?
The web version supports basic workbook viewing and printing, but its print-layout controls can differ from desktop Excel. For precise manual page-break editing, open the workbook in the Windows or Mac desktop app and use its Page Break Preview.

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.