Excel Page Break View Without Page Numbers: What to Do

In Excel for Microsoft 365 on Windows, you cannot hide the large “Page 1,” “Page 2,” and similar labels while staying in Page Break Preview: Excel does not provide a separate control for those on-screen labels. Switch to Normal view to remove them, or use Page Layout view for a different print-oriented view; the labels are only a preview overlay and do not print.

What the page-break view is showing

Page Break Preview is a worksheet view designed to show how Excel has divided a sheet into printed pages. The large page labels identify the areas that would be printed as individual pages. Blue lines mark page boundaries: solid lines generally indicate page breaks Excel has set, while dashed lines can indicate automatic breaks. You can drag a break line to change where one printed page ends and the next begins.

The view is useful when a report is almost ready to print but its columns or rows spill onto an extra page. For example, a table that should fit on one page wide might otherwise print its first five columns on page one and the remaining columns on page two. Page Break Preview makes that split visible and lets you adjust the break or investigate the print settings.

The page labels are not worksheet content. They are not values in cells, headers, footers, or objects that you can select and delete. They are part of the preview display. That distinction explains why editing a header or changing a print setting will not make the large labels disappear from Page Break Preview.

Can you hide the labels but keep Page Break Preview?

No—not through a standard Excel setting. In the Windows desktop app, there is no built-in switch to retain Page Break Preview’s page boundaries while hiding only the oversized page labels. Excel treats those labels as part of the view itself.

Some nearby settings sound as though they might help but address a different issue. Turning off page-break indicators in worksheet display options can hide break lines in Normal view; it does not turn Page Break Preview into a label-free version of itself. Likewise, removing a page number from a printed header or footer changes the printout, not the overlay shown on screen.

If the labels are distracting, the practical choice is to use another view while editing. You can return to Page Break Preview whenever you need to inspect or adjust the printed page divisions.

Switch to Normal view to clear the overlay

To leave Page Break Preview in Excel for Microsoft 365 on Windows, select View > Normal on the ribbon. The large page labels disappear, and the sheet returns to the regular grid. To see the page divisions again, choose View > Page Break Preview.

On Excel for Mac, use the View tab and select Normal or Page Break Preview. The available controls and their placement can vary by Mac version, but changing the worksheet view is the same basic solution. Excel for the web does not offer the full desktop set of page-break editing controls in every experience; if you need to inspect or drag page breaks, open the workbook in the desktop app.

Switching views does not undo changes to the worksheet or remove the page breaks you set. It only changes how Excel displays the sheet. If you later return to Page Break Preview, the page labels and boundaries appear again.

Use Page Layout view for another print-focused view

View > Page Layout is a useful alternative when you want to see a worksheet arranged as printed pages without the large Page Break Preview labels. It shows page-sized areas and margins, and it can display headers and footers in context. It is not identical to Page Break Preview: its main purpose is to show page layout and printable content, rather than to provide the same direct overview of page breaks.

This distinction matters if your goal is to work on the sheet while keeping a sense of paper size. Page Layout view can help you judge whether a title, table, or footer fits on a page. If you need to move a page break precisely, return to Page Break Preview. If you just need a clean grid for entering data, choose Normal.

You can switch among these views from the View tab. Excel’s view buttons near the lower-right corner of the window can also provide quick access to Normal, Page Layout, and Page Break Preview, depending on the app version and window layout.

Remove page numbers from the printed worksheet

If by “page number” you mean a number printed at the top or bottom of each sheet, that is separate from the large preview label. To change printed headers and footers in Excel for Windows, open Page Layout, then select the small dialog box launcher in the Page Setup group. In the Page Setup dialog, open the Header/Footer tab and set the header and footer choices to (none) if you want neither to print.

If a custom header or footer is in use, choose Custom Header or Custom Footer in that dialog and remove the page-number field from the relevant section. Excel’s page-number field is commonly represented by &[Page]; a total-page field may appear as &[Pages]. Remove only the field you do not want, keeping any other text or fields you still need. On Mac, open the page setup or header-and-footer controls from the Page Layout tools; dialog labels and placement can differ by version.

