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