The two ways to watermark in Excel

Excel does not have a dedicated watermark button. Instead, you can add a watermark in two ways: through the Header & Footer tool (which puts text behind your data on every printed page) or by inserting a text box or image that floats on top of your spreadsheet. The Header & Footer method is simpler if you only care about printed output. The text box method works if you need the watermark visible on screen and in PDFs.

Most people use Header & Footer because it requires no design work and automatically repeats on every page. If you need something more visible or styled differently, the text box approach gives you more control but takes a few extra steps.

Key Takeaways

  • The Header & Footer watermark appears only on printed pages and PDFs, not on your screen while you work.
  • To add a Header & Footer watermark, go to Insert > Header & Footer, then type your text in the center section and format it as needed.
  • A floating text box watermark is visible on screen and in PDFs, but you must manually position it and adjust transparency so it does not block your data.
  • Text box watermarks require you to set the text color to light gray and rotate the text 45 degrees for a traditional watermark look.
  • Both methods work in Excel for Windows and Mac, though the menu paths differ slightly on Mac.

Adding a watermark through Header & Footer

Open your spreadsheet and click the Insert tab at the top. In the ribbon, find the Header & Footer button (it may be labeled Header or grouped under Text depending on your Excel version). Click it, and Excel will switch to a special view showing your page layout with three sections: left, center, and right.

Click the center section of the header area (the middle box at the top of the page). Type your watermark text — for example, "DRAFT" or "CONFIDENTIAL". You can type anything you want. Once you have typed the text, click anywhere outside the header area to return to your normal spreadsheet view. The watermark will not appear on your screen, but it will show on every printed page and in any PDF you create from the file.

If you want to format the watermark text (make it larger, change the color, or make it bold), click Insert again, then Header & Footer, and click the center section again. A toolbar will appear with formatting options. Select your text and explore the changes you want. When you are done, click outside the header area.

Adding a watermark with a floating text box

This method creates a watermark that you can see while working and that appears in PDFs. Click the Insert tab, then find Text Box in the ribbon. Your cursor will change to a crosshair. Click and drag to draw a text box anywhere on your spreadsheet — it does not matter exactly where yet, since you will move it later.

Type your watermark text into the box. Right-click the text box border (not the text inside) and select Format Shape or Format Text Box. A panel will open on the right side of your screen. Look for the Fill option and set it to No Fill so the box has no background. Then find Line and set it to No Line so the box has no border.

Next, set the text color to light gray so it does not block your data. Right-click the text inside the box and select Font Color, then choose a light gray from the color palette. Now right-click the text box border again and look for a Rotate option or a rotation handle (a small circle at the top of the box). Rotate the text 45 degrees — this is the traditional watermark angle. Drag the text box to the center of your spreadsheet. You can now work normally; the watermark will stay in place and appear in any PDF you create.

Making your text box watermark less visible

A watermark should not interfere with reading your data. If your light gray text is still too dark, you can make it more transparent. Right-click the text box border and select Format Shape. In the panel on the right, find Fill and look for a Transparency slider. Increase the transparency to 50 or 60 percent — this will make the text fainter without removing it entirely.

If you want the watermark to stay behind your data rather than on top, right-click the text box and select Arrange, then Send to Back. This moves the watermark behind all your cells so it does not cover any numbers or text you type. Keep in mind that if you send it to the back, it may become harder to select and edit later — to select it again, click on it directly or use the selection pane from the Arrange menu.

Watermarking multiple sheets in the same file

If your Excel file has multiple sheets and you want the same watermark on all of them, the Header & Footer method is faster. The watermark you add through Header & Footer applies to every sheet in the workbook automatically. You only have to set it once.

If you use a text box watermark, you will need to add it to each sheet separately. A simpler workaround is to add the watermark to one sheet, then right-click the sheet tab at the bottom and select Move or Copy. Copy the sheet, then delete all the data and replace it with your own — the watermark will copy along with the sheet structure. Alternatively, you can copy the text box itself, switch to the next sheet, and paste it in the same position on each sheet.

Removing or editing a watermark

To remove a Header & Footer watermark, click Insert > Header & Footer, click the center section, delete the text, and click outside the header area. The watermark will disappear from all printed pages.

To remove a text box watermark, click on the text box to select it (you will see a border around it), then press the Delete key. To edit a text box watermark without deleting it, double-click inside the box to enter edit mode, then change the text as needed. Click outside the box when you are done.

Watermarks in Excel for Mac

The Header & Footer method works the same way on Mac: click Insert in the ribbon, then Header & Footer, and type in the center section. The text box method is also identical — use Insert > Text Box, then format it the same way.

One small difference: on Mac, the formatting panel may appear at the bottom of the screen instead of on the right side. The options are the same; you just have to look in a different place. If you cannot find an option, try right-clicking the text box and looking for it in the context menu instead.

Frequently Asked Questions

Will my watermark print if I use the Header & Footer method?

Yes. Header & Footer watermarks appear on every printed page and in PDFs created from your file. They do not appear on your screen while you work, only in the print preview and in the final printed or PDF output.

Can I use an image as a watermark instead of text?

Yes, but only with the text box method. Insert your image, right-click it, select Format Picture, and reduce the transparency to 50 or 60 percent so it does not block your data. You can also rotate it the same way you would rotate a text box. The Header & Footer method only accepts text.

Why does my watermark look different when I print versus what I see on screen?

Header & Footer watermarks are designed for printing and may not display accurately in the normal spreadsheet view. Use Print Preview (File > Print) to see how your watermark will actually look on the printed page. Text box watermarks appear the same on screen and in print.

Can I make the watermark appear only on certain pages?

Header & Footer watermarks appear on every page of a sheet by default. To limit them to specific pages, you would need to split your data into separate sheets and add the watermark only to the sheets you want. Text box watermarks appear only on the sheet where you place them, so you have more control over which pages show the watermark.

What happens to my watermark if I share the file with someone else?

Both Header & Footer and text box watermarks are saved as part of the Excel file. When you share the file, the watermark travels with it. The other person will see the same watermark you do (though Header & Footer watermarks still only appear in print preview and printed output, not on their screen while they work).