- Advertisment -
Home How To How to Insert watermark in Excel: Picture or Text

How to Insert watermark in Excel: Picture or Text

If you are dealing in documents or official papers then often you need a watermark on them. And generally, people don’t have the extensive knowledge of Ms-Word, Excel or powerpoint may struggle in inserting the Watermark.

- Ad-

Watermarks are generally a faded text or picture or logo behind the text typed or written on the paper. For example, the confidential word behind the secret documents of government or some business. Even the companies use Digital watermarks to videos and images files, to identify the copyright. However, nowadays, it is much easier than before to add the Watermark on paper by anyone with the help of office suites like Microsoft office.

So, without further ado, let’s see how to insert watermark in Microsoft Excel tutorial

  1. Open Microsoft Excel.
  2. Click on the Insert Tab.
  3. From the Insert option ribbon, click on the Text option which reveals further other options.
  4. From there select the Header & Footer.
  5. Now from the menu select the option Picture.
  6. A pop-up window will appear. Upload the picture that you want to insert as a watermark in Excel.
  7. You will see text &[picture] on the Header of the Excel sheet.
  8. Now click on anywhere on the sheet’s column outside the header area.
  9. A picture will automatically appear behind the text of the Excel sheet.
  10. To make it fade so it looks like a watermark. Click again on the header area and then Design Tab.
  11. From Design tab select the Format picture option.
  12. Select the Picture tab and then under Image control -> Color-> Click Drop down box-> Select the Washout and click OK button.
  13. That’s it you will see the washed picture watermark on your excel sheet.

Screenshots:

In the Excel to insert picture watermark click on the Insert Tab->Text-> Header & Footer

How to insert watermark in Excel 2016, 360, 2017, 2013

Under the Design tab, select the Picture.

insert picture watermark excel

We have three ways to upload pictures to Excel for setting Watermark: One is from the local hard drive, Bing Search engine and One Drive. We have the picture on our system, so we have selected the first option From a file- ‘Browse’.

Insert the picture

Again Click on the Header column on the &[Picture] and then Design-> Format Picture.

watermark picture in excel 2016

To change the Size of the Watermark, play with the Height and Width under Scale section.

format picutre

To blur or give washed out appearance to the Watermark simply click on the Picture Tab of Format picture and then click on the Drop down given in the front Color option and select the Washout and finally click on the OK button.

Fade out the watermark excel

Final output after washout watermark in Excel

Final output watermark Excel

How to insert watermark in Excel: Text

Inserting Text watermark is much simple then the Picture.

1. On the Excel, click on Insert Tab-> Text and select Word Art

insert text watermark Excel

2. Write the Text which you want to be used as Watermark and then right click on the Text’s outer area and select the Format Shape option.

Fade or wash out the watermark text

3. From Format Shape click on the Text options.

Text options

4. Now if your text has an outline then select the No Line option and then use the Transparency slider to adjust the lightness or fading of the Text. When you think the text looks alike a Watermark just leave it there and you will get the Text watermark on Excel.

watermark excel

Other Useful Resources:

Rajkumar Mauryahttp://www.how2shout.com
He’s always been passionate about technology and writing on the subject since 2014. He has a keen interest in all kinds of technologies, from consumer-tech to enterprise solutions. You can contact the author at-- raj@how2shout.com

1 COMMENT

  1. Hi Rajkumar,
    Nice Article. Thanks for sharing this informative and useful article on your blog. Keep sharing. Looking forward to the next post. Also, see out Excel file comparison tool Synkronizer

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.

- Advertisment -

Latest Posts

How to make Google Assistant read articles out for you

If you have got a lot of time or some free time in your hand, reading some articles can...

NAS vs. Cloud Storage- Which one to opt and when is what useful?

In the modern world, NAS and Cloud storage in broadway is the same thing, because the core function of...

5 Social Media Apps that your children should avoid

No doubt that social media is a very essential and must-have tool for almost each and every one of...

6 Best Open source Personal Cloud Software to Setup Cloud storage

The huge content creation of images, videos, documents and other files from different digital devices increases the demand for...
- Advertisement -

9 Best & Top Open source IoT Platforms To Develop the IOT Projects

The Internet of Things (IoT) is the future of technology that helps the Artificial intelligence (AI) to control and...

Technology in classrooms: What are the benefits of technology in the classroom?

Technology in classrooms is the most effective way in today's era to completely eradicate the ignorance from students life...

- Advertisment -
- Advertisement -

You might also likeRELATED
Recommended to you