How To Remove Page 1 Watermark From Excel: Complete Step-by-Step Guide

To quickly remove the large grey "Page 1" watermark from your Excel worksheet, simply change your workbook view from Page Break Preview to Normal View by clicking the "Normal" button under the "View" tab on the ribbon. If the watermark is a custom background image or header element, you must remove it via the "Page Layout" tab or by editing the "Header & Footer" settings to delete the picture code. Implementing these standard display adjustments instantly restores a clean, professional grid interface without altering your spreadsheet data.

Spreadsheet Interface Diagnostics & Pre-Removal Checklist

Before attempting to remove any watermark elements from a Microsoft Excel worksheet, you must identify the origin of the watermark. Excel does not have a single "watermark" tool; instead, what users commonly refer to as a watermark is typically one of three things: the default Page Break Preview background, an image inserted into the header or footer, or a tiled background sheet image. Diagnosing the specific type of watermark you are dealing with prevents unnecessary changes to your print layouts and ensures you apply the correct removal methodology.

This guide is designed for spreadsheets opened in modern desktop versions of Microsoft Excel, including Microsoft 365, Excel 2021, Excel 2019, Excel 2016, and Excel for Mac.

• Required Applications: Microsoft Excel desktop client (highly recommended for full feature access) or Excel for the Web.
• System Permissions: Active file editing permissions. If the workbook is locked, password-protected, or shared as read-only, you must unprotect the sheet before proceeding.
• Prerequisite Knowledge: Understanding of the Excel Ribbon interface, basic navigation of workbook views, and the distinction between screen-only display elements and printable page layouts.
• Estimated Duration: 1 to 3 minutes per sheet.
• Project Cost: $0 (utilizes built-in Microsoft Excel utility sets).

Step-by-Step Methods to Clear the Page 1 Watermark

Step 1: Switch Workbook View to Normal Mode

The most common cause of the large, semi-transparent "Page 1" text stretching across the center of your sheet is the active Page Break Preview mode. This view is designed to help you visually adjust print margins, but it overlays page numbers directly over your working cells.

1. Open the Excel workbook containing the affected worksheet.
2. Locate the main Ribbon menu at the top of your screen and click on the View tab.
3. In the Workbook Views section on the far left of the Ribbon, look at the highlighted option. If Page Break Preview is selected, this is the cause of your watermark.
4. Click the Normal button. This action immediately hides the grey page number overlays and returns your spreadsheet to the standard grid view.
5. Alternatively, you can look at the bottom-right corner of your Excel window on the Status Bar. Next to the zoom slider, you will see three small view icons. Click the first icon, which represents Normal View.

Pro-Tip: Switching to Normal View does not delete your manual page breaks. It simply hides the visual page indicators and blue boundary lines from your active screen workspace, allowing you to edit data without any visual distractions.

Step 2: Extract Header and Footer Watermark Graphic Codes

If you see a custom "Page 1," "Draft," or corporate logo watermark that persists in Page Layout View and appears on physical paper prints, it has likely been embedded in the sheet's header or footer system.

1. Select the worksheet from which you want to remove the watermark.
2. Click on the Insert tab on the Ribbon.
3. Navigate to the Text group on the right side of the Ribbon and click the Header & Footer button. Excel will automatically transition your display to Page Layout View.
4. Look at the top of your spreadsheet. You will see three distinct header boxes: left, center, and right. Click inside each of these boxes.
5. If a watermark image is present, one of these boxes will display a text variable string: &[Picture].
6. Click inside the specific header box containing that exact text string. Highlight the &[Picture] text and press the Backspace or Delete key on your keyboard.
7. Click any cell inside the main worksheet body to exit the header editing space. The background watermark image will immediately vanish.
8. Go back to the View tab on the Ribbon and click Normal to return to your preferred drafting environment.

Warning: Removing the &[Picture] code permanently deletes the associated image file from that specific worksheet header. If you do not have the original graphic file saved on your hard drive, duplicate the workbook file before performing this deletion.

Step 3: Remove Page Layout Background Overlays

Sometimes, watermarks are applied as sheet-wide background patterns. These backgrounds repeat across the entire grid surface and do not print by default, but they can make reading data on-screen difficult.

1. Select the active worksheet containing the tiled background watermark.
2. Click on the Page Layout tab on the Ribbon interface.
3. Look at the Page Setup group, located to the right of the Themes group.
4. Locate the Background button. If a background image is already active on the sheet, this button's label dynamically changes to Delete Background.
5. Click Delete Background. The background graphic layer will be removed instantly from the sheet canvas.

Step 4: Purge Hidden Floating WordArt and Graphic Shapes

