How to Insert Watermark in Excel

In this article we will learn how to insert watermark in Microsoft Excel 2010.

Excel watermark is a common way of identifying files belonging to the creator and protecting them from unauthorized use.  When you put a watermark such as the company name behind the data, it cannot be re-used by another company or plagiarized.

We can create a watermark and display it behind the data in financial statements, Salary Slip report etc.

Let’s take an example and understand how we can create a watermark behind the data in Excel.

Considering that we want to create a watermark on excel for a financial statement.

How to add watermark in Excel?

Follow the below given steps:-

    • Open your Excel workbook where you want to insert the watermark behind the text.
    • Go to the “Insert” tab.
    • Select “Word Art” from the Text group and type “Statement”.

img1

img2

    • Copy the “Word Art” by pressing the key “CTRL+C” and paste into “Paint” and save the picture.

img3

    • In the “Text” group, select “Header and Footer”.

img4

    • Header- You can select either center, left or right.

img5

  • Click on the Picture in the Design contextual tab.
  • Click on browse.
  • Insert the picture from the desktop or the location where you saved the paint file.
  • Click on Ok.

img6

The watermark is inserted behind the text in your file. It will now appear for each sheet in your workbook.

How to remove watermark in Excel ?

Sometimes if we are working with company specific data or if we are creating templates which we do not want to be copied by others and re-used, then we can use this watermark option. However, sometimes, it could be disrupting the normal viewing of the file or it needs to be altered. Then you can use this option to delete the watermark and use a new one as required.

Follow the below given steps:-

    • Select the worksheet(s) which has a watermark.
    • Click on the “Header” at the top of the page.

img7

    • Press the key “Delete” and then click anywhere on the sheet.

img8

  • For a normal view of the sheet, click on the “VIEW” tab.
  • In the “Workbook Views” group, click on “Normal”.

img9

Or you can click on this icon -

img10

which is the first icon in the right most lower corner of the excel window. There are 3 icons there and this is the 1st.
So this is how we can easily insert and remove a watermark in an excel sheet.

Users are saying about us...

  1. "I followed istructions, I prepared the wordart, I coose colors and lines, sent it to back but I am always able to catch it by clicking with the mouse on it. Is it correct or is it possible to send the object in a position where it is not so easy to click and edit it?
    thank you"

  2. "Bill, I appreciate your advice and followed it. However, when I clicked on ""Objects"", the program responded ""No objects found."" Perhaps the giant ""Page 1"" is something other than a watermark? It just looks like a watermark in that it covers many cells as a medium grey background.I have tried clicking on the area to capture the image, but no response from the program.Any other suggestions?
    Cordially,
    Russ"

  3. "Seone,
    You solved it! The way to correct it was to click on the ""Normal"" view to take it out of the print mode.
    Thank you. Cordially,
    Russ Andrea,
    It appears that the answer to your suggestion is ""no.""Sembra che la risposta al suo suggerimento è ""No.""If you can put an object into Excel, you can retrieve it. Se lei può mettere un oggetto in Excel, lei lo può ricuperare. My problem was that I did not realize that I was not working with an object (not even a watermark). Il mio problema era che non ho realizzato che non lavorassi con un oggetto (neanche un filigrana).
    Thank you for your suggestion. Ringraziarlo per il suo suggerimento.I believe that since you took the time to reply in English, I should respond in Italian. Credo che poiché lei ha portato il tempo a rispondere in Inglese, dovrei rispondere nell'italiano.
    Cordialmente, Russ
    "

  4. Is it possible to use a company logo as a watermark. I received recently the tip with regards to using a WORDART format and making TEXT into a watermark. My question is that I have a JPEG company LOGO that I normally use as a watermark in a word doc - my question is if I could do the same within EXCEL, so that I have the same or similar logo WATERMARK on all my documentation?

  5. After the watermark has been placed, right click the mouse to get the Format WordArt panel, on the protection tab check the protection locked is checked. Press OK to accept. Return to the worksheet and if editing the cells is to be allowed select the entire sheet. Go into Format Cells and again the protection tab, this time ensure the Locked box is unchecked. Press OK to accept. Finally go to Tools, Protection, Protect worksheet to set up the protection. This now allows normal use of the cells but does not allow access to the watermark.

  6. I cannot get the Wordart (watermark) to go behind worksheet data. I've tried to change the order "send to back" but nothing happens. What am I doing wrong?

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube