Excel watermarks protect your spreadsheets by adding text or an image across the background

A watermark in Excel is a faint image or text that appears behind your data on every printed page. Unlike a header or footer, which sits in the margins, a watermark sits directly behind your cells. Excel does not have a dedicated watermark button — instead, you create one by inserting an image into the header, which is the simplest method that works across all versions.

The most common watermarks are text (like "CONFIDENTIAL" or "DRAFT") or company logos. Because watermarks sit in the background, they do not interfere with your data, formulas, or sorting. They are visible when you print or export to PDF, but not always on screen unless you switch to Page Layout view.

Key Takeaways

  • The fastest way to add a watermark is through the Insert menu, then Header & Footer, then Picture, which places an image behind all pages.
  • Text watermarks require you to create or find an image file first — Excel cannot convert typed text directly into a watermark.
  • Watermarks appear on printed pages and PDFs but may not show in Normal view; switch to Page Layout view to see them on screen.
  • Once added, a watermark applies to the entire sheet, not individual cells, and will print on every page of that sheet.
  • Removing a watermark means going back to Header & Footer and deleting the picture, or clearing the header entirely.

Adding an image watermark through the header

Open your spreadsheet in Excel. Click the Insert tab at the top of the screen. In the ribbon, find the Header & Footer button — it is usually in the Text group, though the exact location varies slightly by Excel version. Click it.

A dialog box opens. You will see three sections: Left Header, Center Header, and Right Header. Click in any of these boxes — it does not matter which one, because the watermark will appear behind the entire page regardless. Then click the Picture button, which appears below the header boxes.

A file browser opens. Navigate to the image file you want to use as a watermark. This can be a PNG, JPG, or other common image format. Select the file and click Insert. Excel inserts a code like &[Picture] into the header box. Click OK to close the dialog.

Switch to Page Layout view to see the watermark on your spreadsheet. In the View tab, click Page Layout. Your watermark now appears faintly behind your data. If it is too dark or too light, you will need to adjust the image file itself in a photo editor before reinserting it.

Creating a text watermark using an image file

Excel does not let you type text directly into a watermark field. Instead, you must create an image of the text first. The simplest way is to use a free online tool or your computer's built-in image editor.

On Windows, open Paint (search for it in the Start menu). Create a new image with a white background. Use the text tool to type your watermark text — "CONFIDENTIAL", "DRAFT", or whatever you need. Make the text large and bold so it is visible when scaled down. Save the file as a PNG or JPG.

On Mac, open Preview and create a new image the same way, or use a free online tool like Canva (canva.com) to design text, then read it as an image. Once you have the image file, follow the steps in the previous section to insert it into your header.

If you want the text to appear at an angle (rotated 45 degrees, as watermarks often do), you will need to rotate it in your image editor before saving. Most online watermark generators do this automatically — search for "free watermark generator" and upload your text to create a ready-made image.

Adjusting watermark visibility and size

When you insert an image as a watermark, Excel scales it to fit the page, but you cannot resize it directly from Excel. If your watermark is too large or too small, edit the original image file and reinsert it.

To make a watermark fainter, open the image in a photo editor and reduce its opacity or brightness before saving. A watermark should be visible enough to read but faint enough that it does not obscure your data. Most watermark tools let you adjust opacity as a percentage — aim for 20 to 40 percent opacity.

If you want the watermark to appear only on certain pages, you will need to create separate sections in your spreadsheet using page breaks, then insert different headers in each section. This is more complex and requires using the Design tab under Header & Footer options to set different headers for different sections.

Viewing and printing your watermark

Watermarks do not always appear in Normal view. To see them while working, switch to Page Layout view (View tab, then Page Layout). In this view, you see your spreadsheet as it will print, including the watermark behind your data.

When you print your spreadsheet, the watermark prints on every page. To print a preview before committing to paper, go to File, then Print, and look at the preview pane on the right. You will see the watermark in the preview.

If you export your spreadsheet to PDF, the watermark will appear in the PDF as well. Use File > Export As > Create PDF to see the watermark in the exported file.

Removing or changing a watermark

To remove a watermark, go back to the Insert tab and click Header & Footer. In the dialog, find the header section that contains the &[Picture] code. Delete the code and click OK. The watermark disappears when ready.

To change the watermark to a different image, delete the &[Picture] code as above, then insert a new image using the Picture button. You can only have one watermark per sheet, so inserting a new image replaces the old one.

If you want to remove the watermark from only some pages, you will need to use section breaks and different headers for different sections — a more advanced technique that requires planning your page layout before you start.

Troubleshooting common watermark problems

The watermark does not appear on screen. You are likely in Normal view. Switch to Page Layout view (View tab) to see watermarks. They may not show in Normal view but will still print.

The watermark appears too dark or too light. Edit the original image file to adjust brightness or opacity, then reinsert it. You cannot adjust it from within Excel.

The watermark looks blurry or pixelated. The image file may be too small or low resolution. Use a larger, higher-resolution image file. For text watermarks, create the text at a larger size in your image editor before saving.

The watermark does not print. Check your printer settings — some printers have an option to print backgrounds or graphics that must be enabled. Also verify that the image file is not corrupted by trying to open it in a photo viewer.

Frequently Asked Questions

Can I add a watermark to just one page of my spreadsheet?

Not directly. Watermarks explore to the entire sheet. To watermark only some pages, you must create section breaks and assign different headers to different sections. This is complex and requires planning your page layout in advance. For most users, it is simpler to add the watermark to the whole sheet.

What image format works best for watermarks?

PNG and JPG both work well. PNG is better if your watermark has a transparent background, because the transparency will show through to your spreadsheet. JPG works fine for solid backgrounds. Keep the file size small — under 1 MB — so Excel does not slow down when opening the file.

Can I use a company logo as a watermark?

Yes. Insert your logo image as described in the header section. If the logo is too dark, open it in a photo editor and reduce the opacity before saving. Most company logos work well as watermarks at 20 to 30 percent opacity.

Will the watermark appear if someone opens my spreadsheet on a different computer?

Yes, as long as the image file is embedded in the header. The watermark is part of the spreadsheet file itself, not a separate file, so it travels with your spreadsheet. However, if the original image file is missing or corrupted, the watermark may not display.

Can I add a watermark to an Excel template so it appears in all files created from that template?

Yes. Add the watermark to your template file using the header method, then save the file as a template (.xltx). Any new spreadsheet created from that template will include the watermark automatically.