In older Excel files or spreadsheets exported from external database systems, watermarks are sometimes created as transparent WordArt objects or vector shapes anchored to specific cells.

1. Open your spreadsheet and select the target sheet.
2. Press the F5 key on your keyboard to trigger the Go To navigation dialog box.
3. Click the Special button located at the bottom-left corner of the dialog menu.
4. In the Go To Special options window, select the radio button labeled Objects, then click OK.
5. Excel will scan your worksheet and automatically select every floating shape, text box, image, and WordArt graphic on the page.
6. Look closely at your spreadsheet. If a transparent "Page 1" or "Draft" graphic displays selection handles (small circles around its perimeter), it is a floating object.
7. Press the Delete key on your keyboard to remove all selected objects, or click on the specific boundary of the watermark object and press Delete to remove only that item while keeping other desired charts or shapes.

Technical Comparison of Excel Display Views & Watermark Behaviors

The table below outlines the core properties, visual manifestations, and printing impacts of the different watermark removal methods in Microsoft Excel.

Common Excel Watermark Removal Failures & Solutions

The "Delete Background" Button is Greyed Out or Non-Responsive

• Root Cause: The active worksheet is currently protected, which locks all structural page properties, or the watermark is located inside the header layer rather than the page background layer.
• Actionable Fix: Go to the Review tab on the Ribbon and check the Protect group. If you see an Unprotect Sheet option, click it (and enter the decryption password if prompted). If the Delete Background button remains greyed out after unprotecting, the watermark is likely a header asset; proceed with the Header & Footer removal steps instead.

The Grey "Page 1" Watermark Remains Visible in Normal View

• Root Cause: A corrupt workspace view state, or a third-party add-in is overriding default display options. In rare instances, a user has manually drawn a grey background graphic that mimics the appearance of the default Excel view watermark.
• Actionable Fix: Press the keyboard shortcut combination Alt + W + L on Windows to force the display engine to recalculate and transition into Normal View. If the text persists, navigate to Home, click Find & Select, choose Selection Pane, and check the right-hand panel for any hidden graphic objects named Rectangle, WordArt, or Picture that might be holding the watermark design.

Removing the Header Code Destroys the Top Margin Layout

• Root Cause: The sheet margins were manually customized to accommodate a large header logo image, and deleting the picture asset leaves a massive, empty white gap at the top of your physical prints.
• Actionable Fix: Navigate to the Page Layout tab, click Margins, and select Custom Margins. Adjust the Top and Header margin numeric input fields down to standard values (typically 0.75 inches for top margin and 0.3 inches for header margin) to restore normal row placement.

The Watermark Only Shows Up in the Print Preview Screen

• Root Cause: The watermark is set inside a defined Print Area background property or is linked to a custom print template macro that injects the graphic during the spooling process.
• Actionable Fix: Go to the Page Layout tab, click Print Area, and select Clear Print Area. Next, press Ctrl + P to check the Print Preview screen again. If the watermark remains, click Page Setup at the bottom of the print options panel, select the Sheet tab, and verify that the Gridlines and Draft Quality options are configured correctly to suppress unwanted visual elements.

Frequently Asked Questions

Why does Excel show a giant "Page 1" watermark in the middle of my sheet?

Excel displays this watermark when your active worksheet is set to Page Break Preview mode. This mode is designed to help you organize data layouts for printing by showing exactly where page splits occur, and the watermark is a non-printing indicator showing the specific page order.

How do I remove a draft watermark that only shows up when printing?

If the watermark only displays when printing, it is stored as an image within the header or footer fields. To remove it, go to the Insert tab, select Header & Footer, click inside the top header boxes, delete the &[Picture] text code, and save your file.

Can I hide the page break lines after returning to Normal View?

Yes. Go to File, click Options, and select the Advanced category on the left. Scroll down to the Display options for this worksheet section, uncheck the box labeled Show page breaks, and click OK to hide the dotted lines.

Why can't I click on or select the Page 1 watermark to delete it?

You cannot click on the watermark because it is a system-generated layout indicator rather than a physical shape or cell value. To make it disappear, you must change your Workbook View setting from Page Break Preview back to Normal View on the View tab.

How do I remove a watermark on Excel for Mac?

On a Mac, the process is identical. Navigate to the View tab on the Excel for Mac ribbon and click the Normal button, or go to the Page Layout tab to delete background elements using the native menu commands.

Streamline Your Excel Document Design

Removing distracting display watermarks is only the first step in creating clear, boardroom-ready reports. Eliminate clutter, format your tables, and implement professional data structures to ensure your spreadsheets look polished, clean, and professional before your next major presentation.