Just how to Add a Watermark to a Worksheet in Microsoft Excel 2013

Recently, we showed you exactly how to include a watermark to a record in Word 2013. You can additionally add a watermark to worksheets in Excel 2013; however, you must include them manually using the header as well as footer tools. We will certainly show you just how.

Open your worksheet in Excel and also click the Insert tab on the Ribbon.

In the Text area, click Header & Footer.

KEEP IN MIND: If your Excel home window is smaller, the Text section might be compressed to a drop-down switch. If that’s the situation, click the Text switch and also select Header & Footer from the Text section that drops down.

The Header & Footer Tools Design tab displays. To put a photo as the watermark, click Picture in the Header & Footer Elements section.

The Insert Pictures dialog box display screens. Select the area where the preferred image file is located. We picked a picture from our hard disk drive, so we clicked Browse next to From a documents.

Navigate to the area of your photo file, pick it, and click Insert.

While the header is still open, the photo is represented by “& [Picture]. Depending in the size of the image, you can place blank lines before & [Picture] to focus the photo on the worksheet.

To watch the image behind the materials of the documents, click on any cell beyond the header. You’ll notice that the photo displays behind the message and also graphics in your data, yet it is full shade and also perhaps extremely dark.

You can conveniently make the picture appear faded. Open up the header once again so the Header & Footer Tools Design tab presents once more. Click Format Picture in the Header & Footer Elements area.

Click the Picture tab on the Format Picture dialog box and also choose Washout from the Color drop-down list. Click OK.

The image comes to be discolored behind the message and also graphics.

You can additionally make use of message as a watermark by getting in the text in the header (come before by blank lines, to focus the message on the worksheet), choosing the text, and loading it with a light grey.

To remove the watermark, just open up the header once again, pick the message or the image marker (& [Photo], erase it, and click in any kind of cell outside the header to save your change.