See all How-To Articles

How to Add / Insert a Watermark in Excel

This tutorial demonstrates how to add a watermark in Excel.

 

add insert watermark 12

 

Add Image As Watermark

There are several ways to secure your spreadsheets in digital form, but when it comes to printing them on paper, the best way to mark and control them is to add a watermark. In Excel, there is no built-in watermark feature, but you can use a workaround and insert it as a picture.

1. First, in the Ribbon, go to the View tab and select Page Layout.

 

add insert watermark 1

 

2. Click within any of the three boxes in the header where you want to place your watermark (here, the second one, because the chosen placement of the watermark is in the center of the spreadsheet).
Then, in the Ribbon, go to the Design tab and choose Picture.

 

add insert watermark 2

 

3. The Insert Pictures window will open. In it choose the location of the image file (in this example From a file) and click on it.

 

add insert watermark 3

 

4. Now select the image you want, and click Insert.

 

add insert watermark 4

 

5. As a result, the picture is added to the selected header box.

 

add insert watermark 5

 

6. To make the right placement of the picture on the spreadsheet, manually adjust it by pressing Enter to lower the position of the picture. To be able to see a picture on the spreadsheet just click any cell in the worksheet.

 

add insert watermark 6

 

Modify Picture Inserted As Watermark

To make your picture look more like a watermark, you can easily edit it.

1. If the picture is too big or too small for the spreadsheet you can easily resize it to fit. In the Ribbon, go to Design and click on Format Picture.

 

add insert watermark 7

 

2. After that, the Format Picture window will open. Click on Size and in the Size and rotate section choose the wanted measurements.

 

add insert watermark 8

 

3. In the same Format Picture window you can adjust the transparency of the picture. To do that (1) click on the Picture, under the Image control section, (2) click on the box next to the Color, and from the drop-down menu (3) choose Washout. When done, (4) press OK.

 

add insert watermark 9

 

As a result, the picture is added as a watermark in Excel.

 

add insert watermark 10

 

Add Watermark Using WordArt in Excel

Another way to add a watermark to your spreadsheet is to insert a WordArt object, but you can only use this option for text-based watermarks. To add it just follow these steps:

1. First, in the Ribbon, go to Insert and click on WordArt.

 

add insert watermark 13

 

2. After that, the text box will appear on your spreadsheet. Just enter your text in it.

 

add insert watermark 14

 

To format your text and make it look like a watermark, in the Ribbon go to Format, and in the WordArt Styles group click on the Format Text Effects: Text Box icon (pointed down arrow in the bottom right corner).

 

add insert watermark 15

 

After that, the Format Text Effect task pane will appear on the right side of the workbook. To make watermark text more transparent click on the Text Options, then click on the Text fill and outline icon, and under the color section set the Transparency on wanted percent.

 

add insert watermark 16

 

To change the dimensions of the text box, in the Ribbon go to Format, and in Size group click on the Size and properties icon (pointed down arrow in the bottom right corner).

 

add insert watermark 17

 

If you need your text box to be with precise dimensions, in the Format Text Effect task pane click on Shape Options, then click on the Size and Properties icon, and under Size section enter correct dimensions for your spreadsheet.

 

add insert watermark 18

 

You can also resize your text box directly in a spreadsheet by using the resize handle.

 

add insert watermark 20

 

To make watermark text larger, select it and right-click it, and in the Font size box enter the wanted value.

 

add insert watermark 19

 

To change the text orientation, the easiest way to do that is by using the rotation handle.

 

add insert watermark 20

 

As a result of previous steps, the watermark is added to the spreadsheet with the wanted size, transparency, and orientation.

 

add insert watermark 21