How to Remove Watermark in Excel (3 Ways)

There are multiple ways to insert a watermark in Excel. Depending on the methods, you’ve inserted a watermark, multiple methods are available to remove a watermark too. In this article, you will learn 3 ways to remove a watermark in Excel.


How to Remove Watermark in Excel: 3 Ways

1. Use the Delete Background Command to Remove the Watermark in Excel

If you add a watermark to your Excel worksheet using the following method, then you have to use the Delete Background command to remove it.

To add a background image as a watermark,

❶ Go to the PAGE LAYOUT tab first.

❷ Then click on Background.

Add a watermark in Excel using Background command

This will allow you to insert an image as a watermark background. After adding an image, your Excel worksheet will look like this:

Now to remove the watermark,

❶ Go to the PAGE LAYOUT tab again.

❷ Now hit the Delete Background command.

This command will instantly remove the watermark from your Excel worksheet.

Use Delete Background Command to Remove Watermark in Excel

Read More: How to Remove Page 1 Watermark in Excel


2. Use Header & Footer to Remove Watermark in Excel

You can add a watermark to your Excel worksheet using the following way too.

To technique is,

❶ You have to go to the INSERT tab first.

❷ Under the Text group, you will find Header & Footer. Just click on it.

Use Header & Footer command to add a watermark in Excel

Then, you will see a box with a “Click to add header” caption.

❸ Click on the box with the caption “Click to add header”.

❹ Go to the Picture command in the Header & Footer Elements group.

Then you will have the option to insert an image as a watermark. Add a picture, then you will see the Header box showing &[Picture] message.

This means your selected picture has already been added as a watermark. Just click on any cell out of the Header box, and you will see the watermark there.

So, if you have followed the above method to add a watermark, follow the steps above to remove the added watermark from your Excel worksheet.

❶ First go to the INSERT tab.

❷ Under the Text group, you will find Header & Footer. Click on it.

Use Header & Footer to Remove Watermark in Excel

Then you will see the Header box displaying &[Picture] caption.

❸ Select the whole &[Picture] caption and delete it.

After deleting the &[Caption] text, click on any cell outside of the Header box. We will see if the watermark has gone away.


3. Use Go To Special to Remove Watermark in Excel

You can use the WordArt feature to add a watermark to your Excel worksheet.

The working procedure to add a watermark using the WordArt feature is as follows:

❶ First go to the INSERT tab.

❷ Under the Text group, you will easily find the WordArt option. Just click on it.

Use WordArt command to add a watermark in Excel

Then you will have a box to insert text. After completing enter the text, you will have a watermark added to your worksheet as follows:

To remove the watermark that you have inserted using WordArt,

❶ Press CTRL + G keys. This will open the Go To dialog box.

❷ From the Go To dialog box, click on Special.

Then the Go To Special dialog box will appear.

❸ Now select Objects and then hit the OK command.

Use Go To Special to Remove Watermark in Excel

After that, the watermark will be selected as the following picture. Now all you need to do is,

❹ Select the WordArt and press the Delete button.


Things to Remember

  • You can add a watermark to your Excel worksheet as a form of text or picture.
  • Watermarks are not visible in Normal view mode. They are visible only in the Page Layout mode and Print Preview mode.

Download the Practice Workbook

You can download the Excel file from the following link and practice along with it.


Conclusion

To sum up, we have discussed methods to remove a watermark in Excel. You are recommended to download the practice workbook attached along with this article and practice all the methods with that. And don’t hesitate to ask any questions in the comment section below. We will try to respond to all the relevant queries ASAP.


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