How to Add and Remove Watermark in Excel? Watermarks are essential in document design, often used to add branding, labels, or additional information to Excel sheets. Watermarks can be a valuable tool if you want to enhance the professional look of your worksheets or personalize them with your organization’s logo. However, there may come a time when you need to remove an existing watermark or add a new one to your Excel sheet.
In the article, we will explore various methods to add or remove watermarks in Excel, providing you with the knowledge and techniques to customize your spreadsheets according to your needs. So, let’s dive in and learn how to effectively add or remove watermarks from Excel sheets.
How to Add and Insert a Watermark in MS Excel?
Method 1: Add/Insert a Text Watermark Using Header & Footer
The Header & Footer feature in Excel enables you to add text, images, and other factors to the headers and footers of your worksheets. By using this feature, you can easily insert a text watermark. Here’s how:
- Open the Excel sheet if you want to add a watermark.
- Go to the “Insert” tab in the Excel ribbon.
- Look for the “Text” group and click on the “Header & Footer” button. It will activate the Header & Footer toolbar.
- Click on the “Header” or “Footer” section in the toolbar, depending on where you want the watermark to appear.
- Once you are satisfied with the watermark, click on the “Close Header and Footer” button in the toolbar to exit the Header & Footer editing mode.
Method 2: Use Word Art to Add Watermark
Another method to add a watermark in Excel is using Word Art, which allows you to create customized text with various styles and effects. Follow these steps:
- Open the Excel sheet where you want to insert the watermark.
- Go to the “Insert” tab in the Excel ribbon.
- Look for the “Text” group and click the “Word Art” button. A dropdown menu will appear with various Word Art styles.
- Choose a Word Art style that suits your watermark design. A text box will appear on your Excel sheet.5. Tap in the text box and enter the desired text for your watermark.
- Tap in the text box and enter the desired text for your watermark.
- Customize the watermark’s appearance by selecting the text box and using the formatting options in the “Format” tab.
- Adjust the font, size, colour, effects, and other formatting settings to create the desired watermark effect.
- Position the watermark by dragging the text box to the desired location on the sheet. You can also modify and rotate the text box if necessary.
- Once satisfied with the watermark, you can refine it by right-clicking on the text box and selecting “Format Text Effects.” It will allow you to apply additional effects such as shadows, reflections, or 3D formatting.
- Finally, save your Excel sheet to ensure the watermark is retained when reopening the file.
Also Learn: How to Remove Leading Zero in Excel
How to Remove Watermarks in Excel?
Method 1: Delete Watermark from Excel Sheet Using the “Delete Background” Command
The “Delete Background” command is a simple yet effective way to remove watermarks from an Excel sheet. Follow these steps to remove a watermark using this method:
- Open the Excel sheet containing the watermark.
- Go to the “Page Layout” tab in the Excel ribbon.
- Look for the “Page Setup” group and click the “Background” button. A dropdown menu will appear.
- From the dropdown menu, select the “Delete Background” option. It will remove the watermark from your Excel sheet.
Method 2: Remove Watermark From Excel Sheet Using the “Go To Special” Feature
The “Go To Special” feature in Excel allows you to select specific elements in a worksheet. This feature lets you easily remove watermarks from your Excel sheet. Here’s how:
- Open the Excel sheet with the watermark.
- Press the “Ctrl + G” shortcut key combination to open the “Go To” dialog box.
- Press the “Special” button in the “Go To” dialog box. Another dialog box will appear.
- In the “Go To Special” dialog box, select the “Objects” option and click “OK.” It will select all the objects in your worksheet, including the watermark.
- Choose the “Delete” key on your keyboard to eliminate the selected watermark from the Excel sheet.
Method 3: Remove Watermark from Excel Sheet with Header & Footer Feature
The Header & Footer feature in Excel allows you to add and edit headers and footers in your worksheets. You can use this feature to remove watermarks as well. Follow these steps:
- Open the Excel sheet containing the watermark.
- Go to the “Insert” tab in the Excel ribbon.
- Look for the “Text” group and click on the “Header & Footer” button. It will activate the Header & Footer toolbar.
- Click on the “Header” or “Footer” section in the toolbar, depending on where the watermark is located.
- Select and delete the watermark text or image in the Header or Footer section.
- Click on the “Close Header and Footer” button in the toolbar to exit the Header & Footer editing mode.
Also Learn: How to Remove Duplicates in Excel
Conclusion
Choose the procedures that suit your requirements and follow the step-by-step instructions to remove the watermark from your Excel sheet. By mastering these techniques, you can easily add or remove watermarks as required in your Excel documents.
