How to Add a Watermark in MS Excel

You’ve built a stunning Excel report — clean data, sharp charts, hours of work.

Then someone forwards it without credit. Or worse, it gets printed and shared without your company name on it.

That’s the pain watermarks solve.

Adding a watermark in Excel isn’t just about looking polished. It’s about protecting your data, branding your documents, and controlling how your work is perceived. According to a Ponemon Institute study, 60% of data breaches involve internal documents that lacked proper access controls or identification markers. A watermark won’t stop a determined bad actor — but it sends a clear signal: this document belongs to someone.

Whether you’re sending a confidential report to a client, sharing a draft internally, or distributing branded materials, knowing how to watermark in Excel is a skill that saves you headaches.

Let’s get into it.

Why Watermarks Matter More Than You Think

Before the how, let’s quickly cover the why — because most people skip this step and then wonder why their work shows up unattributed somewhere.

Here’s what the data says:

• 73% of professionals admit to sharing documents without proper authorization at least once (Shred-it, 2023)
• Organizations that use document branding and identification markers report 34% fewer unauthorized distribution incidents
• 43% of small businesses experienced a data leak through improperly shared files in the past year
• Documents marked “Confidential” or “Draft” are 2x less likely to be forwarded externally compared to unmarked ones

Watermarks are a lightweight, zero-cost layer of protection and professionalism. And in Excel, setting one up takes under two minutes once you know the method.

Method One: Add a Watermark Using Header and Footer

This is the most reliable and universally compatible method. It works across all Excel versions and prints cleanly every time.

Step 1 — Open your Excel workbook

Open the file you want to watermark. Make sure you’re on the sheet you want to mark.

Step 2 — Go to Page Layout View

Click the View tab in the ribbon at the top. Then select Page Layout from the Workbook Views group. Your sheet will shift into a print-preview-style layout with visible margins and header/footer areas.

Step 3 — Click on the Header area

You’ll see a faint dotted area at the top of the page that says “Click to add header.” Click on it.

The Header & Footer Tools tab (Design tab) will appear in the ribbon.

Step 4 — Insert a Picture into the Header

In the Design tab, click Picture under the Header & Footer Elements group. A dialog box will open. Browse and select your watermark image (this should be a PNG or JPEG with a transparent or light background — more on creating one below).

Your header will show &[Picture] as a placeholder.

Step 5 — Format the Picture

Click Format Picture (next to the Picture button) in the Design tab. Go to the Size tab and adjust the height/width to cover your sheet proportionally. Then go to the Picture tab and reduce the Color to Washout — this gives it that classic semi-transparent watermark look.

Step 6 — Click outside the header

Click anywhere in the sheet body. Your watermark is now live and will appear on every printed page.

Pro tip: Use Page Layout view to check how it looks before printing. Adjust the image size in Format Picture until it sits centered and proportional on the sheet.

Method Two: Add a Watermark Using WordArt

If you want a text-based watermark — like “DRAFT,” “CONFIDENTIAL,” or your company name — WordArt is the fastest way to do it directly on the sheet.

Step 1 — Go to the Insert Tab

Click Insert in the ribbon, then click WordArt in the Text group. Choose a simple, clean style (the first or second option works best for watermarks).

Step 2 — Type your watermark text

A text box will appear on your sheet. Type your watermark text — “CONFIDENTIAL,” “DRAFT,” “INTERNAL USE ONLY,” or your brand name.

Step 3 — Format the WordArt

Select the WordArt. Go to the Shape Format tab.

• Increase the font size to something between 60–100pt so it spans the sheet
• Change the font color to a light gray (try RGB: 192, 192, 192)
• Use Text Effects > Transform to angle the text diagonally across the sheet (the diagonal option is usually in the “Follow Path” or “Warp” sections)

Step 4 — Reduce Transparency

With the WordArt selected, right-click and choose Format Shape. Go to Text Options > Text Fill and adjust the Transparency slider to 60–80%. This creates a light, see-through effect.

Step 5 — Position and Lock

Drag the WordArt to the center of your sheet. Right-click > Format Shape > Properties > select “Don’t move or size with cells” to prevent it from shifting when rows or columns change.

Important note: WordArt watermarks are visible on screen but may not print as expected depending on your print settings. Go to File > Print > Page Setup > Sheet and make sure “Draft quality” is unchecked to ensure it prints.

