How to Insert a Vertical Page Break in Excel for Printing

To insert a vertical page break in Excel for Microsoft 365 on Windows, select the entire column immediately to the right of where you want the printed page to end, then choose Page Layout > Breaks > Insert Page Break. Check the result in View > Page Break Preview. A vertical break controls where Excel splits a worksheet from left to right when printing; it does not change how the sheet looks in Normal view.

Before adding one, decide which columns should appear together on each printed page. Page breaks work alongside paper size, margins, print area, and scaling, so preview the sheet after making changes. The steps below are for the desktop Windows version of Excel.

What You’ll Need

An Excel workbook open in the desktop application, with the worksheet you intend to print.
A rough plan for the column where each printed page should begin. For example, if columns A through C should print on the first page and column D should begin the next page, the break belongs before column D.
Access to the Page Layout and View tabs. You do not need a formula, add-in, or special permission to insert a page break.

If you are using Excel for the web, open the workbook in the desktop app to insert a manual page break. The web version does not provide the same controls for inserting manual breaks.

Step-by-Step

Open the right worksheet and check its print layout. Select the worksheet tab containing the data, then open Page Layout. Look at the Size, Orientation, and Margins settings. These affect how much content fits across a page. If the sheet is wide, Landscape orientation or narrower margins may make the printed pages easier to read. You can change these settings later, but knowing them first helps you choose a useful break location.
Identify the column that should start the next page. Suppose the first printed page should contain columns A, B, and C, while column D and the columns after it should start on another page. In that case, select column D. The vertical break is placed at the left edge of the selected column: it separates the columns to its left from the selected column and those to its right. Pick a boundary that keeps related information together, such as an ID column beside its description, rather than splitting a logical group unnecessarily.
Select the whole column, not just a cell, for a vertical-only break. Click the column letter at the top of the worksheet, such as D, so the entire column is selected. This distinction matters: selecting a single cell and inserting a break can add both a horizontal break above the cell and a vertical break to its left. Selecting the column is the straightforward way to request a vertical break without unintentionally adding a horizontal one. You can still use a cell selection when you deliberately want breaks in both directions.
Insert the break. With the target column selected, go to Page Layout > Breaks > Insert Page Break. Excel adds a manual vertical page break to the worksheet. The break is a printing instruction; it will not insert a blank column, move cells, or alter the data. If you do not see a clear change in the current worksheet view, that is normal. Switch to Page Break Preview to inspect it.
Review the split in Page Break Preview. Choose View > Page Break Preview. Excel displays the worksheet as numbered print pages, with page boundaries shown as lines. A solid blue line generally marks a manual page break, while dashed lines indicate automatic page breaks. Look for the vertical line at the intended boundary and check that the page numbers and columns are arranged as expected. If the break is in the wrong place, return to the worksheet and insert it at the correct column, or adjust it directly in this view.
Adjust the break if needed, then verify the printout. In Page Break Preview, you can drag a page-break line to a different column boundary. Dragging a break changes the print division, so check that no related columns are separated and that each page remains readable. To see the final layout more closely, open File > Print and inspect the print preview. Confirm the selected printer, paper size, orientation, and scaling before printing. Choose View > Normal when you want to leave Page Break Preview and return to the standard worksheet view.

On Excel for Mac, the same basic approach applies: select the column to the right of the desired split and use Page Layout > Breaks > Insert Page Break, then review the result in Page Break Preview. Ribbon labels or their placement can vary slightly by Mac version. If the workbook is open in Excel for the web, use the option to open it in the desktop app for manual page-break controls.

Common Mistakes

Selecting a cell when you only want a vertical break. A selected cell can result in a break above and to the left of that cell. If an unwanted horizontal split appears, undo the change immediately with Ctrl+Z on Windows, select the full target column, and insert the break again. On Mac, use Command+Z.
Selecting the column on the wrong side of the boundary. To make column D the first column on the next page, select D, not C. Excel places the vertical division at the left edge of the selected column.
Assuming a break guarantees one column group per page. A manual break sets a boundary, but the remaining columns may still span multiple pages depending on sheet width, paper size, margins, and scaling. Always inspect the numbered pages in preview.
Confusing a page break with a print area. A print area determines which cells are included in printing; a page break divides that printable content into pages. Setting a break does not automatically exclude unwanted rows or columns.
Leaving a break in place after changing the layout. If you later alter the paper size, scaling, or data width, the old break may no longer make sense. Review Page Break Preview again after substantial layout changes.

