How To Create A Watermark In Excel


You can create or mimic a ‘watermark’ in Excel quickly and easily.  Strictly speaking you can’t actually insert a watermark as you can in MS Word, but it is possible to insert an image into the Excel background or text that can say ‘Draft’ or ‘Confidential’ on every page of your workbook.

  1. Open the workbook you want to insert the watermark into – make sure only one worksheet is selected
  2. Insert Tab
  3. Text Group
  4. Header and Footer
  5. Header- select either centre, left or right
  6. Design tab of the Header and Footer elements | Picture and find the picture you want
  7. Double click the picture to insert it into he header section
  8. To resize or scale 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

The above inserts a watermark style picture.  Nice.

You may just want some text like Confidential or Draft this is done using the WordArt feature in Excel.

  1. Select Insert Tab -> WordArt (in Text Group)
  2. Select a style from WordArt gallery.
  3. Type Draft or Confidential, whatever you want as the watermark
  4. Drawing Tools Ribbon- Select Format
  5. Word Art Group – Text Fill
  6. No Fill
  7. Text Outline in WordArt Group
  8. Automatic or choose a lighter colour for more transparency
  9. Rotate in place wherever you like on the the page diagonally etc
  10. Drawing Tools Ribbon – Select Format
  11. Arrange – send to back

You now have a watermark!

How do you create a water mark in Excel?

Would you use this method at all?

Other Excel Formatting Tips You May Like.

1. Change the standard font of your own Excel workbooks.

2. Centre a title across an Excel worksheet.

3. Conditional formatting basics

Barbara

Barbara is an experienced data analyst with over 20 years of experience. Author of the How To Excel At Excel Top 50 Excel tips Ebook, YouTuber and Excel Blogger.

Recent Posts