Excel: Insert a Page Break After Every Row Manually

Yes. For a few breaks, select the row immediately below the place you want to split, then choose Page Layout > Breaks > Insert Page Break. To insert a break after every row in a range, a short VBA macro is more practical; the steps and a ready-to-use example are below.

How Excel page breaks work

A page break controls where Excel starts a new printed page; it does not insert a blank worksheet row or change the data. Excel creates automatic breaks based on the paper size, page orientation, margins, print area, row heights, column widths, and scaling settings. A manual break tells Excel to start a new page at a chosen row, subject to the layout settings used for printing.

For example, if your report has records in rows 2 through 31 and you want one record per page, you need a horizontal break before each record row after the first. That means breaks before rows 3 through 31: row 2 begins the first page, and each following row begins another. The header row, if you have one, needs separate consideration because it may take up space on every page.

Page breaks affect printed output and print previews, not the normal worksheet grid. You can inspect them in View > Page Break Preview. This is useful for checking whether the breaks you added coincide with the rows you intended.

Insert a break manually after one row

Use the ribbon when you need only a few page breaks. To put a break after row 4, for example, insert it before row 5:

Click the row number for row 5 to select the entire row.
Choose Page Layout > Breaks > Insert Page Break.
Repeat at each row where the next printed page should begin.
Open File > Print to check the result in Print Preview.

Selecting the whole row matters. If you select a single cell instead, Excel can place a vertical break to the left of that cell as well as a horizontal break above it. A row selection makes the intended horizontal split clearer. On Excel for Mac, use the Page Layout > Breaks > Insert Page Break command when it is available in the ribbon; the exact ribbon arrangement can differ slightly by release. Excel for the web has more limited page-break controls, so use the desktop app to add or edit manual breaks.

Add a break after every row with VBA

For a long list, adding breaks one at a time is tedious. This macro adds a horizontal page break before every row after the first row in the selected, contiguous range. Select the data rows first, then run it. For instance, selecting rows 2 through 31 adds breaks before rows 3 through 31, so the first selected row starts the first page.

Before running any macro, save a copy of the workbook. Macros cannot be undone with Ctrl+Z, and this one resets existing page breaks on the selected worksheet before adding its new set. Save the workbook as an Excel Macro-Enabled Workbook (.xlsm) if you need to keep the macro.

Sub InsertBreakAfterEachSelectedRow()
    Dim target As Range
    Dim ws As Worksheet
    Dim firstRow As Long
    Dim lastRow As Long
    Dim r As Long

    ' Use one contiguous selection on the active worksheet.
    If TypeName(Selection) <> "Range" Then Exit Sub
    Set target = Selection
    Set ws = target.Worksheet

    firstRow = target.Row
    lastRow = target.Row + target.Rows.Count - 1

    ' This removes existing manual breaks on the worksheet.
    ws.ResetAllPageBreaks

    ' Start each selected row after the first on a new page.
    For r = firstRow + 1 To lastRow
        ws.HPageBreaks.Add Before:=ws.Rows(r)
    Next r
End Sub

To use it in Excel for Microsoft 365 on Windows, press Alt+F11 to open the Visual Basic Editor, choose Insert > Module, paste the code into the module, and return to the workbook. Select the range and run the macro from the editor with the cursor inside the procedure, or use Developer > Macros to select and run it. If the Developer tab is hidden, enable it through File > Options > Customize Ribbon. On a Mac, the Visual Basic Editor shortcut can depend on keyboard settings; open it from the Tools > Macro > Visual Basic Editor menu if needed. Macro security settings may also require you to allow the macro for this workbook.

Check the breaks and the printed pages

After inserting breaks, choose View > Page Break Preview. Excel displays page boundaries as lines. You can use this view to confirm that each intended row starts a new page and to spot unexpected extra pages caused by wide columns. Return to View > Normal when you are finished.