Tips

Choose boundaries that preserve context. If each row contains a product code, name, and price, avoid a layout where those fields are printed on separate pages. Consider repeating important identifier columns on each page if readers need them to interpret the data. In Excel, look under Page Layout > Print Titles for options to repeat rows or columns.
Use scaling deliberately. In Page Layout, the Scale to Fit settings can shrink content to fit a specified number of pages. Setting a sheet to fit one page wide can override the practical effect of your intended vertical divisions or make text too small. If manual page breaks matter, check the scaling options and use print preview to judge the size and page count.
Keep a mental map of automatic and manual boundaries. Excel creates automatic breaks based on available space. Manual breaks take priority for the layout you set, but other page divisions may remain automatic. In Page Break Preview, the line styles and page numbers help you see where the sheet will divide.
Remove breaks if you want Excel to recalculate the layout. Use Page Layout > Breaks > Reset All Page Breaks to clear manual page breaks on the active worksheet and let Excel lay out pages automatically. This affects the worksheet’s breaks, so check the preview again before printing.
Consider using landscape for wide tables. A vertical break may be unnecessary if a modest orientation change lets the whole table fit across a page at a readable scale. Compare the preview before adding multiple breaks, especially when the worksheet has only a few extra columns.

Troubleshooting

The Breaks command is unavailable or Insert Page Break is disabled. Check that the workbook is open in the desktop Excel application and that you have selected a worksheet column or cell. If the sheet is protected, protection may prevent layout changes; review Review > Unprotect Sheet if you are authorized to do so. Excel for the web may not offer manual page-break insertion, so open the file in desktop Excel.

The break appears in the wrong place. Return to Page Break Preview and inspect the boundary. Remember that selecting column D places the vertical break before D. If the wrong break was just added, use Undo; otherwise, select the correct column and insert the break there. You can also drag the blue boundary in Page Break Preview, then recheck the page numbering.

The printed pages do not match the preview you expected. Check the print area, paper size, orientation, margins, and scaling in Page Layout and in File > Print. A different printer or paper size can change the available printable space and therefore alter automatic divisions. Also make sure you are printing the intended worksheet or selected range, rather than a different sheet or workbook selection.

The page-break line is hard to see. Switch to View > Page Break Preview, where page boundaries and page numbers are easier to inspect. If the worksheet is very large, zoom out or scroll to the relevant columns. Return to Normal view when finished; the break remains saved with the worksheet.

Pages are too small or too numerous. Review Scale to Fit rather than adding more breaks automatically. Fitting many columns onto one page can make text unreadable, while leaving scaling at its default may create additional pages. Try a suitable paper orientation, adjust margins, or divide the table at meaningful column boundaries, and compare the print preview after each change.

Frequently Asked Questions

What does a vertical page break do in Excel?
It marks a left-to-right boundary between columns for printing. Columns on one side print on one page, and columns beyond the break continue on another page. It does not change the worksheet data or insert a visible divider in Normal view.

Which column should I select to break after column C?
Select the whole of column D and choose Page Layout > Breaks > Insert Page Break. The break is placed before D, so columns A through C are on the preceding side of that boundary.

Can I add a vertical break without adding a horizontal one?
Yes. Select the column letter to select the entire column, then insert the break. Selecting a single cell may add a vertical and a horizontal break, so use a whole-column selection when you want only the vertical division.

How do I remove a vertical page break?
Select the column immediately to the right of the break, then choose Page Layout > Breaks > Remove Page Break. To remove all manual breaks on the active worksheet instead, choose Page Layout > Breaks > Reset All Page Breaks. Verify the result in Page Break Preview.

Will a vertical page break show on the worksheet?
It is most visible in Page Break Preview and print preview. In Normal view, it may not appear as a prominent line, but it remains part of the worksheet’s print layout.

Can I insert a vertical page break in Excel for the web?
Manual page-break insertion is not available there in the same way as in desktop Excel. Open the workbook in the desktop application, insert and review the break, then save the workbook so the layout change is retained.

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.