How to Insert a Watermark in Excel (Picture or Text)

How to Insert a Watermark in Excel

Today’s tutorial will be on how to insert a watermark in Excel. We’re going to go through a quick and easy way to do that, and we’ll be talking about pictures as well as text.

Get ready, we’re about to start!

Would you rather watch this tutorial? Click the play button below!

How to Insert a Watermark in Excel

To insert a watermark in an Excel spreadsheet, go to the ‘Page Layout’ view on the View tab.

How to Insert a Watermark in Excel - Page Layout

Then click on ‘Add header’, which will open the header section of the document. So basically, we’ll use the header to insert a picture or text as a watermark.

How to Insert a Watermark in Excel - Add Header

How to Add a Picture Watermark Properly

Let’s have a look at how to add a picture watermark – we need to be in the Header & Footer tab where we select ‘Picture’.

How to Insert a Watermark in Excel - Header and Footer Tab - Picture

Now you’ll see a window with multiple options to insert the picture. We’ll use the first one – from a file. Let’s click on it and browse the computer to find the picture we’ve prepared. Select the picture and confirm by clicking on Insert.

How to Insert a Watermark in Excel - Use the picture form a file
How to Insert a Watermark in Excel - Select the picture and confirm

You can notice that Excel shows a piece of text instead of the picture, so to see the picture itself, click anywhere on the sheet and you’ll be able to see the inserted picture, which seems to be way too big though.

How to Insert a Watermark in Excel - Excel shows a piece of text instead of the picture
How to Insert a Watermark in Excel - Inserted picture

Let’s fix this and format the picture together.

But before we move to that, it’s important to note that the best format for a picture watermark is PNG and it might be a good idea to prepare the picture as a logo with a transparent background, for example.

How to Insert a Watermark in Excel - the best format for a picture watermark is PNG

How to Format a Picture Watermark

To format the picture, we need to click into the header again to open the Header & Footer tab where we click on ‘Format Picture’. Here we can find some options that might help us modify the picture as we need.

How to Insert a Watermark in Excel - click on the header
How to Insert a Watermark in Excel - Format the Picture

First, I would suggest resizing the picture. We can use a specific number to set the height and the width or simply use percentage under ‘Scale’.

How to Insert a Watermark in Excel - resizing the picture

Here we’ll set the percentage to 30% and after clicking on OK, you can see that the picture is much smaller, which is more convenient for us.

How to Insert a Watermark in Excel - set the percentage to 30%
How to Insert a Watermark in Excel - picture is smaller

Now, let’s make some more changes – let’s go back to ‘Format Picture’, go to the tab ‘Picture’ and we’re going to change the picture colour.

How to Insert a Watermark in Excel - option format picture
How to Insert a Watermark in Excel -  picture tab

As you can see, there are more options we can use, so now we’ll go for ‘Washout’, confirm with OK and our picture looks more like a watermark now.

How to Insert a Watermark in Excel -  washout picture option
How to Insert a Watermark in Excel - picture looks more like a watermark

But that’s not all.

We need to move the picture down a little bit. So, we click into the header again and press Enter as many times as needed until the picture location is just as we want it to be. We’ll place it here.

How to Insert a Watermark in Excel -  move the picture down a little bit
How to Insert a Watermark in Excel -  watermark placed in the middle

To remove the watermark, click into the header section, select all that’s there and use the key ‘Delete’. There you go! The watermark’s gone.

How to Insert a Watermark in Excel -  to remove picture select all that’s there and use the key ‘Delete’
How to Insert a Watermark in Excel -  The watermark’s gone

Now let’s move on and have a look at how to insert a text watermark.

How to Insert a Text Watermark

Click into the header again and simply type in whatever text you want to use as a watermark. We’re going to use the word ‘DRAFT’ here.

How to Insert a Watermark in Excel - insert the text watermark

Next, we’re going to select the text to do some useful formatting.

How to Insert a Watermark in Excel - select the text

For example, in the Home tab, we can choose a font type – let’s say we’re going to use Arial Black here.

How to Insert a Watermark in Excel -  font type Arial Black

Also, the size of the text can be adjusted here, so this will be font size 72.

How to Insert a Watermark in Excel - font size 72

Apart from that, we can select the colour of the text, let’s say we’ll go for this grey.

How to Insert a Watermark in Excel - select the colour of the text

And just as with the picture, even here we can use the key ‘Enter’ to find the right place for the watermark.

How to Insert a Watermark in Excel - find the right place for the watermark

And that’s about it. If we click anywhere on the spreadsheet, we’ll see our watermark in all its beauty 😊

How to Insert a Watermark in Excel - final text watermark

If, for some reason, you need to remove it, you can do it the same way as with the picture.

Don’t miss out a great opportunity to learn:

If you found this tutorial helpful, give us a like and watch other tutorials by EasyClick Academy. Learn how to use Excel in a quick and easy way!

Is this your first time on EasyClick? We’ll be more than happy to welcome you in our online community. Hit that Subscribe button and join the EasyClickers!

Thanks for watching and I’ll see you in the next tutorial!

Comments

Add comment

Your email address will not be published.

Your personal information will only be used for the purpose of processing this comment.

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