«

»

Add a watermark to an Excel worksheet

Here is a blog post on the Microsoft official Excel blog showing how to add a watermark to your spreadsheet:

“by Dail Bridges

Microsoft Office Excel - Add Watermark to Excel
If you’re a manager building a budget in Excel, you’ll likely need to solicit input from your staff. Sometimes that collaboration takes several iterations, so it’s useful to add a DRAFT watermark to a worksheet. Or sometimes a sensitive document needs to be kept secret, making it important to add a CONFIDENTIAL watermark.

Excel doesn’t come with a built in way to add a watermark, but there’s a pretty painless way to do it:  just place a pre-built .PNG graphic file in the header of your Excel worksheet, and it displays as a watermark. To get you started, we’ve created DRAFT and CONFIDENTIAL watermarks that you can access right from this post. Just follow the steps below the graphic.

Microsoft Office Excel - Excel Budget with DRAFT Watermark

First you’ll need to open and save the watermarks we’ve created. Right-click on DRAFT or CONFIDENTIAL, and on the shortcut menu, click Save Target As. Specify the location where you want to save the picture and do so.

In your worksheet, click the Insert Tab and in the Text group, click Header & Footer.  Excel switches to Page Layout view, and your cursor appears in the center header box at the top of the worksheet page (under Header).

Microsoft Office Excel - Adding an Excel Watermark in Header

Click the Design tab, and in the Header & Footer elements group, click Picture. Find your copy of the DRAFT or CONFIDENTIAL .PNG file on your computer and add it to the header. You’ll see that your worksheet header contains the word “Picture.” To view the actual watermark, just click in any cell in your worksheet.
Microsoft Office Excel - Viewing an Excel Watermark in Header

When you’re viewing it, you’ll be in Page Layout view. To return to the Normal view–the way you typically work in Excel–click the Normal button on the status bar at the bottom right of your screen.

(Note that headers are visible only in Page Layout view, the Print Preview window in Backstage view (File tab, Print), and the printed worksheet.)”

If you want to adjust the position of the watermark or resize it, check out this article”

About Advanced Network Consulting:

Looking for a local, personable, professional IT Consultant to service your LA or Orange County business?  Advanced Network Consulting offers onsite, ongoing IT support for businesses with 5-75 employees.  Whether your business needs network maintenance, hardware upgrades, or a system redesign, ANC provides customized technology solutions.  Not sure where to start?  Start by giving us a call for a complimentary onsite evaluation.  562. 903.3992  We look forward to meeting you.