To insert a watermark in Excel you need to use an alternative technique. This is because the tool does not have an integrated functionality for this task. This time I will show you how to use a text or an image as a watermark.
Text Watermark in Excel
Once you are on the sheet where you want to insert a text as a watermark you must click on the Insert tab. Then press the Header & Footer button which is inside the Text section.
For both, Header and Footer within the Excel sheet, a new area will be inserted. Within the Header enter the text you want to display as a watermark. Select the appropriate size of the font as well as its color.
Picture Watermark in Excel
We must use the same procedure explained in the Header of a sheet to place a picture as a watermark in Excel only that this time, we really going to insert an image instead of writing a text. Once we are ready to insert the Header we must go to the contextual tab Header and Footer Tools. Then in the Design section and press the Picture button.
A dialog box will be displayed that will allow us to search for the image that we want to insert. Then pressing the Insert button the text &[Picture] will be displayed as part of the Sheet Header.
To see the picture that you have inserted in the header, it is sufficient to click on any cell outside the Header. After that Excel will show the picture as a watermark.
If you want to move the image downwards you should follow the same technique shown above. You have to position the cursor at the beginning of the Header text, putting it before the & symbol. Then press the Enter key to move the image down.
If you need to change the size of the picture, that we just inserted as a watermark, do the following. Select the button Format the Picture found in the Header and Footer Elements section of the contextual toolbox Header and Footer Tools.
After that, to achieve the necessary adjustments, you will be able to experiment with the properties of the picture in the dialog box that appears.
I hope that this post helps you in your learning. If you have some suggestions, comments, etc, don’t hesitate to write us. You can learn more applications about the appearance here in Excel MOOC Formatting