How to Add a Watermark to Excel Using WordArt and Header Tricks

Excel does not have a built-in watermark feature like Word. Users often need to mark drafts or confidential sheets with a background text. This article explains how to simulate a watermark using WordArt and the header section. You will learn two methods to place text behind your worksheet data.

Understanding Excel’s Watermark Workarounds

A watermark is typically semi-transparent text or an image that appears behind the main content. Since Excel is designed for data calculation, it lacks a direct watermark command. The two primary methods to add one both involve inserting an object and adjusting its placement. The WordArt method creates a floating object on the worksheet, ideal for on-screen viewing. The header method inserts the watermark into the page layout, which is best for printed reports.

Before you start, decide if the watermark is for printing or digital use. For a watermark that appears on every printed page, use the header trick. For a single, centrally placed watermark on a specific sheet, WordArt is more flexible. Both methods require you to adjust the transparency of the text to achieve the classic watermark effect.

Steps to Create a Watermark with WordArt

This method gives you full control over the watermark’s position, size, and rotation on a specific worksheet.

1. Insert the WordArt object
   Go to the Insert tab. In the Text group, click WordArt. Select a simple, light-colored style from the gallery. A text box with placeholder text will appear on your sheet.
2. Edit the watermark text
   Click inside the WordArt text box and type your watermark text, such as “DRAFT” or “CONFIDENTIAL”.
3. Format the text for a watermark look
   With the WordArt selected, the Shape Format tab appears. Use the Shape Fill dropdown to choose a light gray color. Use the Shape Outline dropdown and select No Outline. In the WordArt Styles group, click Text Fill > More Fill Colors. Use the Transparency slider to set it between 50% and 70%.
4. Position and rotate the watermark
   Drag the WordArt object to the center of your data area. To rotate it, click and hold the circular rotation handle at the top of the object and drag. A diagonal angle is common for watermarks.
5. Send the watermark behind your data
   Right-click the WordArt object, select Send to Back, and then choose Send Behind Text. This ensures your cell data remains visible and selectable over the watermark.

Steps to Add a Watermark via the Header

This method embeds the watermark in the page layout, making it repeat on every page when printed.

1. Switch to Page Layout view
   Click the View tab. In the Workbook Views group, click Page Layout. You will see the header area at the top of the sheet.
2. Open the header for editing
   Click directly into the center section of the header. The Header & Footer Tools Design tab will appear on the ribbon.
3. Insert and format the watermark text
   On the Design tab, in the Header & Footer Elements group, click Picture. Navigate to and insert a pre-made image file of your watermark text. Alternatively, click Format Picture to adjust its scale. For a text-only option, you can manually type your watermark text, like “DRAFT”, into the header box and format its font to a large, light gray color.
4. Adjust the picture for transparency
   If you inserted a picture, click Format Picture in the Header & Footer Elements group. In the dialog box, go to the Picture tab. Click the Recolor button and select Washout. Use the Brightness and Contrast sliders to further fade the image.
5. Return to Normal view
   Click the View tab and select Normal. The watermark will not be visible on screen in this view but will appear when you print or use Print Preview.

Common Mistakes and Limitations to Avoid

Watermark Does Not Appear When Printing

If a header watermark does not print, check your print settings. Go to File > Print. Click Page Setup at the bottom. In the Sheet tab, ensure the option for Draft quality is not checked. Also, verify in the Header/Footer tab that your custom header is still applied.

WordArt Watermark Moves or Resizes with Cells

By default, WordArt objects float over cells. If you insert or delete rows, the watermark may not stay centered. To prevent this, right-click the WordArt, select Size and Properties. In the Format Shape pane, go to the Properties section. Select the option “Don’t move or size with cells”.

Watermark Looks Too Dark or Obscures Data

A common error is not making the watermark transparent enough. For WordArt, always use the Text Fill > More Fill Colors dialog to set a high transparency value, above 50%. For header pictures, the Washout effect is essential. If the text is still too bold, increase the image brightness to near maximum in the Format Picture dialog.

WordArt vs Header Watermark: Key Differences

Item	WordArt Watermark	Header Watermark
Primary Use	On-screen viewing on a specific sheet	Printing on every page of a report
Visibility in Normal View	Always visible behind cells	Only visible in Page Layout view or Print Preview
Editing Method	Directly on the worksheet canvas	Through Header & Footer Tools Design tab
Position Control	Precise drag-and-drop placement and rotation	Fixed to header center, left, or right section
Repeats on Multiple Pages	No, must be copied manually to other sheets	Yes, automatically repeats on all printed pages

You can now add a DRAFT or CONFIDENTIAL mark to your Excel sheets. Use the WordArt method for digital dashboards and the header trick for formal reports. For an advanced tip, create a watermark image in PowerPoint with perfect transparency, save it as a PNG, and insert it using the header picture method for a professional result.