Excel: Hide the Page 1 Watermark and Restore Normal View

To hide the large gray “Page 1” watermark in Excel, switch the worksheet from Page Break Preview to Normal view: select View > Normal. The wording is a screen-only page indicator, not usually a watermark printed on the sheet. If the words appear on a printout or in a PDF, check the worksheet’s headers, footers, and background image instead.

This guide covers Excel for Microsoft 365 on Windows. Switching views does not delete cell contents, change page setup, or remove print breaks; it changes how the worksheet is displayed. If you are trying to remove an actual printed image or text, use the troubleshooting guidance below to identify its source.

What You’ll Need

The Excel workbook open in the desktop app, with the worksheet showing the “Page 1” overlay.
Permission to change the workbook view. If the sheet is protected or the workbook opens read-only, you may need to save an editable copy first.

Step-by-Step

Open the worksheet with the overlay. Select its sheet tab at the bottom of Excel. If you have several sheets and are unsure which one is affected, click each tab and look at the center of the grid. The gray “Page 1,” “Page 2,” or similar label appears over the worksheet area in Page Break Preview.
Open the View tab. On the ribbon, select View. Find the Workbook Views group, which contains options such as Normal, Page Break Preview, and Page Layout. If the ribbon is collapsed, click a ribbon tab to show it, or use the ribbon display control near the upper-right corner of the Excel window.
Select Normal. In View > Workbook Views, click Normal. Excel changes the active worksheet to the standard grid view, and the large page-number overlay should disappear immediately. Your data and formatting remain in place.
Use the status bar as an alternative. At the bottom-right of the Excel window, near the zoom controls, select the Normal view button. It is usually the leftmost of the three view shortcuts. This performs the same view change without opening the ribbon. If you do not see the buttons, use the View tab method.
Check other worksheets. Click other sheet tabs and see whether any still show a page-number overlay. If a sheet is still in Page Break Preview, repeat the Normal-view command while that sheet is active. Do not assume that changing the first sheet has fixed every sheet in a workbook with multiple tabs.
Save if you want to retain the display choice. Press Ctrl+S on Windows after switching views. Excel generally saves view and page-break display information with the workbook, but the exact view shown when the file is opened can depend on the workbook and the active sheet. Saving makes your current changes less likely to be lost.
Confirm that you changed only the view. If you need to print the worksheet, open File > Print and inspect the preview. Normal view hides the on-screen page-number label, but does not remove page breaks or alter the print area. The print preview, rather than the grid display, is the right place to confirm what will appear on paper.

In Excel for Mac, the equivalent command is View > Normal; the precise ribbon layout can differ slightly by release. The workbook-view controls are also available from the status bar in many Mac versions. Excel for the web has a more limited set of page-layout features, and its available view choices can vary; if you cannot find Page Break Preview controls there, open the workbook in the desktop app and switch to Normal view.

Common Mistakes

Deleting worksheet content to remove the label. “Page 1” is not a cell value. Searching for it in the grid or deleting rows and columns will not remove the overlay and could damage the sheet.
Changing the print area unnecessarily. A page number shown in Page Break Preview does not mean the print area is wrong. Use Normal view to hide the overlay; only change Page Layout > Print Area if you actually need to redefine which cells print.
Confusing an on-screen label with a printed watermark. The gray page number is a view aid. A company logo, “Draft” text, or other mark that appears in print is likely part of a header, footer, or inserted graphic. Switching to Normal will not remove those items.
Removing page breaks when you only want a cleaner screen. Page breaks determine pagination. Resetting or deleting them can change how many pages print. Leave them alone if the only problem is the large page-number overlay.
Assuming every sheet changed. A workbook can contain many worksheets, and one may still show a page overlay after you switch another sheet to Normal. Inspect the affected tabs individually.

Tips

Know which view you are in. Page Break Preview makes page boundaries and page numbers prominent. Normal is the usual editing view. Page Layout displays a page-oriented view with margins and header and footer areas; it is not the same as Normal, and it may still show page layout features even though the large Page 1 overlay is gone.
Keep page-break planning separate from screen display. If you need to adjust pagination, use Page Break Preview temporarily, make the needed changes, and switch back to Normal for everyday editing. The view toggle itself does not erase manual page breaks.
Use print preview to check output. Select File > Print to review the actual page layout. If a mark is visible there, investigate headers and footers or graphics; if it appears only over the worksheet grid, it is a display indicator.
Save a copy before editing print elements. Switching views is safe and reversible, but removing a logo or changing header/footer content affects the workbook’s printed output. Save a separate copy before making those changes if you need to preserve the original layout.
Return to Page Break Preview when useful. You can switch back through View > Page Break Preview to inspect pagination. The page-number overlay will return as part of that view; it does not mean the workbook has acquired a new watermark.

Troubleshooting

The Page 1 label is still visible after selecting Normal. Check that you selected the worksheet with the label, rather than another tab. Then use View > Normal again and confirm the Normal option is selected. If several workbook windows are open, make sure you are changing the intended workbook.
The words appear in print preview or a PDF. This is not the usual Page Break Preview overlay. In the worksheet, open Insert > Header & Footer and inspect the header and footer areas for text or a picture. Also check Page Layout settings and look for an inserted logo or image on the sheet. Remove only the item you have identified, then preview again.
The sheet is in Page Layout view rather than Page Break Preview. Choose View > Normal to return to the standard grid. If you see margin boundaries or header and footer editing areas, those are clues that the sheet is in Page Layout view, not that a watermark has been inserted.
You cannot change the view or save the workbook. The file may be read-only, opened in Protected View, or restricted by workbook or worksheet protection. If appropriate, select Enable Editing or use File > Save As to create a copy you can edit. Protection settings can vary, so ask the workbook owner before changing a shared file.
The page labels return later. Another user may have saved the workbook in Page Break Preview, or you may have switched back to that view while checking breaks. Select Normal again and save. If the file is shared, tell collaborators that Normal view is your preferred display, since another person’s later save may change the view state.
You cannot find the view buttons. Use the ribbon path View > Normal rather than relying on the small status-bar icons. In a narrow window, ribbon groups may be compressed; maximize Excel or expand the ribbon to make the Workbook Views options easier to locate.

Frequently Asked Questions

Does the gray “Page 1” label print?
No. In Page Break Preview, it is an on-screen indicator showing the page area. Confirm the actual output with File > Print. If the label appears in the print preview, look for separate header, footer, or image content.

Will switching to Normal delete my page breaks?
No. It changes the worksheet display, not the page-break settings. Existing automatic and manual page breaks remain available when you return to Page Break Preview or inspect print layout.

Can I hide the label without leaving Page Break Preview?
Excel does not provide a separate toggle for hiding only the large page-number overlay while keeping that view. Choose Normal to remove the overlay from the editing screen, then return to Page Break Preview whenever you need to inspect pagination.

Why does only one worksheet show “Page 1”?
That worksheet is likely in Page Break Preview while the others are in another view, or it has different page setup needs. Select the affected sheet and choose View > Normal. Check other tabs if you want the same display throughout the workbook.

Is “Page 1” a watermark added by Excel?
Usually, no. It is a page-number overlay associated with Page Break Preview. Excel does not have a standard worksheet watermark command that adds this gray label to printed pages. A real printed watermark generally comes from content in a header or footer, or from an image or text object.

Does the same instruction work in Excel for Mac?
Yes: select View > Normal. Ribbon placement and status-bar controls can look different on Mac, so use the View menu if the shortcut buttons are not visible. Excel for the web may offer fewer page-break controls than the desktop versions.

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.