How to Make a Watermark in Excel

By triciagoss

You can mimic a watermark in Excel. You can mimic a watermark in Excel.

Rate: (0 Ratings)

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.

Instructions

Difficulty: Moderately Easy

Step1
Open the Excel workbook in which you want to create a watermark.
Step2
Click “View” on the Excel toolbar, or use the keyboard shortcut “Alt+V."
Step3
From the “View” menu, click “Header and Footer."
Step4
In the “Page Setup” dialog box, choose “Custom Header." Click in the “Center Section” so that your cursor is active in the corresponding field.
Step5
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.
Step6
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.
Step7
Click on the “Picture” tab. Under “Image Control” in the drop-down menu next to “Color” choose “Washout." This will give your graphic a watermark appearance.
Step8
Click “OK” on the “Format Picture” dialog, and again on the “Header” dialog and “Page Setup” dialog.

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.

Post a Comment

POST A COMMENT

Request a New How-To Article

Looking for more How To information? Chances are there’s an eHow member who knows how to do what you’re looking to do. Submit an article request now!

eHow Article:  How to Make a Watermark in Excel

eHow Member: triciagoss

triciagoss

Novice Novice | 0 Points

Category: Computers

Articles: See my other articles

Related Ads