You need to mark a spreadsheet as a draft or confidential, but you do not want the watermark to appear on printed copies. Excel does not have a built-in watermark feature like Word. Users often try to insert an image or text box, which then prints by default. This article explains how to place a visual watermark in the sheet background that will not output to a physical printer or PDF.
Key Takeaways: Add a Non-Printing Watermark in Excel
- Page Layout > Background: Inserts an image as a sheet background that is visible on screen but excluded from all printing.
- Insert > Text Box & Format Shape > No Fill for Shape Fill: Creates a text watermark that can be set to not print via the object formatting options.
- Page Layout tab > Page Setup launcher > Sheet tab > untick ‘Draft quality’: Ensures background elements are not printed due to a common draft setting.
Understanding Excel’s Background and Printing Settings
A true watermark is typically a semi-transparent image or text behind the main content. In Excel, the closest native feature is the Sheet Background, accessed from the Page Layout tab. This method inserts a picture that tiles across the entire worksheet. Crucially, this background is designed for on-screen display only and is never included in printouts or PDF exports. For text-based watermarks like “DRAFT,” you must use other objects, such as WordArt or text boxes, and manually configure their print properties. The key is to use elements that reside in the sheet layer but are explicitly formatted to be excluded from the print area.
Steps to Insert a Non-Printing Image Watermark
The most reliable method uses the Sheet Background feature. This ensures the image is only for on-screen reference.
- Go to the Page Layout tab
Open the Excel workbook and select the worksheet where you want the watermark. - Click the Background button
In the Page Setup group, click the Background button. This opens the Insert Picture dialog. - Choose your image source
Select From a File to browse your computer. Choose a PNG or JPG image with the desired text or logo. Click Insert. - Verify the background is applied
The image will tile across the entire sheet behind your cells. It will not appear in Print Preview or on any printed page.
Using a Text Box for a Custom Text Watermark
If you need a single, large text watermark, use a text box. You must adjust its properties to prevent printing.
- Insert a text box or WordArt
Go to Insert > Text > Text Box. Draw a large box on the sheet. Type your text, like “CONFIDENTIAL.” You can also use Insert > WordArt for stylized text. - Format the text object
Right-click the text box border and select Format Shape. The Format Shape pane will open on the right. - Disable printing for the object
In the Format Shape pane, click the Size & Properties icon. Expand the Properties section. Uncheck the box for ‘Print object’. - Adjust transparency and position
In the Format Shape pane, under the Fill & Line tab, adjust the Transparency slider under Fill to make the text see-through. Drag the object to the center of your sheet.
Common Mistakes and Limitations to Avoid
Watermark Still Prints on Some Printers
If a background element prints, check the Page Setup settings. Go to Page Layout > Page Setup launcher > Sheet tab. Ensure the ‘Draft quality’ option is not checked. This setting can cause unexpected printing of background elements. Also, verify the ‘Print’ box for any shapes or text boxes is unchecked in their Format Shape pane.
Background Image Is Too Dark or Obscures Data
The Sheet Background feature does not offer transparency controls. You must edit the image file itself before inserting it. Use an image editor to reduce opacity or lighten the image. For a text box, use the Transparency slider in the Format Shape fill options to make it faint.
Watermark Does Not Appear on All Worksheets
The Sheet Background is set per worksheet. You must repeat the process for each sheet. You cannot apply one background to an entire workbook. Consider using the text box method, then copy and paste the formatted text box onto other sheets.
Sheet Background vs. Header/Footer Watermark: Key Differences
| Item | Sheet Background (Page Layout > Background) | Header/Footer Watermark (Insert > Header & Footer) |
|---|---|---|
| Primary Use | On-screen visual marker only | Printed document watermark |
| Prints to Paper/PDF | No | Yes |
| Editing Flexibility | Low (must replace entire image) | Medium (text can be edited in header) |
| Position Control | Tiled across entire sheet | Centered in page header/footer area |
| Best For | Internal draft status indicators | Final documents requiring a printed stamp |
You can now add a “DRAFT” or “CONFIDENTIAL” mark to your Excel sheet that stays on screen. Use the Page Layout > Background method for a guaranteed non-printing image. For a single large text watermark, insert a text box and uncheck ‘Print object’ in Format Shape. Next, try using the Page Color feature to apply a solid color background that also does not print. For advanced control, use the Camera tool to take a picture of your watermark text box and set that linked picture to not print.