A Simple Method for Adding Watermark to Excel for All Spreadsheets in No Time

Watermarking in Excel is a great way to mark your ownership and protect the content on your Excel spreadsheets. If you're unsure how to do it, you can follow the steps outlined in this article.

0
255

Inserting Watermark into Excel simply means inserting a logo into the worksheets in an Excel file. This is done to assert the author’s ownership rights to the data file and prevent others from copying or using it for personal purposes. This article will guide you from A to Z on how to insert Watermark into Excel, so let’s get started.

What is Watermark? Why do we need to insert Watermark into Excel?

A Watermark is a form of faint stamp on text, images to protect copyright, author’s rights to prevent copying from competitors or anyone else. These marks often include logos, text, phone numbers, author names,…

Similar to inserting Watermark into Word and inserting Watermark into PowerPoint, you can totally insert Watermark into an Excel file. The purpose of this is to:

  • Avoid situations where documents are copied or copyrighted: When the logo is inserted under the content of the document, it is difficult to remove them without the original Excel file.

How to insert Watermark into Excel (Figure 1)

  • Make Excel files more professional: For important documents, inserting logos into Excel also shows the author’s professionalism, making the Excel file more attractive.
  • Let readers know who the author is: If you insert Watermark in the form of your name, logo into the Excel file, when someone views the Excel file, they will know who the author is or which business or organization the file belongs to.

How to insert Watermark into Excel

There are many types of Watermarks that are often inserted into Excel, such as logos, images, text. Here are specific steps for each method.

1. Inserting Watermark into Excel as a logo, image

Inserting Watermark in the form of a logo, image is the most common method. The steps are as follows:

Step 1: Open the Excel file you want to insert Watermark into > Select tab Insert > Click on Select Text > Select Header & Footer.

How to insert Watermark into Excel (Figure 2)

Step 2: Select tab Design > Select Picture.

How to insert Watermark into Excel (Figure 3)

Step 3: The Insert Pictures dialog box appears, you select where to upload the image from From a file, Bing Image Search or OneDrive. In this example, I choose From a file to upload a pre-existing image from my computer.

How to insert Watermark into Excel (Figure 4)

Step 4: Select the image you want to insert as a Watermark > Press Insert to insert the watermark image into Excel.

How to insert Watermark into Excel (Figure 5)

Step 5: After the image is inserted, the content [Picture] will appear in the Header section. You click on any cell in Excel to display the inserted image.

The result is as follows:

How to insert Watermark into Excel (Figure 6)

Step 6: The logo color is too dark, and the next step is to make it fade by clicking on the Header section containing the name of the image you just inserted > Select tab Design > Format Picture.

How to insert Watermark into Excel (Figure 7)

Step 7: In the Format Picture dialog box > You select the Picture tab > In the Color section, you choose Washout > OK to fade the image logo in the Excel file.

How to insert Watermark into Excel (Figure 8)

The result is as follows:

How to insert Watermark into Excel (Figure 9)

Step 8: If the logo size is larger than desired, you can edit it by selecting the Size tab in the Format Picture dialog box > In the Scalesection, you can increase or decrease the width and height of the image > OK to finish.

How to insert Watermark into Excel (Figure 10)

The result is as follows:

How to insert Watermark into Excel (Figure 11)

Step 9: If you find that the logo position is not correct, you can change it by placing the mouse pointer in the &Picture section > Press Enter and Space to move to the desired position.

How to insert Watermark into Excel (Figure 12)

After editing, you click on any cell to finish editing. The result is as follows:

How to insert Watermark into Excel (Figure 13)

2. Inserting Watermark into Excel as text

If you don’t have a logo image, you can also insert Watermark as text using the following instructions:

Step 1: Open the Excel file you want to insert a watermark into > Select tab Insert on the Menu bar > Click on Text > Select Header & Footer.

How to insert Watermark into Excel (Figure 14)

Step 2: In the Header section, you enter the desired text content into one of the three boxes.

How to insert Watermark into Excel (Figure 15)

Step 3: To edit the color, font style for the watermark, you select and highlight the entered content > Select the Home tab, then choose the appropriate color, font style, and size.

How to insert Watermark into Excel (Figure 17)

Step 4: To edit the position of the Watermark, you place the mouse pointer at the beginning of the entered text > Press Enter and Space to adjust to the appropriate position. Then, click on any cell and the result is as follows:

How to insert Watermark into Excel (Figure 18)

How to remove Watermark in Excel

If you want to remove a Watermark that has been inserted into Excel, follow these steps:

Step 1: Open the Excel file with the Watermark you want to remove > Select tab Insert > Select Text > Select Header & Footer.

How to insert Watermark into Excel (Figure 19)

Step 2: Click and highlight the content in the cell containing the watermark, then press the Backspace key on the keyboard to delete the watermark, and click outside any cell to finish editing.

How to insert Watermark into Excel (Figure 20)

Conclusion

The article has guided you on how to insert Watermark into Excel in the form of image logos or text. Each step has illustrated examples. Wish you success in performing these tasks.

You may also like

5 Essential Excel Functions for Beginners

Master the fundamentals of Excel with these 5 basic functions! Learn how to use SUM, AVERAGE, COUNT, MIN, and MAX in order to make calculating and analyzing data easier and more efficient.

How to recover unsaved or overwritten Excel files effectively: a sure-fire method

Knowing how to recover unsaved Excel files can be extremely helpful in cases when your computer unexpectedly shuts down or you accidentally click on “Don’t save” when Excel asks if you want to save your changes before closing. Follow this article to learn the step-by-step process of how to accomplish it.

5+ Effective Ways to Convert PDF to Excel Quickly, Useful Office Tricks

Knowing the ways to convert PDF files to Excel below will enable you to easily edit and add content inside. Office workers and students definitely must know this trick if they want to simplify their tasks.

Share 12 Simple Yet Unknown Ways to Calculate Sum in Excel

Knowing how to calculate sums in Excel is the most basic thing that any Excel user can do. But there are many different ways to calculate sums in Excel that not everyone knows. So let’s find out together with FPT Shop.