Browse » Home
Saturday, May 14, 2011
How to: Watermarks in Excel 2007
1. Click the 'Page Layout' tab, then click the small down arrow at the bottom right of the 'Page setup' panel. Excel will display a dialog box with options for setting the header and footer of your workbook. Inserting a picture in a header creates a watermark for the workbook.
2. Click the 'Header/Footer' tab, then click the 'Custom header' button. Excel will display a dialog box allowing you to specify different headers for the left, right and middle sections of your workbook.
3. Click in the 'Center' text box, then click the icon above the text box that appears as a mountain with a rising sun over it. This button is the 'Insert picture' tool.
4. Click the button just mentioned, then use the controls in the 'Insert' dialog box that appears to move to a folder on your hard drive containing a picture file you would like to use as a watermark.
5. Click the picture file to select it, then click the dialog box's 'Insert' button to load the picture into the header for your workbook. Excel will display the text '(Picture)' in the 'Center' text box, which indicates it successfully loaded the picture.
6. Click 'OK' to exit the dialog boxes and complete the insertion of the picture into your workbook. Excel will not display the picture while in draft view, which Excel documentation refers to as 'Normal' view.
7. Click the 'View' tab, then click the 'Page layout' button of the 'Workbook views' panel. Excel will display the picture you inserted in the header's center section, but only on the first page of the preview.
8. Click a cell on any of the pages where Excel displays the text 'Click to add data.' Excel will insert your watermark graphic onto the page you clicked.