Excel guide · 6 min read
How to add a watermark in Excel
Sample data
Every result on this page was calculated from this sheet by the same spreadsheet engine the Cellwise app uses.
| Row | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | DRAFT - Marketing budget 2027 - not approved | |||||
| 2 | Status | Draft | ||||
| 3 | Line | Q1 | Q2 | Q3 | Q4 | Total |
| 4 | Paid search | 12000 | 12000 | 14000 | 18000 | 56000 |
| 5 | Social ads | 8000 | 8000 | 9000 | 12000 | 37000 |
| 6 | Events | 0 | 15000 | 0 | 22000 | 37000 |
| 7 | Content | 6000 | 6000 | 6000 | 6000 | 24000 |
| 8 | Agency fees | 4500 | 4500 | 4500 | 4500 | 18000 |
| 9 | Total | 30500 | 45500 | 33500 | 62500 | 172000 |
Download this sheet as an Excel practice file (.xlsx)
Three ways to fake a watermark, and which to pick
Microsoft says it plainly: Excel doesn't have a built-in watermark feature. You choose one of three workarounds, and they behave very differently:
- A picture in the header prints behind the data on every page. This is the one to use for DRAFT or CONFIDENTIAL on printouts and PDFs.
- A sheet background (Page Layout > Background) shows behind the cells on screen but never prints. Microsoft notes it can't be used as a watermark for that reason.
- WordArt is a shape floating over the cells. It prints, but only where you put it, so on a long report it appears on one page and not the rest.
Step 1: make the watermark picture
The header only accepts a picture, not typed text that sits behind the data, so you need an image of the word first. A PNG with a transparent background works best, because white boxes around the letters hide the cells under them.
An easy way without design software: in PowerPoint or Excel, insert a text box or WordArt, type DRAFT in large light grey letters, rotate it if you want the diagonal look, then right-click its border and choose Save as Picture and save it as PNG. If you don't see Save as Picture in your version, copy the shape and paste it into Paint or another image editor and save from there.
Step 2: put the picture in the header
The sample is a marketing budget that is still a draft. The watermark goes in the center header box, so it sits in the middle of the page.
- Click the sheet you want to mark. Headers, and so watermarks, are set per sheet.
- Go to Insert > Header & Footer (in the Text group). Excel switches to Page Layout view.
- Click the center header box.
- On the Header & Footer tab (called Design in older versions), click Picture in the Header & Footer Elements group and choose your image file.
- The box now shows &[Picture]. Click any cell to see the watermark on the page.
- Check it with Ctrl+P before you print or save a PDF.
Step 3: fade it and move it down the page
A full-strength picture makes the numbers hard to read, and a picture in the header starts at the top of the page. Both are fixed from the header box.
- Click the header box that shows &[Picture], then click Format Picture on the Header & Footer tab.
- On the Picture tab, under Image control, set Color to Washout. That fades the image so the data stays readable. Brightness and Contrast fine-tune it.
- On the Size tab, change the height or scale to make the watermark bigger or smaller.
- Click OK, then click in the header box just before &[Picture] and press Enter a few times. Each new line pushes the picture further down the page.
- Click a cell and check the position in Page Layout view. Repeat until it sits in the middle of the data.
Why does my watermark disappear in Normal view?
Header pictures, like all header content, only show in Page Layout view, Print Preview and on paper. Use View > Page Layout or the Page Layout button on the status bar to see it while you work.
Can I add a watermark in Excel for the web?
No. Microsoft says the feature isn't available in Excel for the web. Open the file in the desktop app (Editing > Open in Desktop App) and add it there; the watermark stays in the file.
A DRAFT label that disappears when the budget is approved
A header picture doesn't know anything about your data, so someone has to remember to remove it. If the real point is "don't trust these numbers yet", a formula title can do the job and switch itself off. The title in A1 checks the status cell in E2, and it prints on page 1 like any cell. To repeat it on every page, include row 1 in Page Layout > Print Titles > Rows to repeat at top.
Result: DRAFT - Marketing budget 2027 - not approved
DRAFT - Marketing budget 2027 - not approved: E2 still says Draft. Type Approved in E2 and the title becomes Marketing budget 2027. Add a red fill with conditional formatting if you want it to shout.
Should I use this instead of a picture watermark?
Use both if the sheet will be printed and passed around: the picture marks every page, and the formula title reminds you to remove the picture once the status changes. For a file that is only ever read on screen, the formula title alone is often enough.
Sheet background and WordArt: when they make sense
A sheet background is for screens only: a faint logo behind a dashboard, for example. Go to Page Layout > Background, pick an image and Excel tiles it across the sheet. Remove it with Page Layout > Delete Background, which only appears once a sheet has a background. Don't use it to mark a document confidential: it never prints and isn't kept when you save the sheet as a web page.
WordArt (Insert > Text > WordArt) is quick for a one-page sheet. Type DRAFT, rotate it, then right-click it, choose Format Shape and raise the transparency of the text fill so the cells show through. It prints wherever it sits, but it covers the cells for clicking. If you can't select the cells under it, or can't find it to delete it, use Home > Find & Select > Selection Pane, which lists every shape on the sheet.
Remove a watermark
Work out which kind it is first. If it only shows in Page Layout view and Print Preview, it's in the header. If it shows in Normal view and tiles across the sheet, it's a background. If you can click it and drag it, it's a shape.
- Header picture: Insert > Header & Footer, click the box with &[Picture], select the code, press Delete and click a cell. Check all three boxes, and the footer too.
- Background: Page Layout > Delete Background.
- WordArt or a picture shape: click its edge (or pick it in Home > Find & Select > Selection Pane) and press Delete.
- If several sheets have it, repeat on each one. Every sheet keeps its own header.
Common mistakes
Using Page Layout > Background as a print watermark
A sheet background never prints. Put the picture in the header instead.
Leaving the picture at full strength
Format Picture > Picture tab > Color: Washout, or the numbers on top become hard to read.
A picture with a white box around the text
Save the watermark as a PNG with a transparent background so cells aren't covered.
Adding it to one sheet and printing the whole workbook
Headers are per sheet. Add the picture to every sheet that prints, or group the sheets first.
FAQ
Is there a watermark option in Excel?
No. Excel has no built-in watermark feature. Put a picture in the header with Insert > Header & Footer > Picture to get the same result on printed pages.
How do I add a CONFIDENTIAL watermark in Excel?
Make a PNG of the word CONFIDENTIAL, then Insert > Header & Footer, click the center header box and choose Picture. Fade it with Format Picture > Washout and press Enter before &[Picture] to move it down.
Why doesn't my watermark show in Excel?
You're in Normal view. Header pictures only appear in Page Layout view, Print Preview and on paper.
Does a watermark show in a PDF from Excel?
A header picture does, because PDFs use the print settings. A sheet background doesn't.
How do I put a watermark on every page in Excel?
Use the header picture method. The header repeats on every printed page of that sheet automatically.
Functions used
Related guides
- How to add a header in Excel
- How to add page numbers in Excel
- How to print gridlines in Excel
- Excel print titles not working: how to repeat the header row on every page
- How to abbreviate large numbers in Excel: thousands (K), millions (M), billions (B)
- ABC inventory analysis in Excel
Updated