Excel Page Break Preview Without Page Numbers: What to Know

In Excel for Microsoft 365 on Windows, you cannot hide the large page-number labels while staying in Page Break Preview: they are part of that view. Switch to View > Normal to remove them from the worksheet display; the labels are only a screen guide and do not print. If you mean page numbers on the printed pages, those are a separate header or footer setting and can be removed.

What Page Break Preview Is Showing

Page Break Preview is a worksheet view for checking how a sheet will be divided into printed pages. Excel shades the area outside the print area and draws blue lines to show the boundaries between pages. It also places a large gray label, such as “Page 1,” over each printable page. That label can obscure cells while you edit, but it is not text in a cell, an object, or a print element.

The labels help you see the page sequence and how the worksheet is divided. For example, a wide table might span pages 1 and 2 horizontally, while rows continue onto pages 3 and 4. The page labels make those divisions easier to interpret than a set of boundary lines alone. Excel does not provide a separate checkbox to turn off the labels while leaving Page Break Preview active.

To open the view in desktop Excel for Windows, choose View > Workbook Views > Page Break Preview. The same area of the View tab also provides Normal and Page Layout views. On a Mac, use the View tab’s workbook-view controls; names or ribbon placement can vary slightly by release. Excel for the web has a different feature set and may not offer the same page-break controls as desktop Excel.

How to Hide the Labels Quickly

If the page numbers are covering the cells you need to read or edit, return to Normal view. Choose View > Normal. The gray labels and page-break display disappear, and the worksheet returns to its regular grid. This changes only how the sheet is shown; it does not remove page breaks, alter the cell data, or change a saved print setting.

Normal view is usually the best choice for ordinary data entry, formula editing, and formatting. You can return to Page Break Preview whenever you need to inspect the print layout. Excel remembers the worksheet’s page setup independently of which view you use, so switching views is a reversible display change rather than a reset.

If you want a page-oriented view but find the Page Break Preview labels distracting, try View > Page Layout. Page Layout view presents the sheet in page-shaped sections and can show margins and header or footer areas. It is not identical to Page Break Preview: it does not use the same large “Page 1” overlay and offers a different editing experience. You can also use File > Print to inspect the print preview without editing under the overlay.

Can You Keep Page Break Preview but Remove Page Numbers?

No separate setting in Excel for Microsoft 365 on Windows removes the gray page labels while retaining Page Break Preview. Zooming in or out can change how much of the sheet fits on screen, but it does not switch off the labels. Nor does clearing headers and footers remove them: the preview labels are generated by the view, not by the worksheet’s print header or footer.

That distinction matters if you are following instructions that say to “remove page numbers.” First decide which numbers are the problem. If they are oversized, translucent labels across the grid, switch views. If they are small numbers at the top or bottom of a printed page, edit the header or footer. Treating the two as the same feature can lead to changing print settings without solving the visual distraction.

A practical workflow is to use Page Break Preview briefly to adjust page boundaries, switch to Normal for editing, and check the final result through File > Print. If you need to keep the workbook open in a page-focused view, Page Layout is another option, but it will not reproduce every Page Break Preview control.

Remove Page Numbers from the Printed Worksheet

Actual printed page numbers are usually inserted in a header or footer. To remove them in desktop Excel, open Insert > Header & Footer. Excel changes to a page-layout editing view. Click the header or footer section that contains the number, select its page-number field or text, and delete it. Check both the header and footer because a number may have been placed in either location.

You can also open the Page Setup dialog from the Page Layout tab by clicking the small dialog launcher in the Page Setup group, then use the Header/Footer tab. Choose (none) for a built-in header or footer that contains a page number. If the number is part of a custom header or footer, edit the custom text and remove the page field. Excel’s page-number code may appear as &[Page] or &P, depending on how it was inserted.

Headers and footers can be set for the whole sheet, and options may allow different first-page or odd-and-even-page content. If a number remains on some pages after you remove one, check those variations as well. Use File > Print to verify what will appear on paper or in a PDF; the Page Break Preview watermark is not a reliable test of header and footer content.

