How to Add Watermark in Excel? (13 Easy Steps)

Benefits

  • The images shown transparently on the web using data sharing sites or photography could be at risk of theft and unhindered use. An individual may utilize your image without your consent and mutilate the data or utilize the image for a specific reason you did not expect. Watermarking encourages you to secure your data. To ensure licensed innovation, you can add a transparent watermark to your advanced images and photographs.Watermarking will keep the uniqueness of your item on the site, and it distinguishes the proprietor of the data. The watermark can be your copyright, which is imperative as this could speak to your marking, for instance, the organization logo.The watermark image should be smaller than the primary item image. The watermarking module will downsize consequently to the extent of the image you transfer, with no loss of image quality.The base image watermark module will likewise keep the first item image. You can download the image whenever with a single click.

How to Format and Resize Your Watermark?

Format

  • Once you add your watermark image to your workbook, you can do it if you want to resize or reposition the bookmark. Of course, you can also remove it if you do not require it further.Relocate a watermark.

Moving the added bookmark to the top of the worksheet is very common. Likewise, it is very easy to shift the watermark.

  • Open the blank workbook to add and create the watermark. Go to “Insert ” and choose the “WordArt” option from the “Text” column. Always select decent colors only. Click on the “WordArt.” You will see so many colorful alphabets in the box. Choose as per your choice. Click on any of the color words which you want. Then, it will draw the one text box with the same which you choose. Type the text you want to use to create the watermark on a sheet. Now that your watermark image is ready, you need to resize and rotate it to make it look good and presentable. Click the right button and copy the image which you have written. Paste the image into a word as the picture. You can easily resize the image in words also. Then, right-click on the image and save it as a picture on your computer. Now, your bookmark is ready to add to the Excel workbook. Go to “Insert” and select the “Header&Footer” option in Excel. Once you click on the “Header & Footer,” it enables the Excel sheet in another format: Click on the “Picture” to add the image to the Excel sheet: Insert the image. Now, you will be able to see the image as a watermark in Excel:

Now, your bookmark is ready to add to the Excel workbook.

  • Go to the “Header” section box in the excel ribbonExcel RibbonThe ribbon is an element of the UI (User Interface) which is seen as a strip that consists of buttons or tabs; it is available at the top of the excel sheet. This option was first introduced in the Microsoft Excel 2007.read more toolbar.Place your pointer in front of “&[Picture]” as shown below and press the “Enter” key as many times as you get the watermark in the place where you want.

Resize

  • Go to “INSERT” and choose the “Header & Footer” option again.Select the “Format Picture” option in the “Header & Footer Elements” group on the right-hand side.Now, you can easily resize your watermark as required.

Tips to Remember While inserting Watermark in Excel

  • We can view watermarks in the print previewPrint PreviewPrint preview in Excel is a tool used to represent the print output of the current page in the excel to see if any adjustments need to be made in the final production. Print preview only displays the document on the screen, and it does not print.read more, and “Page Layout” view. On the printed worksheet, when you take the printout of the sheet. You cannot see watermarks in the “Normal” view, which the vast majority use when they work in Excel 2010, 2013, and 2016.You would not be able to add more than one watermark in one section.A most important tip is to add the watermark to your worksheet. As such, it would not affect the data. Sometimes adding a watermark leads to the invisibility of your data.

This article is a guide to Watermark in Excel. Here, we discuss how to add a watermark in Excel and format and resize the watermark, along with examples and an Excel template you can download. You may also look at these useful functions in Excel: –

  • How to Insert Page Break in Excel?Insert a Picture/Image in Excel CellInsert A Picture/Image In Excel CellTo insert a picture/image in Excel cell, a user can: Directly drag and drop or copy-paste image from file location on the computer to Excel cell; or Go to Insert option in Excel after selecting the cell and add desired image from the computer’s file location.read moreDraw a Line in ExcelDraw A Line In ExcelLines in Excel are used to show connections between two or more data points. However, we can also draw lines without showing any types of relationships in Excel. To draw a line in Excel, we need to go to the “Insert” tab and click on “Shapes,” then, we can choose the type of line we want to draw in Excel.read moreInsert an Object in ExcelInsert An Object In ExcelIn Microsoft Excel, the “Object Insert” option allows a user to insert an external object into a worksheet. Embedding generally means inserting an object from another software (Word, PDF, etc.) into an Excel worksheet.read moreExcel Reference to Another SheetExcel Reference To Another SheetAn Excel reference to another sheet is a method of linking two cells such that the value or formula in one cell appears in the another cell. It is used to acquire the data from other worksheet or workbook.read more