To switch from Page Layout view to Normal view, select any cell, click the View tab, and then, in the Workbook Views group, click Normal.Ĭlick the worksheet location where you want to display the watermark. To delete a picture in the header section box that contains the picture, select &, press DELETE, and then click in the worksheet. To replace a picture in the header section box that contains the picture, select &, click Picture, and then click Replace.īefore printing, make sure that the header or footer margin has sufficient space for the custom header or footer. If you want to add blank space above or below a picture, in the header selection box that contains the picture, click before or after &, and then press ENTER to start a new line. To resize or scale the picture, click the header selection box that contains the picture, click Format Picture in the Header & Footer Elements group, and then, in the Format Picture dialog box, select the options that you want on the Size tab.Ĭhanges to the picture or picture format take effect immediately and cannot be undone. The picture you selected will appear in place of &. & appears in the header selection box.Ĭlick in the worksheet. On the Design tab of the Header & Footer Tools, in the Header & Footer Elements group, click Picture and then find the picture that you want to insert.ĭouble-click the picture. Under Header, click either the left, center, or right header selection box. On the Insert tab, in the Text group, click Header & Footer. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.Note: Make sure that only one worksheet is selected. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. How to Remove Watermark Instant Connection to an Expert through our Excelchat Service
Formatting the Watermark Picture How to Delete a Watermark In the Image Control section, click on Color drop-down and select Washout and press the OK buttonįigure 7.