How to Fix Watermark in Excel (2 Useful Methods)

If you are looking for how to fix a watermark in Excel, then you are in the right place. In our practical life, we often need to use Excel for different purposes whereas in most cases we need to deal with watermarks. Fixing the watermark includes adding, formatting, or removing the watermark. In this article, we’ll try to discuss how to fix watermarks in Excel.


Download Practice Workbook


2 Methods to Fix Watermark in Excel

We can add two types of watermarks.

  • Picture Watermark
  • Text Watermark

To show these types we have made a dataset named Dataset for Fixing Watermark. The dataset is like this.

how to fix watermark in excel

Let’s discuss the two types of watermarks in Excel.


1. Use Header & Footer Option to Fix Watermark in Excel

We can use the Header & Footer option to add or remove watermarks for both picture types and text types.


1.1 Adding Picture Watermark

We use a picture watermark when our Excel worksheet needs a representable picture as the background of the sheet. The steps to add a picture watermark are.

  • Firstly, go to Insert > select Text > choose Header & Footer.

how to fix watermark in excel, picture watermark

Eventually, a place for a watermark will appear.

  • Secondly, click on the watermark place > go to Header & Footer > select Picture.

how to fix watermark in excel, picture watermark

Immediately, an Insert Pictures window will appear.

  • Thirdly, click From a File and choose the desired picture from our database.

how to fix watermark in excel, picture watermark

Consequently, a picture watermark which we have chosen will be added.

how to fix watermark in excel, picture watermark

  • Fourthly, we need to place the watermark in the middle of our sheet.
  • Put the cursor on the left side of &[picture] and press ENTER. The watermark will go downwards with every clicking of ENTER.
  • Fifthly, continue to press ENTER until the watermark reaches the desired place.

how to fix watermark in excel, picture watermark

  • Sixthly, click the cursor on any cell of the sheet.
  • Finally, we’ll get the watermark at our desired place.

how to fix watermark in excel, picture watermark


1.2 Formatting Picture Watermark

After adding the picture watermark we need to format it to resize and recolor it.

  • Initially, put the cursor on the watermark cell > choose Header & Footer > select Format Picture.

how to fix watermark in excel, picture watermark

  • Eventually, a Format Picture window will appear.
  • Secondly, go to the Picture option > click on the options button in the Color box > pick Washout.

how to fix watermark in excel, picture watermark

  • Again, go to Size option > change the Height and Width to 3.34” and 3.34” respectively.
  • Thirdly, click OK.

how to fix watermark in excel, picture watermark

Consequently, we’ll see that our watermark is recolored and resized like the picture below.

how to fix watermark in excel, picture watermark


1.3 Removing Picture Watermark

We can follow some simple steps to remove the watermark which we have added through the Header & Footer option of the dataset below.

how to fix watermark in excel, picture watermark

  • Firstly, select the whole text of the watermark.
  • Secondly, press DELETE.

how to fix watermark in excel, picture watermark

Consequently, we’ll get our dataset without the watermark by removing it.

how to fix watermark in excel, picture watermark


1.4 Adding Text Watermark

Another type of watermark we can add through the Header & Footer option is the Text Watermark.

  • To add the text watermark, initially go to Insert > select Text > choose Header & Footer.

how to fix watermark in excel, text watermark

Eventually, the place for the watermark will appear.

how to fix watermark in excel, text watermark

  • Secondly, click on the watermark and write the text. Here, it is ExcelDemy.

how to fix watermark in excel, text watermark


1.5 Formatting and Removing Text Watermark

Additionally, we need to format the text watermark.

  • Firstly, select the text watermark, and eventually, the formatting options will appear.
  • Secondly, to change the size of the text, click on the size option > choose any size according to requirements. Here, we have selected 28.

 text watermark

  • Now, to change the color of the text, select the color option > choose any color from there.
  • Press CTRL + B or click on B to bold the text.
  • Press ENTER a couple of times by placing the cursor on the left side of the text to replace it.

text watermark

Finally, our text watermark will look like this.

text watermark

  • Additionally, to remove the watermark follow the same steps of Method 1.3 of Removing Picture Watermark.

2. Utilize WordArt Feature

We can use the WordArt feature when we need to add only text watermarks.


2.1 Adding and Formatting Watermark

  • To add this feature, initially go to Insert> click Text > choose WordArt > pick any text type from there.

how to fix watermark in excel, using WordArt feature

Eventually, the place for adding text will appear.

how to fix watermark in excel, using WordArt feature

  • Secondly, write the required text in the box. Here, we have written ExcelDemy.

how to fix watermark in excel, using WordArt feature

  • After writing the text we need to format and replace the watermark. We can follow the same steps of formatting which we have taken for Method 1.4 of Formatting and Removing Text Watermark.

Finally, we’ll get our text watermark like the picture below.

how to fix watermark in excel, using WordArt feature


2.2 Removing Watermark

The steps of removing WordArt featured watermarks are different from the removal of previous watermarks. We need to remove the watermark of the following dataset.

WordArt feature, removing watermark

  • Initially, press CTRL + G, and eventually a Go To window will open.
  • Secondly, click the Special

WordArt feature, removing watermark

  • A Go To Special window will appear.
  • Thirdly, select Objects and click OK.

WordArt feature, removing watermark

  • Consequently, an editable box will appear around the watermark.
  • Finally, click on the box and press DELETE or BACKSPACE the text, slide the box outside the dataset and click on any cell.

WordArt feature, removing watermark

Finally, the watermark will be removed from our dataset and we’ll get our original dataset.

WordArt feature, removing watermark


Things to Remember

  • To format the watermark created by the Header & Footer option, we need to click on the watermark first. Otherwise, the option of Header & Footer will not appear to continue the formatting.
  • We need to select any cell outside the dataset to activate the watermark after entering it in the case of Method 1.

Conclusion

We can fix any kind of watermark in Excel sheets efficiently if we study this article properly. Please feel free to visit our official Excel learning platform ExcelDemy for further queries.

Towhid

Towhid

Hello, myself Shajratul Alam Towhid. Basically, I am a Naval Architect who wants to expand knowledge in the field of Microsoft Excel. I wish all of my articles will be beneficial for the readers.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo