How to Insert a Watermark in Microsoft Excel

When sharing spreadsheets containing confidential financial data, draft budgets, proprietary company information, or sensitive client records, it is important to label the document’s status clearly. Adding a “CONFIDENTIAL” or “DRAFT” watermark across the background of your spreadsheet ensures that anyone viewing or printing the document immediately understands its classification.

Unlike Microsoft Word, Excel does not include a dedicated “Watermark” button in its ribbon menu. However, you can achieve a professional watermark effect by placing an image or styled text in the document’s header section. This workaround produces results that are indistinguishable from a built-in watermark feature.

How to Add a Picture Watermark Using the Header

The most reliable and professional-looking method is to insert a pre-made watermark image (such as a faded company logo or a transparent PNG containing the word “DRAFT”) into the spreadsheet’s header.

1. Open your spreadsheet in Microsoft Excel.
2. Click on the Insert tab in the top ribbon menu.
3. Locate the “Text” group on the right side of the ribbon and click on Header & Footer. Your view will automatically switch from “Normal” to “Page Layout,” and a header area with three sections (left, centre, right) will appear at the top of the page.
4. Click inside the centre section of the header area.
5. A new Header & Footer tab will appear on the ribbon. Click it, then click the Picture button in the “Header & Footer Elements” group.
6. Browse your computer for your watermark image file and click Insert. The placeholder text &[Picture] will appear in the centre header section.
7. Click anywhere in the main grid of your spreadsheet (outside the header area). Your image will appear behind your data.

How to Position and Format the Watermark Image

By default, the watermark image appears at the very top of the page, which may not be ideal. You can adjust its position and transparency.

Moving the Watermark Down the Page

1. Click back inside the centre header section where the &[Picture] text is located.
2. Place your cursor before the & symbol.
3. Press the Enter key repeatedly to push the image down the page. Each press adds a blank line above the image, moving it further towards the centre of the printed page.
4. Click outside the header to preview the result.

You may need to experiment with the number of blank lines to position the watermark exactly where you want it. The result is visible in Page Layout view and in print preview.

Making the Watermark Semi-Transparent (Washout Effect)

1. Click inside the centre header section to activate the Header & Footer tab on the ribbon.
2. Click the Format Picture button.
3. In the Format Picture dialogue window, click the Picture tab.
4. Under the “Image control” section, change the Colour dropdown menu to Washout.
5. Click OK.

The Washout setting automatically fades the image significantly, ensuring it does not obscure your spreadsheet data whilst still being clearly visible as a watermark.

Resizing the Watermark Image

1. In the same Format Picture dialogue, click the Size tab.
2. Adjust the height and width values. You can also lock the aspect ratio to prevent distortion.
3. Click OK to apply.

How to Create a Text-Based Watermark Using WordArt

If you do not have a pre-made watermark image, you can create a text-based watermark directly within Excel using WordArt.

1. Click on the Insert tab.
2. In the “Text” group, click on WordArt.
3. Select a light grey or faded style from the gallery.
4. Type your watermark text (such as “DRAFT” or “CONFIDENTIAL”).
5. Resize and rotate the WordArt object by dragging its handles. A diagonal orientation (roughly 45 degrees) is the most common watermark style.
6. Right-click the WordArt object and select Format Shape.
7. Adjust the text fill colour to a very light grey (such as RGB 200, 200, 200) to ensure it does not overpower your data.

Important note: Unlike the header method, a WordArt watermark sits on top of your spreadsheet content as a floating object. It may interfere with cell selection and editing. The header-based image method is generally preferred for professional documents.

Watermark Visibility Across Views

Understanding when your watermark is visible is important:

View	Header Image Watermark	WordArt Watermark
Normal view	Not visible	Visible
Page Layout view	Visible	Visible
Page Break Preview	Not visible	Visible
Print Preview / Printing	Visible	Visible

If you need the watermark to be visible whilst working in Normal view, the WordArt method is more suitable. For documents that will primarily be printed or exported as PDFs, the header image method produces cleaner results.

How to Apply the Watermark to Multiple Sheets

The header-based watermark only applies to the sheet where you inserted it. If your workbook contains multiple sheets that all need the same watermark:

1. Right-click the tab of the first sheet at the bottom of the screen.
2. Click Select All Sheets. All sheet tabs will become highlighted.
3. Now insert the watermark using the header method described above.
4. Once finished, right-click any sheet tab and click Ungroup Sheets to return to normal editing.

The watermark will now appear on every sheet in your workbook when printed or viewed in Page Layout mode.

How to Remove a Watermark

1. Switch to Page Layout view by clicking View > Page Layout.
2. Click inside the header section containing the &[Picture] text.
3. Select the &[Picture] text and delete it.
4. Click outside the header area.

The watermark image will be removed entirely from the document.