How to embed watermarks in Office 2016 / 2019 Excel spreadsheets and PowerPoint presentations?


Last updated: September 2018

Applicability: Office 2019, 2016,2013,2010; Windows and MAC OSX

Few weeks ago we received a note from a reader:

Every quarter, our team creates handouts for management meetings. The process of developing the handouts is pretty elaborated and requires to collaborate in development a series of workbooks, presentations and documents. In order to clearly determine the status of those documents we wanted to use watermarks. Can you shed light about how to use watermarks, either textual (plain or smart texts) or  graphical (pictures from our computers and the web).

Thanks for the question. In this post you will learn how to insert or embed watermarks in Office 2016 applications like PowerPoint and Excel (you could potentially use similar techniques in Word and Visio). Note that you can use the same procedure in order to either add or remove a watermark.



There are several use cases that can be accomplished by inserting watermarks into Office files:

  1. Indicating the document status (“Draft”,”Released”, etc’)
  2. Specifying the confidentiality level of a document
  3. Indicating the copyrights of the file content
  4. Indicating that the content being published is a sample

So without further ado, let’s learn how to use watermarks in Office applications.

Insert watermarks into PowerPoint slides

  • Open PowerPoint 2016,
  • Navigate to your presentation.
  • Go to View and select Slide Master.

2015-08-30 17_32_49-Presentation1 - PowerPoint

Picture/Gif/Jpg Watermarks

  • To add a picture watermark into your slide, click Insert and select Pictures.

2015-08-30 17_33_52-Presentation1 - PowerPoint


  • Browse to anyone of your desired pictures and click Insert.

2015-08-30 17_34_35-Insert Picture

  • Now, in the ribbon select the Send backward drop down box and hit Send to back.

2015-08-30 17_36_07-Presentation1 - PowerPoint

  • Then right click on the picture and select Format picture.

2015-08-30 17_36_47-

  • Select Picture in the box, click on Recolor and select a lightened picture.

2015-08-30 17_37_53-Presentation1 - PowerPoint

  • Go to Slide master and hit Close master view.

2015-08-30 17_39_09-Presentation1 - PowerPoint

Text Watermarks

  • To insert a text watermark in your slide, click insert and select lightened WordArt.

2015-08-30 17_40_48-Presentation1 - PowerPoint

  • Enter the text that want to be your watermark.

2015-08-30 17_43_40-Presentation1 - PowerPoint

  • Now, right click on the text and select Format text effects.

2015-08-30 17_44_26-Presentation1 - PowerPoint

  • Then select text fill & outline and increase the transparency accordingly in the Text fill.

2015-08-30 17_45_18-Presentation1 - PowerPoint

Insert watermarks to Excel worksheets

  • The process of creating Excel watermarks is quite similar to the one we highlighted for PowerPoint below.
  • To insert a text watermark in your slide, click Insert and select WordArt.
  • Next, type the text that want to be your watermark (that would be “draft”, “in-process”, “copyright” and so forth).
  • Next, right click on the text and select Format text effects.
  • In the Format Shape dialog, pick the Text Options tab
  • Then under text fill & outline and increase the transparency accordingly using the Text fill slider, as shown below (screenshot taken from Excel 2019 on MAC – looks similar in Windows).

Watermark_Excel_MACOSX

 

Note:

  • In Excel a picture watermark cannot be inserted, as the values are entered in the cell the picture transparency cannot bring the cells front to make it visible.
  • When adding text watermarks, you are able to set not only the transparency level, but also use the Text Format pane to determine the watermark color gradient, size, format, rotation and so forth. See below a different version of our Draft watermark, this time rotated, shadowed and different WordArt style.

Insert_water_mark_Excel

Suggested next steps

Leave a Comment: