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.