Remove Page Break Numbers in Excel

To remove the large page-break numbers in Excel, switch from Page Break Preview to View > Normal. The numbers are only an on-screen guide; they do not print. To also hide dashed page-break lines in Normal view, turn off Show page breaks in Excel Options. If you want to change the actual print layout, remove or reset the worksheet’s page breaks separately.

What You’ll Need

Microsoft Excel for Microsoft 365 on Windows, with the workbook open.
The worksheet showing the numbers or lines. Page-break display settings apply to the active worksheet, so identify the affected sheet before changing its settings.
If you plan to change the print layout, use Print Preview afterward to check that the result still fits your needs.

Step-by-Step

Open the worksheet with the page numbers. Click its sheet tab at the bottom of Excel. If the workbook has several sheets, check that you have selected the one displaying labels such as Page 1 or Page 2. The labels usually mean that the sheet is in Page Break Preview, not that numbers have been added to cells. You can click a blank area of the grid; the page labels remain visible until you change the view.
Switch to Normal view. On the ribbon, choose View > Normal. You can also click the Normal view button near the lower-right corner of the Excel window, beside the zoom controls. The large page numbers should disappear straight away. Normal view shows the worksheet in its usual grid layout; it does not remove rows, columns, data, or print settings. If you want to see how the sheet will print later, you can return to Page Break Preview or open Print Preview.
Hide dashed page-break lines, if they remain. In Excel for Windows, choose File > Options > Advanced. Scroll to Display options for this worksheet, and confirm the correct worksheet is selected in the dropdown if one is shown. Clear the Show page breaks checkbox, then click OK. This hides the page-break lines on that sheet while it is in Normal view. It does not alter the print area or delete manual breaks, and the option is specific to a worksheet.
Decide whether you need to change the printed page layout. If your only concern is the oversized numbers, stop after switching to Normal view. If a printout is splitting at an unwanted point, or if you want to remove a manually inserted break, use the page-break commands instead. Changing breaks affects pagination when printing or exporting to PDF; it is not necessary just to tidy the screen. A page number shown over the grid is not a page number printed in a cell.
Remove one manual page break when appropriate. Choose View > Page Break Preview to see the break positions clearly. For a horizontal break, select a cell immediately below the break. For a vertical break, select a cell immediately to its right. Then choose Page Layout > Breaks > Remove Page Break. Excel removes the manual break associated with that position. If the command is unavailable or the line does not change, the break may be automatic rather than manual; Excel recalculates automatic breaks from the paper size, margins, scaling, and content.
Reset all manual breaks on the worksheet if needed. If you want to clear the manually inserted breaks throughout the active sheet, choose Page Layout > Breaks > Reset All Page Breaks. This is broader than removing one break: it removes the manual break layout for that worksheet, while Excel continues to add automatic breaks based on the print setup. Review the result before printing, especially if the sheet was deliberately divided into several pages. Resetting breaks is not the same as hiding the page-break display.
Check the result in Normal view and Print Preview. Choose View > Normal to confirm that the large labels are gone. If you changed page breaks, choose File > Print and inspect the preview pages before printing. Look for split tables, a small final page, or columns pushed onto an extra sheet of paper. Close the print screen without printing if you are only checking. If the page layout is not right, adjust the relevant break or print settings rather than switching views repeatedly.

Common Mistakes

Deleting content to make the number disappear. The large labels are view overlays, not cell values. Selecting a cell or pressing Delete will not remove them and could erase worksheet data. Switch to Normal view instead.
Assuming Normal view deletes page breaks. Normal view hides the Page 1 and Page 2 labels, but the worksheet can retain its manual and automatic print breaks. That is usually helpful: the print layout remains available without covering the grid with labels.
Resetting every break for a cosmetic issue. Reset All Page Breaks changes the print layout across the active sheet. Use it only if you intend to clear manual breaks, not just to remove the large on-screen numbers.
Expecting automatic breaks to be removable. Excel creates automatic breaks to divide the printed sheet according to its settings. Remove Page Break is for manual breaks. To move an automatic break, change the print setup or insert a manual break where you want it.
Changing the wrong worksheet’s display option. The Show page breaks setting is associated with a worksheet. If the dashed lines remain on another tab, select that sheet and check its own display setting.

