Excel Watermark Step-By-Step Tutorial

Excel does not include a true watermark feature, but you can insert an image file into a header or footer to approximate a visible watermark. In visible watermarking, the information is typically text or a logo that identifies the owner or marks the media in some way.

of 03

Page Layout View

100% Satisfaction Guaranteed Badges black and white vector icon set
Badges that can be used as watermarks.


bubaone/Getty Images

Up to three headers and three footers can be added to a page using the header and footer boxes that become visible in Page Layout view.

of 03

Basic Steps

Insert a watermark by:

  1. Click the Insert tab of the ribbon.
  2. Click the Header & Footer icon toward the right end of the ribbon, Clicking on this icon switches Excel to Page Layout view and opens a new tab on the ribbon called Header & Footer Tools/
  3. On this new tab click the picture icon to open the Insert Picture dialog box.
  4. In the dialog box, browse to find the image file that will be inserted into the header. Click the image file to highlight it, then click the Insert button to insert the image and close the dialog box.
  5. The watermark image is not immediately visible but a &[Picture} code should appear in the center header box of the worksheet.
  6. Click any cell in the worksheet to leave the Header box area.
  7. The watermark image should appear near the top of the worksheet.
of 03

Removing the Watermark

To remove a watermark entirely:

  1. If necessary, click the Header & Footer icon on the Insert tab to enter Page Layout view.
  2. Click the center header box to select it.
  3. Press the Delete or Backspace key on the keyboard to remove the &[Picture} code.
  4. Click any cell in the worksheet to leave the Header box area.