Then check File > Print, where the preview reflects the selected printer, paper size, orientation, margins, and scaling. A worksheet row can be on its own horizontal page but still span multiple pages from left to right if the columns are too wide. If that happens, consider landscape orientation, narrower margins, or fitting the sheet to one page wide. Use scaling carefully: fitting a sheet to a specified page height can override manual page breaks, so avoid a setting such as fitting all rows on one page when the goal is one row per page.

Also check the print area. If it excludes the rows you selected, those rows will not appear in the output. Set or adjust it with Page Layout > Print Area > Set Print Area. A useful sequence is to establish the print area and paper layout first, add breaks second, and inspect the final print preview last.

Decide whether one row per page is practical

A break after each row is useful when each record needs a separate printed sheet—for example, individual order slips, inspection records, or client summaries. It can be inefficient for ordinary tabular reports. A list of 30 data rows becomes at least 30 pages, and repeated column headings or a large header can make the usable space on each page small.

Check these factors before committing to that layout:

Row height: a very tall row may itself need more than one printed page or be scaled down.
Column width: a row may spill across multiple pages horizontally unless the width fits.
Headers: repeat column labels with Page Layout > Print Titles, then set the rows to repeat at the top. This makes each page easier to interpret, but the repeated header uses printable space.
Page count: many manual breaks make a large print job and can be cumbersome to review or distribute.
Hidden or filtered rows: breaks follow worksheet row positions. If rows are hidden or filtered out, the visible printed records may not correspond to one page per visible record.

Excel may adjust page-break positions when the printer, paper size, scaling, or print area changes. Recheck the preview after changing those settings rather than assuming a break will produce the same output on every printer.

Alternatives to manual page breaks

If the real goal is a readable report rather than exactly one record per sheet, try a layout that lets Excel paginate the data naturally. For a wide table, set it to one page wide and allow it to span as many pages tall as needed; this keeps columns together without shrinking every row onto one page. In the print settings, choose a scaling option that fits all columns on one page, then review the font size in the preview.

For a repeated form or a document that must have a consistent page per record, consider creating a report template or using a mail merge or reporting workflow instead of printing a raw data table. If the records are already separate sheets, you can print selected sheets together, but that approach is different from adding a break after every row on one worksheet. These alternatives avoid excessive page breaks when the source list grows or changes.

Common problems and fixes

The break appears in the wrong place: insert it by selecting the row below the intended split. In Page Break Preview, check whether Excel moved the boundary after a layout change.
The output is still one page: review scaling in Page Setup or the print options. A fit-to-height setting can take precedence over the manual breaks.
Each row prints across two or more pages: reduce the number of columns in the print area, change orientation, or fit the width to one page.
The macro removes other breaks: that is expected because ResetAllPageBreaks clears existing manual breaks on the worksheet. Save a copy first, and use the macro only when rebuilding the break pattern is intended.
The macro does not match visible records: it works with worksheet row numbers, not just currently visible records. Review filters and hidden rows before running it.

Excel also has a limit on how many manual page breaks a worksheet can hold. If the list is extremely large, one break per row may not be feasible; use a report design or export process that produces separate records instead. If the macro reports an error, first test it on a small copied range and confirm that the selected range is contiguous.

Frequently Asked Questions

Can Excel automatically insert a page break after every row?
There is no standard print setting that automatically creates a break after every data row. Insert breaks manually for a small number of rows, or use VBA to add them to a selected range.

How do I put a page break after row 5?
Select row 6, then choose Page Layout > Breaks > Insert Page Break. The new page starts at row 6, leaving row 5 at the end of the preceding page.

Will a page break change my worksheet or split my data?
No. A page break changes where printed pages begin; it does not move, divide, or delete the worksheet data.

Why are my manual page breaks ignored?
Check whether scaling is set to fit the sheet to a particular number of pages tall. Fit-to-page scaling can take precedence over manual breaks. Review the scaling and page-break settings in the desktop app, then check Print Preview again.

Can I use this method in Excel for the web?
For reliable insertion and editing of manual page breaks, open the workbook in the Excel desktop app. The web version has more limited print-layout controls and may not offer the same break commands.

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.