Add watermark to Excel worksheets

The Watermark add-in for Excel makes the process of inserting text and picture watermarks to your spreadsheets really simple and straightforward. Here you will find the instructions on how to create, add, edit, and remove watermarks in your Excel files.

How to use the Watermark tool

Start the tool

Run the add-in by clicking the Watermarks icon in the Manage group on the Ablebits Data tab:
Run the Watermarks tool by clicking on its icon.

Insert default watermarks

Once the add-in is running, you will see its pane with several pre-defined watermarks: Confidential, Do not copy, Draft, and Sample:
The add-in offers four most commonly used pre-defined watermarks.

First two are picture-watermarks, while the last two are textual. You can expand the group with any existing mark, edit the way it looks, and press the Insert button to place it into your sheet.

Create and insert custom watermark

You can also create a watermark in Excel from scratch:

  1. Click on the New watermark icon and choose to create either New text watermark or New picture watermark. Once picked, it will appear as another group at the bottom of the list of marks on the add-in pane.
  2. Specify a name for the new item in the Watermark name field:
    Insert the name and fine-tune the options of the new watermark.
  3. Configure the settings of the new mark:
    • If you choose to create a text watermark, enter your text in the specified field and define its font, size, and color. Check the Diagonal box to place your watermark text across the page.
    • If you decide to add a picture watermark, click Browse to find the necessary image on your PC. Tick the Transparent checkbox if you want to make your watermark less noticeable.

Once the watermark is chosen and its settings are adjusted, press the Insert button to add it to your Excel file.

Tip. Your newly-inserted watermark will be automatically saved in the list on the add-in pane.

How to work with watermarks

Edit your watermarks

You can easily edit a watermark by expanding it in the list and changing its settings.

Depending on the type of the watermark - picture or textual - you will be offered to edit different settings:

  • If you choose to modify default picture-watermarks, you'll be able to select other images for them. Also, you can make the mark transparent, if you need.
    Note. If you change the picture in a default watermark, the name of the default watermark will be changed into the name of the image.
  • If you decide to change textual watermark, you'll be offered to enter its name, text to display, pick a font, its size, and color. Also, you can place it diagonally, if you want.

Remove your watermarks

You can remove watermark from the list using the Delete icon at the top of the pane.

To erase it from your Excel file, click the Remove watermark button at the bottom of the pane.

Responses

Hello.

I've inserted a watermark, but cannot manipulate where it appears on the page. I would like it to appear diagonally, which it does, but it is not centered on the page. How do I alter the location of the watermark?

Thank you.

Reply

Hello Risa,
Thank you for the comment.
I am afraid, you can't alter the location of the watermark. However, you can choose it to be diagonal or horizontal by checking or unchecking the corresponding box. I am sorry I can not assist you better.

Reply

Ask a question (posted publicly)

If you have any questions or issues with this add-in, please feel free to post your concerns in the comments area. As soon as we answer, a notification message will be sent to your e-mail. If you do not want to share your thoughts in public, please contact us at support@ablebits.com.
Privacy policy Terms of use Contact us

Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.