Tips

Use the view buttons for a quick fix. If all you need is a cleaner editing screen, View > Normal is faster and safer than changing print settings. Page Break Preview is useful when arranging pages, but it can make an ordinary worksheet feel cluttered.
Remember what the different marks mean. In Page Break Preview, large page labels are overlays, and break lines show page boundaries. In Normal view, dashed lines may remain after you have printed or opened Print Preview. The labels, the visible lines, and the actual printed pagination are related but distinct things.
Check the active sheet before using a break command. Remove Page Break and Reset All Page Breaks affect the worksheet you are working on. For a workbook with multiple print-ready sheets, review each one deliberately instead of assuming one command changes every sheet.
Keep a copy before a major layout cleanup. A view change is easy to reverse, but resetting many manual breaks can take time to reconstruct. If the existing layout is important, save a copy of the workbook before clearing breaks.
On a Mac, use the view control first. In Excel for Mac, choose View > Normal to hide the large labels. If you also need to hide break lines, look under Excel > Preferences > View for the page-break display option; wording and placement can vary by release. Excel for the web also offers worksheet views, but its available display and page-setup controls can differ from the Windows desktop app.

Troubleshooting

The numbers are still visible after choosing Normal. Confirm that the active sheet actually changed views. Click View > Normal again or use the Normal button near the zoom control. If the labels remain, select another sheet and return to the affected tab, then check the view. You may be looking at a different worksheet or at a page number printed in a cell, header, or footer rather than the Page Break Preview overlay.

The numbers disappeared, but dashed lines remain. This is expected in some workbooks. Turn off Show page breaks under File > Options > Advanced for the affected worksheet. If you cannot find the option, scroll farther down the Advanced settings to Display options for this worksheet. Make sure the dropdown names the sheet you mean to change.

The break line will not go away. First determine whether it is manual or automatic. In Page Break Preview, manual breaks can be adjusted or removed, while automatic breaks are calculated by Excel. For an automatic break, check Page Layout > Scale to Fit, paper size, orientation, margins, and the print area. For example, a sheet scaled to fit one page wide may place horizontal breaks differently from an unscaled sheet. Change one setting at a time and recheck Print Preview.

The printed pages changed unexpectedly. If you used Reset All Page Breaks, Excel may have returned the sheet to its automatic pagination. Undo immediately with Ctrl+Z if the command was just applied and remains undoable. If you have made other changes since then, restore a saved copy or add the needed manual breaks again. Before printing, use File > Print to review every page; a normal-looking grid does not guarantee the paper layout is unchanged.

The settings are not available in the web or Mac version. Use the desktop Windows app for the specific Advanced display setting described above if your version does not expose it. In Excel for the web, switch to Normal view to remove the large labels, then open the workbook in the desktop app if you need more control over page-break display or print layout. On Mac, menu names can vary between releases, so use the View menu to change the worksheet view and Excel Preferences to look for page-break display controls.

Frequently Asked Questions

Do the large page-break numbers print?
No. The oversized Page 1 or Page 2 labels are part of Page Break Preview and do not print on the worksheet. Use File > Print to see the actual output.

How do I remove the page-break numbers without changing the print layout?
Choose View > Normal. This changes the screen view but keeps the existing page breaks and print setup intact.

Why do I still see dotted lines in Normal view?
Excel may continue to show page-break lines after printing or previewing. On Windows, turn off Show page breaks in File > Options > Advanced for the relevant worksheet.

Can I remove only one page break?
Yes, if it is manual. In Page Break Preview, select a cell just below a horizontal break or just to the right of a vertical break, then choose Page Layout > Breaks > Remove Page Break. Automatic breaks need print-setting changes instead.

What does Reset All Page Breaks do?
It clears manual page breaks on the active worksheet. Excel then determines automatic breaks from the sheet’s print settings. It does not simply hide the large page labels.

Will changing the view affect other people who open the workbook?
The view and display behavior can be saved with a workbook and may appear differently depending on the app or worksheet settings. If the workbook is shared, check the result after saving and reopening it, and tell collaborators if you changed the actual print layout rather than only your viewing mode.

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.