• 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.

    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:

    One Response

    1. Synkronizer January 14, 2019

    Leave a Reply

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