Adjust Page Breaks Without Confusing the Labels

In Page Break Preview, blue lines show where Excel will divide the worksheet. A solid blue line generally indicates a manual page break, while a dashed blue line indicates an automatic break calculated from the current page setup. You can drag a break line to change where a page ends. When you move a boundary, the page labels update to reflect the revised layout.

For example, if a report’s total row is stranded on a page by itself, you might move a horizontal break so the row stays with the preceding section. If a wide table splits between its description and amount columns, a vertical break or a scaling adjustment may help. These changes affect printed pagination, not the gray labels themselves.

Before adjusting individual breaks, check the settings that determine page size and fit:

Orientation: Landscape may fit more columns across a page than Portrait.
Paper size and margins: A different paper size or narrower margins can move automatic breaks.
Scaling: The Scale to Fit options on the Page Layout tab can shrink a sheet to a chosen number of pages. Scaling can make text smaller, so inspect readability in print preview.
Print area: A defined print area limits what Excel includes. Use Page Layout > Print Area to set or clear it.

These settings can change the apparent page count and break positions. If the layout changes unexpectedly after you alter scaling, paper size, or the print area, revisit Page Break Preview and File > Print rather than assuming Excel has lost data.

Why the Page Count or Breaks May Look Unexpected

Excel calculates automatic breaks using the worksheet’s printable dimensions, printer settings, paper size, margins, and scaling. A workbook that fits on one printer may spill onto extra pages when opened on a computer with a different default printer or paper size. A change from Letter to A4, for example, can alter the available width or height and move automatic boundaries.

Hidden rows or columns, blank but formatted cells, and a large print area can also make the printed range seem bigger than the visible data. If Excel shows more pages than expected, inspect the print area and scroll to the sheet’s far edges for stray formatting. Use Page Layout > Print Area > Clear Print Area if an old print range is no longer wanted, then set a new one if necessary.

Manual breaks are another source of surprise. They can remain after the content changes, so a break that once made sense may now divide a section awkwardly. Review the solid lines in Page Break Preview. If you want Excel to recalculate breaks, use Page Layout > Breaks > Reset All Page Breaks; this removes manual breaks on the worksheet, so do it only when you are willing to lose those custom divisions.

Page Break Preview, Page Layout, and Print Preview Compared

These views answer related but different questions. Page Break Preview is the most direct place to see and adjust page boundaries. Page Layout view is useful for seeing the sheet in a page-like arrangement and working with margins or headers and footers. Print Preview, opened through File > Print, is best for checking the output before printing or saving as a PDF.

Choose Page Break Preview when you need to inspect or drag page breaks.
Choose Normal when the page labels interfere with editing cells.
Choose Page Layout when page shape, margins, or header and footer placement matter during editing.
Choose Print Preview when you want to confirm the pages that will actually be printed.

None of these choices changes the worksheet’s underlying values. A view change is not a substitute for checking the print preview, especially if the workbook will be shared or printed with different paper or printer settings.

Frequently Asked Questions

Do the large “Page 1” labels print?
No. They are screen-only indicators in Page Break Preview. Check File > Print to see the actual output, including any real header or footer numbers.

How do I get rid of the page numbers over my Excel cells?
Choose View > Normal. That hides the Page Break Preview labels without deleting data or changing the print layout.

Can I hide the labels and still drag page breaks?
Not in Page Break Preview, which displays the labels as part of the view. Switch back to that view when you need to adjust a break, then return to Normal or Page Layout.

Why are page numbers printed even after I switch to Normal?
Switching views only changes the screen display. Remove printed numbers from the sheet’s header or footer using Insert > Header & Footer or the Header/Footer tab in Page Setup.

Why does Excel show more pages than I expected?
Check the print area, paper size, orientation, margins, scaling, and manual page breaks. Any of these can change how Excel divides a worksheet for printing.

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.