Mimic a watermark in Excel

Watermark functionality is not available in Microsoft Office Excel. If you want to display a graphic on every printed page (for example, to indicate that the information is confidential), you can insert the graphic in a header or footer. This way, the graphic appears behind the text, starting at the top or bottom of every page. You can also resize or scale the graphic to fill the page.

1. Click the worksheet that you want to display with a watermark. Make sure that only one worksheet is selected.
2. On the Insert tab, in the Text group, click Header & Footer.

   

3. Under Header, click in the Left section, Center section, or Right section box.
4. On the Design tab of the Header & Footer Tools, in the Header & Footer elements group, click Picture and then find the graphic that you want to insert.

   

5. Double-click the graphic to insert it in the header section box.
6. To resize or scale the graphic, click Format Picture in the Header & Footer elements group, and then, in the Format Picture dialog box, select the options that you want on the Size tab.

Notes:

• Changes to the graphic or graphic format take place immediately and can't be undone.

• If you want to add blank space above or below a graphic, click before or after &[Picture], and then press ENTER to start a new line.
• To replace a graphic, select &[Picture], click Insert Picture , and then click Replace.
• Before printing, make sure that the header or footer margin allows enough space for the custom header or footer.
• To delete a graphic, select &[Picture] and then press DELETE.

See also:

• Add or remove a sheet background