Friday, 26 July 2019

How to Inserting a Watermark in MS Excel

A watermark is an image or text that appears on a printed page. A watermark can be a faint company logo or a word, such as DRAFT. Excel doesn’t have an official command to print a watermark, but you can add a watermark by inserting a picture in the page header or footer. Here’s how to do it:
  1. Locate an image on your hard drive that you want to use for the watermark.
  2. Choose View➜Workbook Views➜Page Layout View to enter Page Layout view.
  3. Click the center section of the header.
  4. Choose Header & Footer Tools➜Header & Footer Elements➜Picture. The Insert Picture dialog box appears.
  5. Click Browse and locate and select the image you picked in Step 1 or locate a suitable image from other sources listed, then click Insert to insert the image.
  6. Click outside the header to see your image.
  7. To center the image vertically on the page, click the center section of the header and press Enter a few times before the &[Picture] code. You’ll need to experiment to determine the number of carriage returns required to push the image into the body of the document.
  8. If you need to adjust the image (for example, to make it lighter), click the center section of the header and then choose Header & Footer Tools➜Header & Footer Elements➜Format Picture; use the Image controls on the Picture tab of the Format Picture dialog box to adjust the image.
You may need to experiment with the settings to make sure that the worksheet text is legible.


Displaying a watermark on a page.
Figure above shows an example of a header image (a copyright symbol) used as a watermark. You can create a similar effect with plain text in the header (for example, the word DRAFT).

0 comments:

Post a Comment