Method Three: Use a Background Image (Screen Display Only)

This method is quick but comes with one major limitation — background images don’t print. Use this only if you need an on-screen visual marker, not a printed one.

Step 1 — Go to Page Layout

Click the Page Layout tab in the ribbon.

Step 2 — Click Background

In the Page Setup group, click Background. A file browser will open.

Step 3 — Select your watermark image

Choose your watermark image file. Excel will tile it as the sheet background.

Step 4 — Adjust your image

Because Excel tiles background images, you’ll want to use a large image (at least 1000x1000px) that’s designed to cover the full sheet without awkward repeating. A single centered diagonal text on a white/transparent background works best.

When to use this method: Internal reviews, screen-recorded demos, or presentations where printing isn’t a concern. If your team works primarily digitally and you just need a visual reminder that a sheet is in draft mode, this is the fastest option.

🎯 RIGHT SIDE STICKY BANNER

[BANNER PLACEMENT: This banner sits fixed on the right side of the page, visible as the user scrolls through the article. Ideal trigger: appears once the user reaches the “Method Two” section — at the point they realize document protection and professional presentation matter.)]

BEFORE (content just above where banner becomes relevant):

“Whether you’re sending a confidential report to a client, sharing a draft internally, or distributing branded materials, knowing how to watermark in Excel is a skill that saves you headaches.”

Choosing the Right Method: A Quick Comparison

How to Create a Watermark Image for Excel

Excel doesn’t have a built-in watermark designer, so you’ll need a simple image file. Here’s the fastest way to make one:

Using PowerPoint (already on your computer):

1. Open PowerPoint, go to Insert > Text Box
2. Type your watermark text (“CONFIDENTIAL,” your logo text, etc.)
3. Set font size to 80–120pt, color to light gray
4. Rotate the text box 45 degrees
5. Go to File > Save As > save as PNG
6. That PNG is your watermark image — import it into Excel using the Header & Footer method

Using free tools:

Tools like Canva, Adobe Express, or Remove.bg let you create transparent-background watermark images in minutes. A transparent PNG will look cleanest in Excel’s header/footer.

Common Mistakes to Avoid

Mistake: Using a dark or opaque watermark image

A watermark should be subtle, not distracting. If your watermark covers the data beneath it, it defeats the purpose. Always use a washout effect or reduce opacity significantly.

Mistake: Assuming the background image will print

It won’t. Excel’s background image feature is screen-only. If you need printed watermarks, use the Header & Footer method.

Mistake: Not testing before distribution

Always do a Print Preview (Ctrl + P, then check the preview pane) before sending a watermarked file. What looks right on screen sometimes shifts or disappears in print.

Mistake: Forgetting to protect the sheet

A watermark discourages unauthorized sharing — it doesn’t prevent editing. If you want to truly protect the document, go to Review > Protect Sheet after adding your watermark.

According to Microsoft’s own documentation, sheet protection combined with visual markers (like watermarks) is the recommended approach for distributing sensitive Excel files.

How to Remove a Watermark in Excel

Sometimes you’ll need to strip a watermark — when a draft becomes final, for example, or when you’re updating a template.

For Header & Footer watermarks: Go to View > Page Layout > click the header area > select the &[Picture] placeholder > delete it.

For WordArt watermarks: Click on the WordArt object > press Delete.

For Background images: Page Layout tab > Background > the button will now say Delete Background — click it.

Conclusion

Adding a watermark in Excel takes less than two minutes — but the professional credibility and document protection it adds lasts every time that file is opened, printed, or shared.

Here’s a quick recap of what you’ve learned:

• Header & Footer method — best for printed, professional documents; supports images and logos
• WordArt method — best for fast text-based stamps like “DRAFT” or “CONFIDENTIAL”
• Background Image method — best for screen-only display, does not print

The most important step? Actually doing it. Open your next report, add a watermark in under two minutes, and send it knowing it’s properly branded and protected.

If you want to take your professional outreach to the next level — beyond just polished documents — the team at SalesSo builds complete outbound lead generation systems across cold email, LinkedIn, and cold calling. Precise targeting, campaign design, and scaling methods that consistently deliver results. Book a free strategy meeting →