If the file you have copied or imported from other sources has been watermarked, and in this case you want to remove the watermark from the worksheet. Here are some tricks that can help you to quickly remove the watermark from the worksheet in Excel. But if you are interested in adding watermark to protect your document or image. Check this blog post on how to add watermark in word to do it easy.
Remove Watermark With Go To Special Function
If the watermark is inserted as Art Word, you can use the Go to Special function to locate the Art Word and then press the Delete button to remove this type of watermark. 1.
1. first of all, you need to switch to the Page Layout view to see the watermark, click View > page layout. See the picture:
2. Then click Home > Find
and Select > Go to Special. See the image:
3. In the Go to Special
dialog, check object option and then click OK to close the dialog.
4. Then you can see the Word Artwork watermark has been selected, press the Delete button to remove the watermark. See the image:
Tip: With this method the other objects, such as images, shapes will also be removed.
Remove Watermark With Header/Footer Function
If the watermark is inserted as a header/footer, you need to follow the steps below. 1:
1. first, you need to go to the page layout view by clicking View > page layout.
2. Then click insertion > header footer to show headers and footers. See the image:
3. Then you can see that there is a text "&[Scenario]"In the header or footer, delete this text and then the watermark from the whole worksheet will be removed. See the image:
Insert / Remove Watermark With Kutools For Excel
In fact, if you have Kutools for Excel - an additional useful tool with over 300 utilities, you can quickly insert or remove the watermark as quickly as possible.
After free Kutools for Excel installation, do the following:
1. Enable the sheet where you want to insert the watermark and go to Page Layout see by click Page Layout button in the status bar. See the picture:
2. Click Kutools > insert > Insert Watermark. See the image:
3. In Insert Watermark , you can import an image as a watermark or specify text with the desired formatting. See the image:
4. Click Apply or Ok, and the watermark has been inserted.
Remove the watermark
Activate the sheet from which
you want to remove the watermark and click Kutools > Delete > Delete
Watermark. See the image:
