How to Insert an Image as a Watermark in Excel for Printing

To add an image watermark to an Excel printout, place the image in the worksheet’s header: in Excel for Microsoft 365 on Windows, choose Insert > Text > Header & Footer, click a header section, then use Header & Footer > Picture to select the image. This method prints the watermark on the page without covering or changing cell data. Excel does not show a header image in Normal view, so use Page Layout view or Print Preview to check it.

What You’ll Need

Excel for Microsoft 365 desktop on Windows or Mac. Excel for the web does not provide the same complete controls for inserting and formatting a picture in a header, so use the desktop app for this task.
An image file, such as a PNG or JPG logo. A simple, pale image with a transparent background usually works best. If you want a text watermark such as DRAFT, create it as an image first.
A printer or a way to save the worksheet as a PDF if you want to check the finished printed page.

Step-by-Step

Open the worksheet and select the sheet to watermark. Save the workbook before making layout changes. Header and footer settings belong to individual worksheets, so adding the watermark to one sheet does not automatically add it to every sheet in the workbook. If you want the same image on several sheets, you can group the relevant sheet tabs before changing the header, but check the result on each sheet and ungroup the tabs when finished.
Switch to a view where the header can be edited. On Windows, select Insert > Text > Header & Footer. Excel changes to Page Layout view and shows the page boundaries and header areas. You can also select View > Page Layout and click in the header area at the top of a page. In Excel for Mac, use Insert > Header & Footer, then click in a header section. The exact ribbon layout can vary slightly with window size, but the goal is to activate the worksheet’s header.
Choose where the image should sit across the page. The header has left, center, and right sections. Click the section that best matches the position you want: the center section is a practical starting point for a logo or central watermark, while a left or right section can suit a corner mark. The image is positioned in relation to the page margins and header area, not freely dragged to any cell. If you need a precisely centered image, prepare the image with blank space around it or adjust its alignment and size in the header controls.
Insert the picture into the selected header section. With the insertion point active in that section, select the Header & Footer tab on the ribbon and choose Picture. Depending on the Excel window, Picture may appear in the Header & Footer Elements group. Browse to the image file, select it, and choose Insert. Excel adds a picture placeholder, often shown as &[Picture], in the header. That placeholder is expected; the image itself may not display while you are editing the header text.
Soften the image so it reads like a watermark. Keep the header section active and choose Format Picture on the Header & Footer tab. In the Format Picture dialog, open the Picture controls and use the Color setting, such as Washout, if it is available. You can also adjust brightness and contrast to make the image less prominent. The exact controls may vary by Excel build and image type. If the picture still looks too dark, edit a copy in an image editor to fade it, then insert that lighter copy instead.
Set a suitable size. In the Format Picture dialog, use the Size controls to adjust the height and width. Preserve the image’s aspect ratio so a circular logo does not become oval or text become distorted. Start with a modest size, close the dialog, and inspect the page. A large image can overlap printed content even though it is in a header, particularly when the worksheet has narrow margins or little space between the header and data.
Check page layout and printing options. Select Page Layout > Margins to choose a margin preset or set custom margins. If the header is too close to the page edge, increase the header margin in Page Setup. Open Page Layout > Page Setup using the small dialog launcher in the group, then check the Header/Footer options. Settings such as Different first page or Different odd and even pages can cause a watermark to appear on only some pages or in a different header section. Turn those options off if you want a consistent header throughout the sheet.
Preview the result before printing or sharing. Choose File > Print to open Print Preview, or use View > Page Layout to inspect the page on screen. Check that the image is faint enough to keep text readable, appears on the intended pages, and is not clipped at the edges. If the worksheet spans multiple pages, use the preview navigation to check more than the first page. Adjust the image size, header margin, scaling, or page orientation as needed, then save the workbook.

Common Mistakes

Expecting the watermark to show in Normal view: Header pictures are designed for page layout and printing, so Excel normally hides them in the standard grid view. Check in Page Layout view or Print Preview rather than inserting the image again because it appears to be missing.

Using Page Layout > Background as a print watermark: That command adds a worksheet background for on-screen display; it is not printed as a page watermark. Use the header picture method when the image needs to appear on paper or in a PDF.

