Excel Page Break Preview: Remove the Watermark?

To remove the large gray “Page 1” label in Excel, switch out of Page Break Preview: choose View > Normal. The label is a screen-only guide, not a watermark printed on the worksheet; if words or an image appear on paper or in print preview, check the worksheet’s headers and footers instead.

What the Page Break Preview label means

Page Break Preview is a worksheet view that helps you see how Excel divides a sheet into printed pages. The large gray page number—such as “Page 1” or “Page 2”—identifies the area assigned to each page. It can look like a watermark because it is overlaid on top of the cells, but it is part of the view, not worksheet content. Excel does not print that gray label.

This view also shows page boundaries. Blue lines mark page breaks; depending on the break, a line may be solid or dashed. The preview can make the worksheet appear faded or oversized, and the visible page area may be surrounded by gray space. Those visual changes do not alter cell values, formulas, formatting, or the data stored in the workbook.

Page Break Preview is useful when a table is being split awkwardly across pages or when you want to move a page boundary. It is not the same as Print Preview, which shows a representation of the pages as they are currently set up to print.

How to remove the label in Excel for Windows

In Excel for Microsoft 365 on Windows, use the view selector on the ribbon:

Open the worksheet that shows the gray page label.
Select the View tab.
In the Workbook Views group, select Normal.

The “Page 1” lettering disappears immediately because Normal view does not display the large page-number overlay. This changes only how the sheet is displayed. It does not delete page breaks, change print scaling, or remove anything from the worksheet.

You can return to the same preview later by choosing View > Page Break Preview. Excel may also offer view buttons near the lower-right corner of the window; selecting the Normal view button there has the same basic purpose. If the ribbon is minimized, expand it or use the view buttons rather than trying to erase the label with Delete. The gray lettering is not an object or a cell value, so selecting a cell and pressing Delete will not remove it.

Hide page-break lines while staying in Normal view

Switching to Normal removes the large page-number label, but Excel may still show page-break lines on the worksheet after you have used Print Preview or printed. These lines are separate indicators from the “Page 1” overlay. If you want a cleaner worksheet while remaining in Normal view, Windows Excel has a per-worksheet display option:

Choose File > Options.
Select Advanced.
Scroll to Display options for this worksheet.
Choose the relevant worksheet in the dropdown if necessary.
Clear Show page breaks, then select OK.

This setting hides the page-break indicators for the selected sheet in Normal view. It does not remove the underlying page breaks or change what will print. To see the breaks again, return to the same option and select Show page breaks. If you have several worksheets with visible lines, check the setting for each sheet; the option is tied to a particular worksheet rather than being a command that deletes all workbook print divisions.

What changes when you leave Page Break Preview?

Changing to Normal view is a display choice, not a print-layout reset. Any manual page breaks you inserted remain in place, as do automatic breaks calculated from the paper size, margins, scaling, and content. If the worksheet was set to fit on one page, that print setting remains active too.

For example, imagine a sales table that spans columns A through H. In Page Break Preview, Excel might show that columns G and H fall onto a second printed page. Choosing Normal hides the page-number overlay, but it does not bring those columns onto the first printed page. To change the printed result, adjust the layout settings or the page breaks, then check the result in Print Preview.

If your goal is to remove a manual page break rather than the gray label, use Page Layout > Breaks > Reset All Page Breaks. This resets manual breaks on the active worksheet so Excel can determine the page divisions automatically. It is a different action from changing views and may change the number or arrangement of printed pages. Use it only when you intend to reset the sheet’s manual page-break choices.

Check whether anything is really printing

To verify whether a suspected watermark will appear on paper, open File > Print and inspect the print preview. The large gray “Page 1” label from Page Break Preview should not appear there. If it does not appear in the preview, it is not part of the printed page.