Check the result in File > Print or Print Preview. A large “Page 1” visible in Page Break Preview is not evidence that a page number will be printed. Only content in the worksheet’s printable area, including configured headers and footers, is part of the printout.

Hide page-break lines in Normal view

Excel can also show page-break lines in Normal view, especially after you have opened Print Preview or used Page Break Preview. These lines are different from the large labels. In Windows, open File > Options > Advanced. Under Display options for this worksheet, select the worksheet you want to change in the dropdown, then clear Show page breaks. Select OK to apply the setting.

This option is worksheet-specific, so confirm that the correct sheet is selected in the dropdown. It controls whether page-break indicators appear in the regular worksheet view; it does not remove the page boundaries from Page Break Preview. On Mac, the equivalent display preference is located through Excel’s preferences or settings, and its name or location may vary by release. If you cannot find the option, switching to Normal view is still the direct way to remove the large overlay.

Hiding the indicators does not change printing, scaling, or the actual page breaks. It changes only their display in the worksheet. If you need to adjust a break later, turn the indicators back on or return to Page Break Preview.

Choose the right view for the task

The best view depends on what you are trying to do. Use the following guide rather than changing print settings just to remove a screen label:

Normal: Choose this for everyday data entry and formulas, or when you want the page labels gone.
Page Break Preview: Choose this to see page boundaries and adjust where printed pages split. The large labels are part of this view.
Page Layout: Choose this to inspect margins, page-sized areas, and headers or footers in a print-oriented layout.
Print Preview: Choose this to check the actual print output, including scaling and configured headers and footers, before printing.

For instance, suppose a worksheet has a wide sales table and Page Break Preview shows “Page 1” across the left section and “Page 2” across the right. If the issue is simply that the labels cover the cells while you edit, use Normal. If the issue is that the right-hand columns print on a second page, stay in Page Break Preview and adjust the layout, print area, scaling, or break as appropriate. If the concern is a number at the bottom of the printed page, edit the footer instead.

Common problems and misconceptions

The page label appears in a screenshot. A screenshot taken in Page Break Preview will include the on-screen overlay. Change to Normal or Page Layout before capturing the worksheet if you want a clean image. This does not affect a printed copy or a PDF exported from the worksheet’s print output.

Removing the footer number did not remove “Page 1.” That is expected. Footer page numbers are print content; the large label is a view indicator. Change the worksheet view to remove the latter.

The page breaks changed after changing scaling or paper size. Excel calculates page divisions using settings such as paper size, orientation, margins, scaling, print area, and the printable area supported by the selected printer. A break that looked suitable under one setup can move when those settings change. Review the print preview after making adjustments, because the displayed pagination can depend on the current print setup.

The break lines are gone in Normal view. Check the worksheet’s Show page breaks display option. The lines may be hidden even though the print pagination still exists. Turning the option back on restores the indicators in Normal view; it does not alter the page layout.

Changing zoom did not hide the labels. Zoom changes the apparent size of the sheet on screen, not which view is active. It is not a reliable way to hide the labels. Switch to Normal or Page Layout instead.

Frequently Asked Questions

Can I remove Page 1 from Page Break Preview without changing views?
No. Excel does not provide a separate setting to hide only the large page labels while keeping Page Break Preview active. Choose Normal or Page Layout to see the sheet without that overlay.

Will the large page numbers print?
No. The labels are part of the on-screen preview, not worksheet text or a header or footer. Check File > Print to see the output Excel is preparing.

How do I remove a page number from the printed footer?
Open Page Setup, select the Header/Footer tab, and remove the page-number field from the footer or set the footer to (none). That changes the printed footer, not Page Break Preview’s labels.

Why do dashed page-break lines appear in Normal view?
They indicate page divisions in the worksheet display and may become visible after print-related actions. In Windows, clear Show page breaks under File > Options > Advanced for the selected worksheet to hide those indicators in Normal view.

Does switching to Normal delete my manual page breaks?
No. Changing views does not delete page breaks. Return to Page Break Preview to inspect them. To change or remove a manual break, use the page-break controls or adjust the break in Page Break Preview, rather than treating a view change as a print-layout edit.

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.