In the Image Control section, click on Color drop-down and select Washout and press the OK buttonįigure 7. In the Format Picture window, select the Picture tab.To do this, again click in header box and select Format Picture from Header & Footer Elements. If the picture is more prominent than our worksheet body, then we can format the picture to make it less prominent.Click anywhere in worksheet area out of the header box to see and save the selected watermark image.The Header box of worksheet appears with text & to indicate that the header contains a picture now.įigure 5.Select the picture and press the Insert button From the Header & Footer Elements group, select the Picture element and browse the picture where we have saved it on the computer.When we select the Click to Add header section, Head & Footer Tools appears.Select the Click to Add Header section on top of the worksheet.Go to the View tab and from Workbook Views group select the Page Layout.We need to follow the below steps to add watermark to worksheet. Alternately, we can create a watermark by using the WordArt or Microsoft Paint tools and save it as an image on the computer. Watermark How to Add a Watermarkįirst of all, we need to save an image on our computer which we want to use as watermark. The Excel 2010 and later versions do not have built-in watermarks, therefore we need to learn how to add and delete a watermark using the Header & Footer tools.įigure 1. The watermark is an image used in the background of the worksheet labeled as copy, draft, confidential or a picture of the logo. How to Add and Delete a Watermark in Excel

How to mark draft in excel