If text or a graphic does appear in the preview, inspect the actual print elements rather than the Page Break Preview setting. Excel can put content in a header or footer, including text such as a company name or a picture that resembles a watermark. In the desktop app, check Insert > Header & Footer, or use the header and footer controls available from the Page Setup dialog. Review the center, left, and right header and footer sections on the affected sheet. A header or footer may also be set differently on the first page or on odd and even pages, so check those options if the content appears inconsistently.

Excel worksheet backgrounds are another possible source of confusion. A picture added as a sheet background is for on-screen display and does not print as a page watermark. A picture inserted into a header or footer, by contrast, can be part of the printed page. Print Preview is the practical way to distinguish a view-only effect from content that will be sent to the printer.

When to adjust page breaks instead

Page Break Preview is more than a way to inspect page divisions: it lets you adjust them. You can drag a page-break line to change where Excel starts a new printed page. Moving a boundary can be useful when a heading is separated from its table or a narrow column is pushed onto an otherwise empty page. After moving breaks, inspect Print Preview to make sure the result is readable and fits the intended paper size.

Before changing breaks, consider the other print controls that can produce the same apparent problem:

Orientation: Landscape orientation may fit a wide table better than portrait.
Margins: Narrower margins can create more room, though text may become harder to read near the page edge.
Scaling: “Fit Sheet on One Page” can shrink a large worksheet substantially. A tiny printout may be a scaling issue, not a page-break issue.
Print area: A defined print area can exclude cells or create unexpected page divisions. Review it under Page Layout > Print Area.
Paper size: A mismatch between the selected paper and the printer’s paper can affect page layout.

These settings affect pagination; switching out of Page Break Preview does not. Make one change at a time and review the print preview, especially for wide worksheets or reports that span many pages.

Excel on Mac and Excel for the web

In Excel for Mac, the same basic fix applies: switch the worksheet to Normal from the View tab or the view controls. Ribbon placement and some dialog labels can differ between Mac releases, but selecting Normal changes the display rather than deleting content. If you are specifically trying to hide page-break lines while in Normal view, check the options available in your Excel for Mac version; Windows’ File > Options path is not a Mac menu path.

Excel for the web has a more limited set of desktop print and worksheet display controls, and available commands can vary. If the browser version does not show the view or page-break setting you need, open the workbook in the desktop Excel app and make the change there. In either version, use print preview to confirm whether a genuine header, footer, or other print element is present.

Common mistakes and quick checks

Several attempted fixes target the wrong thing. Avoid deleting cells, changing font color, or editing the page setup just to remove the gray label. Those actions can damage the sheet or alter printing without affecting the Page Break Preview overlay. Likewise, resetting all page breaks is unnecessary if you only want to return to a normal editing view.

A quick diagnosis helps identify the right fix:

If “Page 1” is visible over the sheet, choose View > Normal.
If blue break lines remain in Normal view, turn off Show page breaks for that worksheet in Excel Options on Windows.
If the content appears in File > Print, inspect headers, footers, and print settings.
If the printed pages split in an inconvenient place, adjust page breaks or layout settings rather than changing views.

This distinction matters when a workbook is shared. A view change may make the sheet more comfortable to edit, but it does not revise the printed report for a colleague. If print layout is the real concern, save the workbook after adjusting the relevant print settings and check the preview again.

Frequently Asked Questions

Does the Page 1 watermark print from Excel?
No. The large gray page number is an indicator displayed in Page Break Preview. Check File > Print to confirm the printed-page appearance.

How do I get rid of Page 1 in Excel without deleting anything?
Select View > Normal. The label is not a cell, shape, or watermark object, so it does not need to be deleted.

Why do page-break lines still show after I switch to Normal?
Excel can display page-break indicators in Normal view after print-related actions. In Windows, clear Show page breaks under File > Options > Advanced for the affected worksheet.

Will switching to Normal change how my worksheet prints?
No. It changes the on-screen view. Manual breaks, paper settings, margins, scaling, and print areas remain as they were.

How do I remove a real watermark from a printed Excel page?
Check the sheet’s header and footer for text or a picture, then review Print Preview. A worksheet background image is not printed as a watermark; a header or footer image can be.

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.