2010-01-25

Step by Step:Excel Watermark (Excel 2010,2007)

Word has a feature on creating warkmark text, such as "Confidential", "Draft",....
However, there no such direct feature in Excel.

The below steps "mimic" the watermark feature in Excel 2007/2010
1. Select the sheet you want to add the watermark
2. Locate Page setup properties

3. Go to the third tab "Header/footer" Click on the custom headaer


4. a)Enter the watermark text you want in the Center Section.

4. b)Highlight the wording and then Click on "A" button to adjust the font size & light color.
 20120413excelwatermark
In this sample, font "Arial" of size 48 has been used for the word "CONFIDENTIAL"
Click OK two times to return to page setup (one time for "Font setting" and one time for "Header")


4. c)If necessary, image could also be added
20120413excelwatermark2
5. Go to the second tab "Margin".
"Push" the header to the centre of the paper, by adjusting the Header position. For A4 paper, it's 5" roughly.


6. Click OK to finish the setting.

Preview of printout: (Screen from Excel 2010)
Last Updated 2012-APR-13

3 comments:

  1. How do you adjuct the contrast or grayscale so you can read where the watermark is

    ReplyDelete
    Replies
    1. Hello,
      You can adjust the text color and even image under "custom header" screen.
      Here added the screens on 4b)(include font color),4c)(image contrast/grayscale) for your reference.
      Cheers

      Delete

  2. We provide you result at the same time as PEC provides. First of all, You should bookmark this page to get your 5th Class PEC result in time. The 5th Class PEC result will be available on 31 March 2018 at 10 Am.

    class 8th exam result 2018
    5th result 2018 fsd board
    pec result 2018 class 8th

    ReplyDelete