Top Nav

How to Watermark Worksheets in Excel 2010 and 2013

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.

Watermark Excel

Under Header and Footer tools, select Design and click on Picture from Header and Footer elements.

Watermark Excel 1

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.

Watermark Excel 2

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.

Watermark Excel 10

Click the Picture button from Header and Footer Elements.

Watermark Excel 12

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.

Watermark Excel 13

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.

Watermark Excel 4

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.

Watermark Excel 5

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.

Watermark Excel 6

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.

Watermark Excel 7

The steps to customize the watermark are same for both Excel 2010 and Excel 2013.

Watermark Excel 9

 

, , ,

One Response to How to Watermark Worksheets in Excel 2010 and 2013

  1. Alan Wade December 1, 2012 at 8:49 am #

    Earlier, we showed users how to add watermark to worksheets in Microsoft Excel 2007. But unlike Microsoft Word 2013, there is no default watermark option present in Excel 2013.

    Maybe you need to edit the dates???

Leave a Reply

 

×

Black Friday Deals at Amazon.com. Now through November 28th. Shop Now