Excel doesn't have a built-in watermark button, but you can add one through the header and footer settings

When you open Excel's header and footer options, you can insert an image or text that appears behind your data on every printed page. This is the closest Excel comes to a watermark feature. The watermark won't show on screen while you work — it only appears when you print or export to PDF — but it will be visible to anyone who prints the document later.

The process takes about two minutes and works the same way in Excel for Windows, Mac, and the web version. You'll use the Insert menu to reach the header and footer settings, then place your watermark there. If you need the watermark to show on screen as you work, there's a separate method using a shape or image that sits on top of your spreadsheet.

Key Takeaways

  • Excel's header and footer watermark appears only when you print or save as PDF, not while editing the spreadsheet.
  • You access watermarks through Insert > Header & Footer on the Insert tab, then choose to add text or an image behind your data.
  • If you need the watermark visible while working, you can insert a shape or image directly onto the sheet and send it to the back layer.
  • A watermark added through headers and footers will print on every page of a multi-page spreadsheet automatically.
  • Text watermarks work best with large, light-colored fonts so they don't obscure the data underneath.

Adding a text watermark through headers and footers

Open your spreadsheet in Excel and click the Insert tab at the top. Look for the Header & Footer button — it's usually in the right section of the ribbon. Click it, and Excel will switch to a special editing view where you can see three boxes: one for the left header, one for the center, and one for the right.

Click in the center header box (or whichever position you prefer). Then click the button labeled "Picture" or "Image" — this is where the watermark option lives. A dialog box will open asking you to choose a file from your computer. Select the image you want to use as a watermark, then click Insert. Excel will add a placeholder like <Picture> to show the image is there.

Once the image is inserted, right-click on it and look for an option like "Format Picture" or "Picture Properties". Find the transparency or brightness settings and increase the transparency to 50 to 70 percent so the watermark fades into the background and doesn't hide your data. Click outside the header area when you're done, and the watermark will be set.

Adding a text watermark instead of an image

If you want words instead of a picture — like "DRAFT" or "CONFIDENTIAL" — the process is similar but simpler. Open Insert > Header & Footer again and click in the center header box. This time, instead of clicking Picture, just type the text you want directly into the box.

The text will appear very small and dark at first. To make it look like a watermark, you need to format it. While your cursor is still in the header box, select all the text you just typed (Ctrl+A on Windows, Command+A on Mac). Then look for formatting buttons — usually a font dropdown and a size dropdown — and choose a large font size like 48 or 60 points. You can also change the color to light gray so it doesn't interfere with reading your data.

Text watermarks work best when they're diagonal across the page, but Excel's header and footer don't rotate text automatically. If you need a diagonal watermark, the image method works better — you can create the text in a graphics program, rotate it there, and then insert it as an image.

Making a watermark visible while you edit

The header and footer watermark only shows when you print or export to PDF. If you need to see the watermark on screen as you work, you'll add it directly to the spreadsheet instead. Click Insert > Shapes and choose a rectangle or another shape. Draw it across your spreadsheet, then right-click and select "Edit Text" to type your watermark text inside it.

Format the shape by right-clicking and choosing "Format Shape". Set the fill color to light gray or white, the text color to a lighter gray, and increase the transparency. Then right-click the shape again and choose "Send to Back" — this moves it behind your data so you can still click on cells and enter information normally.

This method has a drawback: the shape stays with the spreadsheet file, so anyone who opens it will see the watermark. If you only want it to print, use the header and footer method instead. Also, a shape watermark will print on every page, but it won't automatically resize if your data extends to a new page, so the header and footer method is usually more reliable for multi-page documents.

Checking how your watermark will look when printed

Before you print, use Print Preview to see exactly how the watermark will appear. Click File > Print, and Excel will show you a preview of the first page on the right side of the screen. Scroll through the preview to check that the watermark is visible but not so dark that it hides your numbers and text.

If the watermark is too dark, go back and increase the transparency. If it's too light and hard to see, decrease the transparency slightly. You can also adjust the size of an image watermark by going back to Insert > Header & Footer, right-clicking the picture placeholder, and choosing a size option.

Remember that the watermark will appear on every page of the printed document. If your spreadsheet is very long, check the preview on the last page too to make sure the watermark looks consistent throughout.

Removing a watermark you no longer need

To remove a watermark added through headers and footers, click Insert > Header & Footer again. Click in the header box where the watermark is, select all the text or the picture placeholder, and press Delete. Click outside the header area, and the watermark is gone.

If you added a watermark as a shape directly on the spreadsheet, click on the shape to select it and press Delete. The shape will disappear when ready, and your spreadsheet will return to normal.

Watermarks in Excel Online and shared spreadsheets

Excel Online (the web version) supports watermarks through headers and footers, but the process is slightly different. Open your spreadsheet, click Insert, and look for "Header and Footer" in the menu. The steps are the same as the desktop version, though some formatting options may be limited.

If you're sharing a spreadsheet with others through OneDrive or SharePoint, watermarks added through headers and footers will be preserved when others open the file. However, watermarks added as shapes may not display the same way on all devices, so the header and footer method is more reliable for shared documents.

Frequently Asked Questions

Will the watermark print if I only want to see it on screen?

No — watermarks added through headers and footers only appear when you print or export to PDF. If you need it visible while editing, insert a shape or image directly onto the spreadsheet instead. Just remember that others who open the file will see it too.

Can I make a watermark diagonal like in Word?

Excel's header and footer don't rotate text automatically. To get a diagonal watermark, create the text in an image editor, rotate it there, save it as a picture, and then insert that picture into the header. Alternatively, insert a shape directly on the spreadsheet and use the rotation handle to angle it.

What if my watermark looks different when I print than in the preview?

Printer settings can affect how watermarks appear. Check that your printer is set to print graphics and backgrounds — some printers have this turned off by default. Also verify that the transparency level is correct in the watermark formatting. If the watermark still looks wrong, try adjusting the brightness or contrast slightly.

Can I use a company logo as a watermark?

Yes. Insert the logo as an image through Insert > Header & Footer, then increase its transparency so it fades into the background. Make sure the logo is large enough to be recognizable but light enough that it doesn't hide your data. Test it in Print Preview first.

Do I have to add the watermark to every sheet in the workbook?

No. When you add a watermark through headers and footers, it applies to all sheets in the workbook automatically. If you want different watermarks on different sheets, you'll need to add shapes directly to each sheet instead of using the header and footer method.