Putting the image directly over cells: An image placed with Insert > Pictures is a floating object on the worksheet. It may cover cell content, move when rows or columns change, and not repeat on each printed page. That approach can be appropriate for a one-off on-screen design, but it is not the same as a repeating print watermark.

Choosing an image that is too dark or too detailed: A high-contrast photo can make numbers and labels hard to read. Use a simple mark, fade it with Washout or an image editor, and judge the result at actual print size rather than only while zoomed in.

Forgetting that headers are sheet-specific: A workbook can contain multiple worksheets with separate header settings. Confirm which sheets need the watermark, and do not assume that adding it once applies workbook-wide.

Tips

Use a PNG with a transparent background for a logo, especially if the page has colored cells or a non-white print area. A white rectangle around the logo can look like a block laid over the worksheet.
Keep a separate, faded copy of the original image. That lets you adjust the watermark without reducing the quality of the logo or artwork used elsewhere.
Set the page orientation, paper size, and scaling before finalizing the image size. Fit-to-page scaling can change how large the watermark looks on the printed sheet.
For a large central watermark, the image file’s own proportions and empty space affect its apparent placement. If Excel’s header alignment is not flexible enough, add whitespace around the graphic in an image editor and insert the updated file.
Save a PDF from File > Export or File > Save As and choose PDF, then inspect it at normal page size. A PDF preview can reveal clipping and contrast problems before you use paper.

Troubleshooting

The image is not visible in the worksheet grid: This is expected for a header picture in Normal view. Switch to View > Page Layout or open File > Print. If it is missing there too, click the header section and confirm that the picture placeholder is still present. Reinsert the image if necessary.

The watermark does not print: First check Print Preview. If the image is absent, make sure you inserted it as a header picture rather than using Page Layout > Background. Check the sheet’s Header/Footer settings and confirm that the header is not disabled for the relevant page. Also review Different first page and Different odd and even pages; those options can give pages separate headers that need their own picture.

The watermark appears on the first page but not later pages: Open the Header/Footer options in Page Setup and check whether Different first page or Different odd and even pages is selected. If you need a mark on every page, either turn off the special header options or insert a picture into each header section Excel uses for those page types.

The image is cut off or positioned too high: Reduce its size in Format Picture, increase the header margin in Page Setup, or revise the worksheet’s page margins. Then review Print Preview again. The printable area depends on paper size and printer settings, so a design that fits one printer may be clipped by another.

The image is still too strong: Try the Washout color option, lower the contrast, or create a lighter version in an image editor. If the logo contains fine lines or small lettering, fading it too much can make it disappear on a printed page; use a simpler, larger graphic instead.

The Picture button or formatting controls are unavailable: Click inside a header section first. Excel shows the contextual Header & Footer tab only when the header or footer is active. If you are using Excel for the web, open the workbook in the desktop app to access the full picture-header controls.

Frequently Asked Questions

Can I see an image watermark while editing cells in Normal view?
Not when it is inserted in the header. Use Page Layout view to see the page layout, or Print Preview to see how it will print. A floating picture placed over cells can be visible in Normal view, but it behaves differently and does not automatically repeat on printed pages.

Will the watermark appear on every printed page?
Normally, a header picture repeats on the pages printed from that worksheet. Different first page and Different odd and even pages can create exceptions, so check those settings and preview multiple pages.

Can I use words such as CONFIDENTIAL or DRAFT?
Yes. Create the wording as an image in an image editor or another suitable program, preferably with a transparent background, then insert it into the header the same way as a logo. Excel’s header picture control inserts an image file rather than a typed watermark label.

Can I make the watermark appear behind cells?
A header picture is printed as part of the page header and does not sit in the cell grid as a background layer. Excel’s worksheet background command does not print. If you place a picture over cells, it may obscure data, so use a faded image and test the printout carefully if that is the design you need.

Can I add the same watermark to several worksheets at once?
You can group the target sheet tabs and make a shared header change, but take care: while sheets are grouped, edits can affect every selected sheet. Verify that the sheets have compatible page layouts, then ungroup them and inspect each one. Otherwise, add the header image to each worksheet separately.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.