Hello Geeky, so today we are focusing on How to Add Watermark to Excel 2010 or 2013 Worksheet. So please read this tutorial carefully so you may comprehend it in a better helpful way.
Guide: How to Add Watermark to Excel 2010 or 2013 Worksheet
Before sharing an Excel spreadsheet with others, you may want to have a watermark (such as your company logo or an image). If you are sharing a WIP (advanced service) version of the report, you may want to use the WIP / Draft symbol. While Excel does not specialize feature for adding markers, it is easy to do by using the Header and Foot sections. In this article, I will teach you how to quickly place a watermark in Excel, as well how to resize, resize, and remove a pre-installed watermark.
“How can I apply a watermark to Excel?” is a common question. If you’ve ever seen printouts with these words “Privacy,” “Privacy,” or “Privacy” is lowered across the page at an angle of 45 degrees, you know what I’m talking about. “The Watermark service is no longer valid in Microsoft Excel,” according to Microsoft’s official website, although it may mimic a watermark.
How to Watermark worksheet in Excel 2010
- Open the worksheet on which you want to add a watermark, click the Insert tab from Ribbon. then Header and Foot.
- Under Header and Foot Tools, select Design and click Image from header and footer elements.
- Browse the image you want to use as your watermark. Note that after you add an image in the header field, it will show you &[Picture] in the tab but do not worry. Clicking on any other cell will convert this text to the image. If you want it to appear in the middle of the sheet, just press enter before &[Picture] like and move to where you want the header to appear.
Using WordArt as a Watermark in Excel 2010
You can also use WordArt as a watermark on your Excel 2010. Click Insert >> WordArt. Select the format you want to use and enter 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 can make it difficult for the user to read the workbook. Click the format under Design Tools.
- Click the small arrow under WordArt styles to open the WordArt options.
- From there, select Fill Text from the sidebar and select Fill Solid. From here, adjust the transparency to something better and click OK. In this way, we can change the appearance of the watermark so that it does not cover the text in the worksheet.
- Now go to Text Outline and select line.
How to Add Watermark in Excel 2013
Most of the steps are the same for Excel 2013 as they were in Excel 2010. The biggest difference is the configuration of Excel.
- Just go to Insert >> Header and Foot.
- Click the Image 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 that image as a watermark.
Using WordArt as a Watermark in Excel 2013
Initially, it may be difficult to find the WordArt option in Excel 2013 but it is still in the same tab as it is in Excel 2010. Go to Insert and under the Text tab, click on the WordArt icon as shown below and select an item you want.
- Click the same arrow under WordArt styles to open the reading option.
- A new sidebar will appear. From there, click on Text Options and open Text Fill and Advanced Options.
- Select Fill Solid under Text Add and No Line under Word Process. Select transparency to whatever you want and close the menu.
Customizing Image Watermark
You can even customize the look of the image. From the Design tab, click on Format Image. From here, you can change the size and shape of the image. Click the Image tab and select the settings according to your preferences. I suggest using Washout feature from the drop down menu under Image Control as it makes your thumbnails smoother and easier for the user to read content in the worksheet.
The compress option allows users to change the resolution and image size. If you cut any part of the water mark from the settings, you can use the compress option to delete the cut areas or even just compress the image for easy use. However, note that image compression may reduce the quality of the water mark. If you are comfortable with it, click Apply otherwise leave it as it is. The steps to customize the liquid are the same for both Excel 2010 and Excel 2013.
Guide about How to Add Watermark to Excel 2010 or 2013 Worksheet
In this guide, we told you about the How to Add Watermark to Excel 2010 or 2013 Worksheet; please read all steps above so that you understand How to Add Watermark to Excel 2010 or 2013 Worksheet in case if you need any assistance from us, then contact us.
How this tutorial or guide assisting you?
So in this guide, we discuss the How to Add Watermark to Excel 2010 or 2013 Worksheet, which undoubtedly benefits you.
I hope you like the guide How to Add Watermark to Excel 2010 or 2013 Worksheet. In case if you have any queries regards this article/tutorial you may ask us. Also, please share your love by sharing this article with your friends and family.