How to Make a Watermark in Excel

A watermark can be added to a document to add security, specify information or simply give the document a more polished and professional appearance. While you cannot create an actual watermark in Excel, you can mimic a watermark with a graphic that prints on every page of your spreadsheet.

Mid adult business man working on laptop at outdoor cafe table
credit: moodboard/moodboard/Getty Images

Step

Open the Excel workbook in which you want to create a watermark.

Step

Click View on the Excel toolbar, or use the keyboard shortcut "Alt" plus "V."

Step

Click the View menu and select Header and Footer.

Step

Choose Custom Header in the Page Setup dialog box that appears. Click the "Center Section" so your cursor is active in the corresponding field.

Step

Click the "Insert Picture" button on the right; this button has a picture of mountains and the sun. Navigate to the picture that you wish to use as a watermark and double-click the graphic to insert it.

Step

Click the "Format Picture" button on the far right of the Header dialog box. Resize the picture to fit your page using the options on the Size tab.

Step

Click the Picture tab. Under Image Control in the drop-down menu next to "Color" choose Washout. This will give your graphic a watermark appearance.

Step

Click "OK" on the Format Picture dialog, and again on the Header and Page Setup dialogs.