Excel: Add a Printable Watermark

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.


Problem: I would like to add a "œDraft" watermark on each page of my printed worksheet.

Strategy: The center header is the gateway to adding a semitransparent watermark image that will print behind your document.

To effectively use this trick, you need to create a graphic that has a fair amount of white space at the top of the picture. The figure below shows a DRAFT stamp at the bottom of some white space. You can create this graphic in Photoshop or any photo-editing tool. I actually created this in Excel as WordArt. On the Page Layout tab, uncheck view Gridlines to create the white space. I then used the free Greenshot utility to capture a region of the screen.

  1. Add whitespace above..

    Follow these steps to create the watermark:

    1. Select the Page Layout view icon in the bottom-right corner of the Excel window.
    2. Click in the Center Header zone at the top of the worksheet. Excel displays the Header & Footer Tools Design tab.
    3. Click the Picture icon on the Header & Footer Tools tab. Browse for and select your picture. Excel inserts &[Picture] in the header.

    If your graphic is too large or small, use the Format Picture icon. You can adjust the size, but not the location. If you need more or less white space, you will have to go back to Photoshop to change the graphic.

    This figure shows the resulting graphic drawn in behind your numbers.

  2. The header appears behind your document.