Excel Vertical Page Breaks: How to Add and Adjust Them

An Excel vertical page break marks where printed columns split from one page to the next. In Excel for Microsoft 365 on Windows, select the column immediately to the right of the desired split, then choose Page Layout > Breaks > Insert Page Break; use View > Page Break Preview to inspect or adjust the result.

What a vertical page break means

A vertical page break is a boundary between columns in a worksheet’s printed output. For example, a break before column D means columns A through C print on one page and column D onward begins on another page to the right, assuming the sheet is printed across multiple pages. It does not insert a line into the cells or change the worksheet’s data. It only affects pagination when you print or create a PDF.

Excel also has horizontal page breaks, which divide rows between pages printed below one another. A worksheet can have both kinds at once, creating a grid of printed pages. The wording can be confusing: a vertical break appears as a vertical boundary on the worksheet, but it separates columns and therefore divides the printed page from left to right.

Automatic and manual page breaks

Excel creates automatic page breaks to divide a worksheet according to the paper size, margins, orientation, scaling, and printer settings. These are recalculated when those settings or the printable content change. A manual page break is one you insert or reposition to control where a particular division occurs. In Page Break Preview, automatic breaks are generally shown as dashed blue lines and manual breaks as solid blue lines.

Manual breaks are useful when a column should begin on a fresh printed page even though Excel would otherwise fit it beside the preceding columns. They are not a guarantee that every print setup will preserve the same layout. Changing the paper size, printer, margins, or scaling can change the page boundaries, so review the output under the settings you intend to use.

How to insert a vertical page break

Open the worksheet you want to print and identify the first column that should appear on the next page. To split before column D, for instance, select column D.
Choose Page Layout > Breaks > Insert Page Break.
Choose View > Page Break Preview to check that the boundary falls in the intended place. If necessary, drag the break or adjust the print layout.
Open File > Print to inspect the page previews before printing or saving a PDF.

Selecting the entire column to the right of the desired boundary is the clearest way to request a vertical break without also making a horizontal break. When a single cell is selected, Excel can insert a horizontal break above the cell as well as a vertical break to its left. For example, selecting D20 and inserting a break can affect both the row and column divisions. If you need only a vertical boundary, select column D rather than cell D20.

On Excel for Mac, the page-layout controls are also available from the Page Layout tab, though the ribbon arrangement can vary by release. The same principle applies: select the column to the right of the intended split and use the page-break command. Excel for the web has more limited page-layout controls than the desktop application; if the required break controls are unavailable, open the workbook in the desktop version.

Move, remove, or reset breaks

To move a break visually, choose View > Page Break Preview and drag the blue boundary to the new position. Moving a boundary changes the pagination, not the underlying cells. Dragging an automatic boundary can make the placement manual, so later changes to the sheet may not cause Excel to recalculate that boundary in the same way as an untouched automatic break.

To remove one break, select the column immediately to its right and choose Page Layout > Breaks > Remove Page Break. For example, to remove a break before column D, select column D. You can also use Page Break Preview to select or work with a boundary, but selecting the appropriate column is a dependable way to target a vertical break.

To discard manual breaks and let Excel paginate the sheet again, choose Page Layout > Breaks > Reset All Page Breaks. This resets all manual page breaks on the active worksheet, not just the vertical one you may be investigating. It does not erase cell data. Check other deliberate breaks before using it, since you may need to add them again.

Check the result in Page Break Preview and Print

Page Break Preview gives a more useful view of print divisions than the ordinary worksheet grid. Choose View > Page Break Preview. Blue lines mark page boundaries, and large page numbers can appear over the sheet. A boundary between columns shows where Excel will move the following columns to another printed page. Return to Normal view with View > Normal when you have finished adjusting the layout.

Then inspect File > Print. The preview helps reveal whether a table has been split awkwardly, whether the text is too small, and how many pages the workbook will produce. If the preview differs from Page Break Preview, check the selected printer, paper size, orientation, margins, and scaling. Those settings influence how much of the worksheet fits on each page.

