Excel watermarks appear behind your data on every printed page

A watermark in Excel is text or an image that shows up behind your spreadsheet data when you print. It does not appear on screen while you work — only when you print the sheet or export it as a PDF. Excel does not have a dedicated watermark button like Word does, so you add one through the Header & Footer section of Page Setup.

The most common watermarks are text like "DRAFT", "CONFIDENTIAL", or "DO NOT DISTRIBUTE". You can also use a company logo or image, though text is simpler to set up and works reliably across different printers and computers.

Key Takeaways

  • Text watermarks go in the Header & Footer section under Page Setup, not in the spreadsheet itself.
  • Watermarks only show when you print or export to PDF — they do not appear while editing.
  • Image watermarks require you to insert a picture into the header, which takes a few extra steps but works on any sheet.
  • Once you add a watermark, it applies to all pages of that sheet unless you change it again.

Add a text watermark in three steps

Open the sheet you want to watermark. Go to the Page Layout tab at the top of the ribbon (in Excel 2010 and later) or the Insert tab (in Excel 2016 for Mac). Click Page Setup — it is a small arrow in the bottom right corner of the Page Setup group. A dialog box will open.

Click the Header/Footer tab. You will see three text boxes: one for the left side of the header, one for the center, and one for the right. Click in the center box and type your watermark text — "DRAFT" or "CONFIDENTIAL" or whatever you need. Click OK.

Go to File > Print to see a preview. Your watermark will appear faintly behind the data on the preview. If it looks right, print the sheet. If you want to remove the watermark later, go back to Page Setup, delete the text from the header, and click OK.

Add an image watermark using the header

Image watermarks work the same way as text, but you insert a picture instead of typing. Open Page Setup again and click the Header/Footer tab. Click in the center box (or whichever side you prefer). You will see a button labeled Picture near the text boxes — click it.

A file browser will open. Navigate to the image file on your computer — a PNG, JPG, or other common format works. Select it and click Insert. The image will not appear in the text box itself, but a code like "&[Picture]" will show up. Click OK to close Page Setup.

Go to File > Print to preview. The image will appear behind your data on the preview. If it is too dark or too light, you may need to adjust the image brightness in a photo editor before inserting it again. Remove an image watermark the same way you remove text — go back to the header, delete the code, and click OK.

Control where the watermark appears on the page

By default, a watermark in the center header appears in the middle of the page. If you want it in a corner instead, use the left or right header box in Page Setup rather than the center. A watermark in the left header box will appear in the top left corner of each printed page.

You can also add different watermarks to different sheets in the same workbook. Each sheet has its own header and footer settings. Open the sheet, go to Page Setup, add the watermark you want, and click OK. Then switch to the next sheet and repeat. This is useful if some sheets are drafts and others are final.

Make sure your watermark prints correctly

Watermarks sometimes do not print if your printer settings are wrong. Before printing, go to File > Print and look at the preview on the left. If you see the watermark there, it will print. If you do not see it in the preview, it will not print either.

If the watermark does not show in the preview, check two things. First, make sure you actually clicked OK after adding the watermark to the header — if you closed the dialog without clicking OK, the change did not save. Second, check that your printer is set to print graphics or images. Some printers have a "text only" mode that skips watermarks. Look in your printer settings and switch to "normal" or "best" quality.

Remove a watermark when you no longer need it

Open Page Setup again and click the Header/Footer tab. Delete any text or code from all three header boxes (left, center, and right). Click OK. The watermark will no longer appear on printed pages.

If you want to keep the watermark but hide it temporarily, you can also print to PDF instead of a physical printer. Some PDF readers let you flatten the document without the watermark, though this depends on your PDF software. The simplest approach is to remove the watermark from the header if you do not need it anymore.

Frequently Asked Questions

Can I see the watermark while I am editing the spreadsheet?

No. Watermarks only appear when you print or export to PDF. While you work in Excel, the spreadsheet looks normal. This is by design — the watermark is part of the print layout, not the actual data.

What if I want different watermarks on different pages of the same sheet?

Excel does not support different watermarks on different pages within a single sheet. The header and footer apply to every page of that sheet. If you need different watermarks, you would need to split the data into separate sheets, each with its own watermark.

Can I make the watermark bigger or change its color?

For text watermarks, you cannot control size or color directly from the header box. You would need to insert a text box with the watermark text into the sheet itself, format it as you want, and then print. For image watermarks, you can resize and edit the image in a photo editor before inserting it into the header.

Does the watermark print the same way on every printer?

Watermarks may look slightly different depending on the printer and its settings. Some printers print them lighter or darker than others. Always print a test page first to see how it looks on your specific printer before printing a large batch.

If I email the spreadsheet to someone else, will they see the watermark?

They will only see the watermark when they print the sheet or export it to PDF. The watermark does not appear on their screen while they edit. If they open the file and print it, the watermark will print on their copy.