mopamerchant.blogg.se

However, sometimes, it could be disrupting the normal viewing of the file or it needs to be altered. 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.

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

Insert the picture from the desktop or the location where you saved the paint file.

Click on the Picture in the Design contextual tab.

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

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

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

Select “Word Art” from the Text group and type “Statement”.

Open your Excel workbook where you want to insert the watermark behind the text.

Let’s take an example and understand how we can create a watermark behind the data in Excel.Ĭonsidering that we want to create a watermark on excel for a financial statement. We can create a watermark and display it behind the data in financial statements, Salary Slip report etc.

When you put a watermark such as the company name behind the data, it cannot be re-used by another company or plagiarized. In this article we will learn how to insert watermark in Microsoft Excel 2010.Įxcel watermark is a common way of identifying files belonging to the creator and protecting them from unauthorized use.