Earlier, we showed you how to add watermark to worksheets in Microsoft Excel 2007. Microsoft Word 2013 has an easy default watermark option, but in Excel 2013 you need to add watermarks using the header and footer option. Here how in Excel 2010 or 2013.
How to Watermark Worksheet in Excel 2010
Open the worksheet on which you want to add watermark, click the Insert tab from the Ribbon. then Header and Footer.
Under Header and Footer tools, select Design and click on Picture from Header and Footer elements.
Browse the image you want to use as your watermark. Note that after you add the picture in the header field, it will show you &[Picture] in the tab but don’t worry clicking on any other cell will change this text back to image. If you want to make it appear in the middle of the sheet, just hit enter before the &[Picture] like and move it to the place where you want to header to appear.
Using WordArt as Watermark in Excel 2010
You can also use WordArt as watermark on your Excel 2010. Click on Insert >> WordArt. Select the format you want to use and type the text.
From the small text editor shortcut that appears, you can change the size of the font you want to use.
But using this WordArt may makes it difficult for the user to read the worksheet. Click on Format under Design Tools.
Click on the small arrow under WordArt styles to open WordArt options.
From there, select Text Fill from the sidebar and select Solid Fill. From here, also adjust the transparency to something suitable and click Ok. This way, we can change the visibility of the watermark so that it does not cover the text in the worksheet.
Now go to Text Outline and select no line.
Here is how the WordArt watermark looks like. You can play around with the settings to get the result you want.
How to Add Watermark in Excel 2013
Most of the steps are same for Excel 2013 as they are in Excel 2010. The major difference is in the layout of Excel. Just go to Insert >> Header and Footer.
Click the Picture button from Header and Footer Elements.
In Excel 2013, you can use images from your computer and Office.com clip art or even search images from Bing search results and use the image as watermark.
Using WordArt as Watermark in Excel 2013
In start, you may find it difficult to find the WordArt option in Excel 2013 but it’s still present in the same tab as it is in Excel 2010. Go to Insert and under Text tab, click on the WordArt icon as shown below and select what you want.
Click on the same arrow under WordArt styles to open the Format option.
A new sidebar will appear. From there, click on Text options and open Text Fill and Outline options.
Select Solid Fill under Text Fill and No line under Text Outline. Select the transparency to whatever you want and close the menu.
And you are done.
Customizing Image Watermark
You can even customize the appearance of the picture. From Design tab, click on Format Picture.
From here, you can change the size and appearance of image. Click the Picture tab and select the settings according to your own preferences. I suggest using the Washout feature from the dropdown menu under Image Control as it makes the watermark fade out and it becomes easier for the user to read the content in the worksheet.
Compress option allows users to change the resolution and size of the picture. If you cropped out any part of the watermark from settings, you can use the compress option to delete cropped areas or even just compress the image for easy use.
However, do note that compressing the image may reduce the quality of the watermark. If you are fine with it, click Apply otherwise leave it as it is.
The steps to customize the watermark are same for both Excel 2010 and Excel 2013.