How to Remove a Watermark in Excel – 3 Methods

Method 1 – Use the Delete Background Command to Remove the Watermark in Excel

  • Go to the PAGE LAYOUT tab.
  • Click Background.

Add a watermark in Excel using Background command

This is the output.

To remove the watermark,

  • Go to the PAGE LAYOUT tab again.
  • Select Delete Background.

 

Use Delete Background Command to Remove Watermark in Excel

Read More: How to Remove Page 1 Watermark in Excel


Method 2 – Use the Header & Footer command to Remove Watermark in Excel

  • Go to the INSERT tab.
  • In Text, click Header & Footer.

Use Header & Footer command to add a watermark in Excel

A box with a “Click to add header” caption will be displayed.

  • Click the box.
  • In Header & Footer, choose Picture .
  • Insert an image as a watermark and you will see the Header box showing the &[Picture] message.
  • Click any cell out of the Header box to see the watermark.

To remove the watermark:

  • Go to the INSERT tab.
  • In Text, click Header & Footer.

Use Header & Footer to Remove Watermark in Excel

The Header box with the &[Picture] caption will be displayed.

  • Select the whole &[Picture] caption and delete it.
  • Click any cell outside of the Header box. The watermark was removed.


Method 3 – Use Go The To Special command to Remove a Watermark in Excel

  • Go to the INSERT tab.
  • In Text, click WordArt.

Use WordArt command to add a watermark in Excel

  • Insert your text in the box to see the watermark.

To remove the watermark:

  • Press CTRL + G to open the Go To dialog box.
  • In Go To, click Special.

In the Go To Special dialog box:

  • Select Objects and click OK.

Use Go To Special to Remove Watermark in Excel

 

  • Select the WordArt and press Delete.


Things to Remember

  • Watermarks are not visible in Normal view mode. They are visible in Page Layout and Print Preview mode only .

Download the Practice Workbook

Download the Excel file and practice.


Related Articles


<< Go Back to Watermark | Page Setup | Print in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Mrinmoy Roy
Mrinmoy Roy

Mrinmoy Roy, a dedicated professional with a BSc in Electronics and Communication Engineering from Khulna University of Engineering & Technology, Bangladesh, brings over two years of expertise to the ExcelDemy project. As a prolific contributor, he has authored around 180 articles, showcasing his deep knowledge and passion for Microsoft Excel, Data Analysis, and VBA. His unwavering commitment to continuous learning, combined with versatile skills, renders him well-suited for roles in data management and spreadsheet solutions. He has interest... Read Full Bio

2 Comments
  1. hello it was wonderful to know

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo