-
First switch to Page Layout view, and then go to the Header of the worksheet.
-
Add a Picture and then choose one you want as a watermark.
-
After you've chosen a picture, the picture won't appear right away. But you will see &[Picture]. This is just placeholder text for the picture.
-
Click a cell outside the header or footer areas, and the picture appears in the worksheet.
-
If the picture is too high on the worksheet, go to the Header again, and place your cursor immediately before the & in &[Picture]. Then press Enter multiple times.
-
You won't see the new spaces right away. So click any cell outside the header, and you'll see the newly added space before the picture.
-
If the picture is too big or too bold, go to the Header again, and then Format Picture. Change the height and width. If the picture is too bold, go to the Picture tab and increase the brightness. Click OK.
-
When you're done, click any cell outside the header.
-
Now the watermark will appear on each page of this worksheet when it's printed. Scroll to the side or down to see other pages, and then click a cell. The watermark will appear.
-
If you don't want to see the watermark while you're working in Excel, switch to Normal view. But remember that the watermark will appear when you print the worksheet.