Tuesday, April 3, 2012

Tip: Add a watermark to an Excel worksheet

If a Manager you create a budget in Excel, you must probably require input from your employees. Sometimes, this cooperation takes several iterations, so it makes sense to add a watermark design to a worksheet. Or sometimes a sensitive document makes it important, a confidential watermark must be kept secret.

Excel does not comes with built in, so, to add a watermark, but there is a fairly painless way to do it: just put a prefabricated.PNG graphics file in the header of an Excel worksheet, and it appears as a watermark. To get you started, we have draft and confidential -Wasserzeichen created, which can be accessed right from this post. Follow the simple steps below the graphic.

Excel Budget with DRAFT Watermark

First, you need to open and save the watermark that we created. Click on draft or confidential, and on the shortcut menu, click on Save target under. Type the location where you want to save the image and do.

On your worksheet, click the Insert tab , and in the text group, click header & footer to .  Excel moves to the view page layout, and Center your cursor will appear at top of the worksheet page (in the header) in the header.

Adding an Excel Watermark in Header

Click the Design tab, and in the Header & footer group, click picture. Find your copy of the draft or confidential.PNG file on your computer and add it to the header. You will see that your worksheet header contains the word "Image." To view the actual watermark, simply click in any cell in the worksheet.

Viewing an Excel Watermark in Header

If you look at it, you are in Page layout view. To the normal view--der way back in Excel-you work usually click on the status bar bottom right of the screen normal .

(Note that headers only in the page layout view, thewindoware visibleside viewin the Backstage view (tab file, print) and the printed worksheet.)

If you want to adjust the size or position of the watermark, check out this article:

Mimic a watermark in Excel


View the original article here

No comments:

Post a Comment