How to insert a watermark in Excel
First things first – what is a watermark?
A watermark is a mark or a symbol embedded in an object to identify its ownership and authenticity 🤯
Typically, you can see this on hard copies of documents. Especially legal documents where validity and authenticity are always required.
But did you know that you can apply it as well to digital content? Not only Microsoft word documents but also Microsoft Excel documents and workbooks.
And it is a very easy thing to do 😁
But before we dive in, let’s start with the basics, shall we?
There are two types of Excel watermarks:
- Watermark image
- Watermark text
So what are their differences you ask 🧐
Watermark image is using a picture to embed a watermark on the worksheet.
Watermark text on the other hand is using words to create the watermark.
But enough of the terminologies and let’s head straight in!
Note that Excel has no dedicated or built-in watermark feature 😭
But the good news is that it can be achieved easily by using the Header & Footer menu in Excel!
Follow the below steps using the sample workbook provided:
- Note that clicking the Header & Footer will change the page layout view 🙀
But do not worry as it can be changed to a normal view once we are done.
Interesting isn’t it? Let’s try and add a watermark image first 😁
- You should be seeing three boxes in the Header section.
You may double-click any of those but for this exercise, let’s use the middle one
- Click Picture and select an image you want to use
Let’s choose from a file option as it is the most common method to get an image
- Once you have selected an image, Excel will read the picture as a code &[Picture]
You should have the same Header section box as mine now
- Click on any part of the worksheet to deselect the box
Doing so will apply the watermark in the Excel sheet 😊
Adjusting the watermark image in excel
We have successfully added the watermark image in Excel 🎉
But it looks kind of odd, isn’t it?
The good thing is we can adjust the image to our liking!
Let’s try adjusting the position of the watermark!
- Select the box where the image watermark is located
What if we want to resize the image?
- Click the header box where the picture is located. This is the same as the first step in adjusting the position of the watermarks.
- Under Header & Footer > Header & Footer elements, select Format Picture
You may now easily resize the watermark in Excel by adjusting the Height and Width of the image
- Click Ok once you are done with the resize
Add a Watermark text in Excel
- The first set of steps is identical to adding a watermark image 😙
Go to Insert Tab > Text Section and select Header & Footer
- Select any of the three boxes under the headers
Excel will set the font size to 11 by default.
You may opt to change the font size by going to the Home tab