On Windows, Ctrl+P opens the print screen. On Mac, use Command+P. These shortcuts open print settings and preview; they do not insert or move a page break. A PDF is also a useful way to inspect pagination without using paper: choose a PDF destination or the operating system’s PDF option in the print dialog, then review the resulting pages.

How scaling and print settings affect breaks

A vertical page break is only one part of print layout. In Page Layout, the Scale to Fit controls let you set a width, height, or scaling percentage. Setting Width to 1 page, for example, asks Excel to fit the sheet’s columns onto one page across. This can make a manual vertical break ineffective or yield a different result than expected, because fitting all columns across conflicts with splitting them across several pages.

If you want a deliberate split across multiple pages, avoid a setting that forces the entire sheet to one page wide. Use the scaling options deliberately and review the preview. A smaller percentage may fit more columns on each page, while a larger printable area from landscape orientation or narrower margins may reduce the number of pages without shrinking the content as much.

Other useful controls include the print area and repeated titles. A print area restricts which cells are included, so a break outside it may not affect the printed output. Print Titles can repeat chosen rows or columns on each page, which is helpful for tables with headings. Repeated columns do not replace a page break, and their presence can change the available space for the remaining content. Set these options from Page Layout, then verify the full result in Print Preview.

Common vertical page-break problems

The break seems to disappear: Confirm you are viewing the right worksheet and that the print area includes the affected columns. Check scaling and reopen Page Break Preview. A setting that fits all columns to one page wide can override the layout you expected.
The wrong columns move to the next page: A break before column D means D starts the next page; it does not mean D stays with A through C. Select the column on the right side of the boundary when inserting or removing it.
Excel prints more pages than expected: Check both vertical and horizontal breaks, the print area, paper size, margins, orientation, and scaling. A worksheet that spans several columns and many rows can create multiple pages in both directions.
The break changes on another computer: Different printers or paper settings can alter automatic pagination. Confirm the intended printer and page setup before relying on exact page boundaries.
Several page breaks need clearing: Use Reset All Page Breaks on the active sheet only if you are ready to remove its manual breaks. Remember that a workbook can have separate print settings and breaks on different worksheets.

Example: splitting a wide report

Suppose a sales report has columns A through H. Columns A through C contain the region, salesperson, and product, while D through H contain monthly figures. If a page should show the descriptive fields on the left and start the monthly figures on a new page, select column D and insert a vertical page break. In Page Break Preview, confirm the break is before D. The first printed page will contain the columns to the left of the break; the next page begins with D.

That layout may be less readable than printing all eight columns together in landscape orientation, especially if the report is meant to be compared row by row. The break is a pagination control, not a way to repeat the left-side labels automatically on the next page. If readers need those labels beside every set of figures, consider setting print titles to repeat the identifying columns, or redesign the report so each page contains a self-explanatory table. Compare the print preview at the actual paper size before choosing.

Frequently Asked Questions

How do I insert a vertical page break in Excel?
Select the column immediately to the right of the desired split, then choose Page Layout > Breaks > Insert Page Break. Use Page Break Preview to confirm the location.

How do I remove a vertical page break?
Select the column immediately to the right of the break and choose Page Layout > Breaks > Remove Page Break. To remove every manual break on the active sheet, use Reset All Page Breaks instead.

What is the difference between a vertical and horizontal page break?
A vertical break divides columns, sending later columns to a page beside the current one. A horizontal break divides rows, sending later rows to a page below. Both can affect the same worksheet.

Why is Excel ignoring my manual page break?
Check whether the sheet is set to fit all columns to one page wide, whether the break is inside the print area, and whether the selected printer and paper settings changed. Inspect Page Break Preview and File > Print after changing the layout.

Can I add a vertical page break in Excel for the web?
The web version has fewer print-layout controls than Excel for Windows or Mac, and the available options can differ. If you cannot insert or adjust the break in the browser, open the workbook in the desktop application and set the break there.

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.