Unveiling Clarity: How to Remove Watermark in Excel in Seconds?

In MS Excel, we can easily insert a pivot table, add formulas to the spreadsheet, and calculate & organize data. Apart from that, we can use another excellent feature which is – “Watermark”. Excel allows users to add an image or text that seems on the background of their Excel document as a watermark. Well, in this inclusive blog, I will explore how to remove watermark in Excel with less effort.

Also, you will learn how to put the watermark in Excel and how to repair corrupt Excel documents using the best tool.

Quick Navigation:

Part 1- How to Remove Watermark from Excel Sheet?

Part 2- How to Remove a Watermark in Google Sheets?

Part 3- How to Add/Insert a Watermark in MS Excel?

Part 4- Repair Corrupt Excel File & Recover Its Components

How to Remove Watermark In Excel Sheet?

Follow the step-by-step methods to remove watermark Excel Office 365 or other Excel versions:

Method 1- How to Remove Page Watermark in Excel Background?

The very first option to delete watermark from Excel sheet is to use Delete Background command.

If you have inserted the watermark in the background as a picture and it is repeatedly displayed on every page, don’t worry. You can easily delete that by following the below steps:

Step 1- Initially, click on Page Layout tab in the Ribbon of your Excel sheet.

Step 2- Then, find & click on Delete Background.

After clicking that option, the watermark will be automatically removed from a background of the sheet.

Also Read: Quick Ways to Remove Blank Rows in Excel

Method 2- Use Go To Special Feature

Apart from the Delete Background command, you can use another effective feature of Excel which is- Go To Special. It is one of the most reliable functions that can be used to erase watermarks in MS Excel in a hassle-free manner.

Nevertheless, if you have inserted the watermark by using the WordArt, then you can use this feature to find & remove that watermark.

Here is how you can use Go To Special feature to do so:

Step 1- At first, switch to the Page Layout view in order to see the watermark, just click on View tab >> Page Layout option. (See the below screenshot):

Step 2- Next, go to the Home tab and click on Find & Select option.

Step 3- Then, click on Go To Special option. (See the below screenshot):

Step 4- Under the dialog box, check the Object option >> click OK button to close a dialog.

Step 5- After that, you can get the Art Word watermark that has been selected, then press a Delete button for removing the watermark.

Method 3- How to Remove Watermark in Excel Sheet with Header & Footer Feature?

Well, the above methods will only work if the watermark is added to the background of the sheet. However, if is not added in the background and is inserted as a header/footer, then you can remove that by using Header & Footer function.

Here is how you can use this function for deleting watermark:

• Firstly, click on Page Layout by tapping on View tab >> Page Layout.
• Next, click on the Insert tab then Header & Footer to display headers & footers. (See the below screenshot):

• There, you will see a text “&[Picture]” in a header & footer, you have to delete that text.
• Doing this will immediately remove the watermark of the entire Excel sheet. (See the below screenshot):

Also Read: How to Remove Scientific Notation in Excel?

How to Remove a Watermark in Google Sheets?

In this section, I will show you how to remove a watermark in Google Sheets with ease. To do so, follow the below instructions:

1- In the Google Sheets, select the object.

2- Next, click on the 3 dots menu in the upper-right side corner of an object to show the menu.

3- After that, choose the “Delete” button. This will delete the watermark from Google Sheets.

How to Add/Insert a Watermark in MS Excel?

Way 1- Add/Insert a Text Watermark Using Header & Footer

To insert text watermark using Header & Footer feature, follow these steps:

• Open the worksheet to insert a watermark.
• Then, click on Insert tab >>Text
• After this, click on Header & Footer.

• Next, click on a Header cell & enter the text you want to insert as a watermark.
• Now, click anywhere in a worksheet to see the watermark.

Way 2- Use Word Art to Add Watermark

Another effective way that you can try to add watermark in Excel is WordArt. Using this Excel function, you can easily insert a watermark as a text.

Here’s how you can do so:

• Open the worksheet.
• Next, click on Insert tab >>Text
• After that, click on WordArt.
• Now, choose a WordArt of your choice.

• Then, you have to enter the text you want to show as a watermark.
• In case, if you want to ‘rotate’ the word, you can easily do so.

Way 3- How to Add the Picture Watermark

If you want to add watermark as a picture, you can use the Header & Footer function in Microsoft Excel. Follow the below steps to do so:

• Open the Excel sheet to add a watermark.
• In the second step, click on Insert tab >>Text option
• After this, click on Header & Footer.

• Tap on Header cell & go to the Design then Header & Footer Elements.
• Under the Header & Footer group, click on a ‘Picture’.
• Now, the ‘Insert Pictures’ window will appear on your screen, browse for an image.
• Choose the image of your choice.
• At this time, you will see ‘&[Picture]’ in Header cell of your spreadsheet.

• Now, click anywhere in a Header cell to see the watermark on the background of your spreadsheet.

How to Repair Corrupt Excel File & Recover Its Components?

When the Excel document gets damaged it hampers the stuff contained in your spreadsheet. So, in such a situation, you can use the Excel Repair Tool to repair the corrupted Excel file and recover all its components.

This is an exceptional tool that can recover entire data from XLS/XLSX files including charts, cell comments, worksheet properties, etc. without any modification.

You can even try a free demo version of this software to know how it actually works.

Try Now       Buy Now

* Free version of the product only previews recoverable data.

Steps to Use Excel Recovery Tool:

Related FAQs:

Where is Watermark Option in Excel?

Well, you will not find the Watermark option directly in the Excel document. However, you can easily add it by navigating to Insert tab >> Text option > Header & Footer. Then, click on header, on the Header & Footer Elements tab, click Picture. After that, insert watermark as an image.

Is It Possible to Customize or Edit a Watermark in Excel?

Absolutely, you can customize or edit a watermark in Excel by navigating to a ‘Page Layout’ tab >> ‘Watermark,’ and then click on ‘Custom Watermark’ option. There, you can change the text, font, and size of the watermark.

How to Remove Page 1 Watermark from Excel Office 365?

You can remove page 1 watermark from Excel Office 365 by navigating to Page Layout tab >> in a Page Setup group, you have to click the Delete Background. But ensure that only 1 Excel worksheet is selected.

Why Remove Watermark?

Removing watermark essential for eliminating unwanted logos, marks, or images from the document.

Does Removing a Watermark in Excel Affect the Original Document?

No, removing a watermark in Excel does not affect the original document's content. Your data remains intact.

Is There a Shortcut to Quickly Remove a Watermark in Excel?

No, there is no any shortcut to remove a watermark in Excel.

Bottom Line

So, this is all about how to insert watermark in Excel and how to remove page 1 watermark in Excel sheet. However, the steps mentioned above are easy to follow. For further queries related to the topic, feel free to contact us on our official Facebook and Twitter pages.

Thanks for reading!