Excel Watermark (Table of Contents)
Watermark in Excel
Watermarks are nothing but the light heading kind of text or image we usually see in word documents. You must be familiar with watermarks in Microsoft documents. In excel too we can add watermarks to our spreadsheets. The reason could be, you want to show your name in freelance work, you want to add your company logo or your identity to the document, or you just want to have fun with your document.
We can add text value as a watermark, we can add an image as a watermark as well. Some of the common watermarks are Confidential, Sample, Draft, etc.…
In this article, we will demonstrate on how to insert watermarks in excel, how to reposition them, how to alter the size of the watermark in excel, how to add a company logo to your header and footer document and delete those watermarks.
Insert Watermark in Excel
You know that we don’t have any built-in tool to insert watermark in excel. I know you already thinking then how do we add watermark in excel. Nothing to worry we can create our watermark and make it visible in the print preview. Follow the below steps to add a watermark in your excel sheet.
Step 1: Open new excel workbook in your computer or laptop. I have opened and created some dummy data.
Step 2: Go to VIEW tab > and click on Page Layout.
4.9 (3,349 ratings)
Step 3: Now you will see a worksheet like this.
Step 4: Now go to INSERT tab > Under Text section select Insert Word Art.
Step 5: Select the style you wish to have.
Step 6: Now we have word art style appearing in the worksheet.
Step 7: Type the water text you wish to show.
Note: Try to select a light color to make it fit the data table.
Step 8: Make the font color to grey and remove the outline as no outline.
Step 9: Change the angle of the shape as shown in the below image.
You have inserted your watermark to the worksheet. You can print this document along with the watermark in your worksheet.
Insert Watermark to the Header of the Sheet
We have learned how to insert our own prepared watermark to the worksheet in excel. Now we will see how to insert a watermark image to the header of the document. We usually see the company logo in the header of the document. Similarly, we can insert our own logo to the document by following below steps.
Step 1: Go to INSERT tab and select Header & Footer under the TEXT section.
Step 2: Now we see the Page Layout view with the Header & Footer design section.
Step 3: Now under HEADER & Design Tools select the option Picture.
Step 4: Excel asks you to find the picture in your computer and also it allows you to choose the picture from online as well. I have taken the picture from my laptop. In the first go, it will not display the image you have chosen it will just show the word “& [Picture]”.
Step 5: Click on any cell of the worksheet to see the image.
Right now the image has not fit properly, we need to format the image by repositioning the watermark.
Repositioning of Watermark
We need to adjust the image properly to make it appear accurately.
Step 1: Select the image you have inserted.
Step 2: Go to Design and select Format Picture.
Step 3: Make the adjustment of the height & width of the image.
Step 4: Now we have header formatted properly.
Move down the Image to make it as Watermark
We can move down the watermark to the center of the document to make it as an actual watermark for your document.
Step 1: Select the image.
Step 2: Keep pressing down to mark.
Step 3: Select any of the cells in the worksheet to see the changes.
Change the Existing Image
You can change the already inserted image at any point in time. Select the Watermark and double click on the Picture under the Design tab.
After double clicking on the image, you will see this dialogue box and click on Replace.
Things to Remember About Watermark in Excel
- If you want to design your own watermark, create word art and paste the word art to paint and save as JPEG file.
- You can adjust the height & width of the image under Format Picture.
- If you want to change the existing image you need to double click on the Picture and select Replace option.
This has been a guide to Excel Watermark. Here we discuss how to insert watermark in excel along with examples and downloadable excel template. You can also go through our other suggested articles –