Excel Watermark (Table of Contents)
- Introduction to Watermark in Excel
- Insert Watermark in Excel
- Insert Watermark to the Header of the Sheet
Introduction to 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 also add an image as a watermark. For example, some of the common watermarks are Confidential, Sample, Draft, etc.…
In this article, we will demonstrate how to insert watermarks in excel, reposition them, alter the size of the watermark in excel, and add a company logo to your header and footer document; delete them 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 a 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 to your excel sheet.
Step 1: Open a new excel workbook on your computer or laptop. I have opened and created some dummy data.
Step 2: Go to the VIEW tab > and click on Page Layout.
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.
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. For example, we usually see the company logo in the header of the document. Similarly, we can insert our own logo to the document by following the below steps.
Step 1: Go to the 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 on your computer and choose the picture online. I have taken the picture from my laptop. 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 the header formatted properly.
Move down the Image to make it a Watermark.
We can move down the watermark to the document’s centre to make it 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 it as a 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 –