Add a watermark to a sheet in Excel 2016 for Mac

You can add a transparent watermark that says "Draft" or "Confidential." However, there is not a Watermark button that does this for you in Excel 2016 for Mac. Instead, you can do the following steps.

Step 1: Change your view

On the View tab, click Page Layout. Page Layout view is helpful because you can easily see the margins of each printed page.

Resize the window of the workbook so that you can see the entire first page.

Step 2: Create a watermark text box

On the Insert tab, click the WordArt button, and then choose this option:

In the text box, type Confidential, Draft or any of your own text in place of Your Text Here.

Rotate and move the watermark as you see fit.

Step 3: Change the transparency settings for the watermark

Most likely the text in the watermark overlaps some of your data, making it hard to see. To fix this, you can change the transparency of the watermark so that the data can be seen through the watermark.