Adding watermarks to workbook

Excel 2016 2013
This tip describes how to add watermark text or picture to your workbook.
Watermark in Excel 2010

To add a watermark, follow these steps:

   1.   On the View tab, in the Workbook Views group, click Page Layout:

Page Layout in Excel 2010

   2.   Click the center section of the header:

Click to add header in Excel 2010

   3.   Under Header & Footer Tools, on the Design tab, in the Header & Footer Elements group, click Picure:

Header and Footer Elements group in Excel 2010

   4.   In the Insert Pictures dialog box, choose the picture you want to add like a watermark.

   5.   Click outside the header to see your watermark.

Note:

  • To center the image in the middle of the page, click the center section of the header and add some carriage returns before the &[Picture] code.
    You'll need to experiment to determine the number of carriage returns required to push the image into the body of the worksheet.
  • If you need to adjust the image (for example, make it lighter), do the following:
    1. click the center section of the header
    2. under Header & Footer Tools, on the Design group, in the Header & Footer Elements group, click Format Picture:
      Header and Footer Elements group in Excel 2010
    3. In the Format Picture dialog box, make changes you want:
      Format Picture in Excel 2010

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.