Adding watermarks to workbook
![Watermark in Excel 2016 Watermark in Excel 2016](/images/tips/309/1.png)
To add a watermark, follow these steps:
1. On the View tab, in the Workbook Views group, click Page Layout:
![Page Layout view in Excel 2016 Page Layout view in Excel 2016](/images/tips/excel_button2016/page_layout_view.png)
2. Click the center section of the header:
![Click to add header in Excel 2016 Click to add header in Excel 2016](/images/tips/309_2016/2.png)
3. Under Header & Footer Tools, on the Design tab, in the Header & Footer Elements group, click Picture:
![Header and Footer Elements group in Excel 2016 Header and Footer Elements group in Excel 2016](/images/tips/309_2016/3.png)
4. In the Insert Pictures dialog box, choose the picture you want to become a watermark.
5. Click outside the header to see your watermark.
Notes:
- 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:
- Click the center section of the header.
- Under Header & Footer Tools, on the Design tab, in the Header &
Footer Elements group, click Format Picture:
- In the Format Picture dialog box, you can do additional changes:
See also this tip in French: Comment ajouter des filigranes au classeur.