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.
Open the Excel workbook in which you want to create a watermark.
Click View on the Excel toolbar, or use the keyboard shortcut "Alt" plus "V."
Click the View menu and select Header and Footer.
Choose Custom Header in the Page Setup dialog box that appears. Click the "Center Section" so your cursor is active in the corresponding field.
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.
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.
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.
Click "OK" on the Format Picture dialog, and again on the Header and Page Setup dialogs.
Tips & Warnings
- You can see how your "watermark" will appear by going to Print Preview from either the File menu or the Page Setup dialog box.