Recently, We show you how to add a watermark to a document in Word 2013. Also you can add a watermark to worksheets in Excel 2013; despite this, you have to add them manually via header and footer tools. We will show you how.
Open your worksheet in Excel and click the Insert tab on the ribbon.
In the Text section, click Header & Footer.
NOTE: If your Excel window is smaller, the Text section could be condensed into a dropdown button. If that's the case, click the Text button and select Header & Footer in the Text section that is displayed.
The Header & Footer Tools Design tab appears. To insert an image as a watermark, click Image in Header & Footer Items section.
The Insert Pictures dialog box appears. Select the location where the desired image file is located. We select an image from our hard drive, so we clicked Browse next to From a file.
Navigate to the location of your image file, select it and click Insert.
While the header is still open, the image is represented by “&[Picture]”. Depending on the size of the image, you can insert blank lines before and[Picture] to center the image in the worksheet.
To see the image behind the file content, click any cell outside the header. You will notice that the image is displayed behind the text and graphics in your file, but it is full color and possibly very dark.
You can make the image look faded easily. Open the header again to show the Header & Footer Tools Design tab again. Click Image Format in the Header and Footer Items section.
Click the Image tab in the Image Format dialog box and select Wash from the Color drop-down list. Click ok.
Image fades behind text and graphics.
You can also use text as a watermark by entering the text in the header (preceded by blank lines, to center the text in the worksheet), selecting the text and filling it with a light gray.
To remove the watermark, just open the header again, select text or image marker (&[Picture]), delete it and click any cell outside the header to save your change.
