How to Insert a Watermark in Excel (a Step-by-step Guide)

Watch Video – How to Insert Watermark in Excel

In many situations, you may want to insert watermark in Excel (such as your company’s logo or an image) before sharing it with others. In case you are sharing a WIP (work-in-progress) version of the report, you may want to place a WIP/Draft as the watermark in it.

While Excel does not have a dedicated feature to insert watermark in Excel, it can be easily achieved by using the Header & Footer sections in Excel.

How to Insert a Watermark in Excel Worksheets

In this tutorial, I will show you:

  • How to Insert Watermark in Excel Worksheets?
  • How to Reposition the Watermark in Excel?
  • How to Resize the Watermark in Excel?
  • How to Delete the Watermark in Excel?

How to Insert Watermark in Excel Worksheets

Here are the steps to insert a watermark in Excel Worksheet:

  1. Go to Insert –> Text –> Header & Footer
    • This changes the Worksheet View to Page Layout and you would be able to see 3 boxes at the top of the worksheet.

How to Insert Watermark in Excel Worksheets - Header and Footer

  1. Click within any of the three boxes where you want to insert the watermark. For example. select the middle one if you want to insert watermark at the center.
    • When you click on any of the boxes, it also displays the Design option (in the ribbon) in the Header & Footer Tools tab

How to Insert Watermark in Excel Worksheets - Header and Footer boxes

  1. Go to Header & Footer Tools Design and click on Picture. This opens the Insert Picture Dialogue Box.

How to Insert Watermark in Excel Worksheets - Picture

  1. Locate the image file and double-click on it to insert in the header.
  2. Note that this does not display the picture, but a code &[Picture].How to Create a Drop Down List in Excel - &Picture
  3. Click on any cell in the worksheet, you will be able to see the watermark.How to Insert Watermark in Excel - Amazon Watermark
  4. That’s it!! You have the watermark inserted.

When you have inserted the watermark, excel remains in the Page Layout view. You can go to the normal view by going to View –> Workbook Views –> Normal.

How to Insert Watermark in Excel - Normal View

Once you are in normal view mode, you will not see the watermark, but it is still there and can be viewed by going to the Page Layout Mode. It would also be printed when you print the worksheet.

Note: The header has 3 boxes where you can insert watermark in Excel. You can not insert more than one watermark per section. If you try to insert more than one watermark, it will show an error (as shown below):

How to Insert Watermark in Excel - One Watermark Error

Re-positioning the Watermark

If you want to change the position of the watermark (say you want to push it downwards), just add some blank lines before the code &[Picture]. To enter blank lines, place the cursor at the beginning of the code as hit enter. Add multiple blank lines to push the watermark down.

How to Insert Watermark in Excel - Line breaks

If you want to show the DRAFT watermark at the center of the page, just enter enough line breaks to push it down to the center.

Resizing the Watermark

Once you insert water in Excel, the picture dimensions (height/width) are that of the original picture.

Once inserted, you can easily resize the watermark by following the below steps:

  • Go to Insert –> Text –> Header & Footer.
    • This changes the Worksheet View to Page Layout and you would be able to see 3 boxes at the top of the worksheet. In the box where you have inserted the watermark, you will see the code &[Picture]
  • Click on the box in which you want to resize the watermark.
  • Go to Header & Footer Tools –> Design –> Format Picture.
    • This will open the Format Picture dialogue box.How to Insert Watermark in Excel - Format Picture
  • Change the Height and Width of the watermark.How to Insert Watermark in Excel - hieght-width
  • Click OK.

Removing the Watermark

To remove the watermark in Excel, just remove the code &[Picture]. If you want to replace it with some other picture, just click on the header box (where you already have the code &[Picture]) and select Picture from the Design Tab.

NOTE: You can do the same thing by inserting a picture in the footer instead of the header. 

You May Also Like these Excel Tutorials:

  • sss says:

    very nice job

  • >