How to insert and remove Watermark?
We are going to learn how to insert watermark behind the text in Microsoft Excel, and it is going to be done in a step by step format.
Watermarks are adding to create letters and templates so that when we enter data or write a letter it will always be displayed in the background.
Sometimes the companies write the company names in the background of their important documents. Sometimes we use the confidential watermark.
How to insert a watermark?
Start by opening a new book and let us first learn to add a watermark in Excel. You have the document ready, and want to put a watermark behind it.
Note: You do have to create the text image you would like to put behind the text.
Click on Insert tab (1), then text (2), and finally Header and Footer (3).
Click on pictures. Browse your files to locate the picture of your choice.
Note: The pictures automatically shows on top after clicking on the header and footer in the previous step.
Click on any of the text column, and the picture will show behind the text.
Click on &Picture that shows when you click on the header.
Click on Design (1) and Format picture (2).
Note: Click on design if it does not automatically show.
Click on picture
Click on the arrow beside color (1) choose washout (2), and click ok.
How to get rid of a watermark?
Removing the header
Now we are ready to learn to remove the watermark from the sheet.
It is almost the same procedure: Pagelayout > go to the header and where ever picture is printed just click the backspace to remove it.
The same as watermark was added, this time the watermark will be deleted.
Go to Special
Another way to remove a watermark is by Go to Special Excel functionality.
Please notice that a watermark is just an object in Excel. Go To Special will help you to highlight the objects in your worksheet.
After using this option the watermark wil be selected. By clicking Delete keyboard button the Watermark is gone.
Delete Background
The last method may be the most convenient way for deleting watermarks.
In most cases, watermarks would be added as backgrounds. That’s wonderful info for you.
Excel offers dedicated ribbon option of removing Backgrounds.
Go to Page Layout. When Delete Background button will be available for you, just use it.
Voila! A watermark is removed from your spreadsheet.
How to remove watermark from Excel sheet using VBA
Here’s a sample code that can help you remove the watermark from an Excel worksheet:
Sub RemoveWatermark()
Dim ws As Worksheet
Set ws = ThisWorkbook.Sheets("Sheet1") 'Change the sheet name as needed
ws.Shapes.Range(Array("Picture 1")).Delete
End Sub
To use this code, you need to follow these steps:
- Open the Excel file that contains the watermarked worksheet.
- Press ALT + F11 to open the VBA editor.
- In the editor, right-click on the workbook name in the Project Explorer and choose “Insert” and then “Module.”
- Paste the code into the new module.
- Press F5 or choose “Run” from the “Debug” menu to run the code.
This code will delete the first picture object (the watermark) in the worksheet named “Sheet1”. If you have multiple watermarks, you can duplicate the line ws.Shapes.Range(Array("Picture 1")).Delete for each watermark. Just be sure to change the picture name (e.g. “Picture 2”, “Picture 3”, etc.) accordingly.
Leave a Reply