![]() ![]() If you are running a previous version of Excel, review our instructions on adding watermark in earlier versions.įor more tips on Excel, check out our post on 10 Microsoft Excel Tips Every User Should Know. These instructions and screenshots were put together specifically for Excel 2016 and above. Use the Transparency slider to adjust the opacity of the WordArt. Click the Text Options tab, select the Text and Fill tab, then expand the Text Fill and Outline menus. This will activate the Format Shape task pane. Select the Insert tab, click on the Word Art menu, then choose the desired style.Įnter your watermark text, right-click the Word Art text, then click Format Shape. The steps are pretty much the same in Excel. This is similar to the method used to add a watermark in Microsoft Word. Now your data won’t get lost in the image.įor text-based watermarks, you can use Word art. You can click in the Color drop-down then choose Washout for a good watermark effect. There you can adjust the brightness and contrast in the Image control section. You can modify the image by clicking on the header and footer again, clicking the Format Picture button, and selecting the Picture tab. Instead, you’ll only see a text string until you click outside of the header.Īs you can see, the image I just inserted clashes with the data. Unlike Microsoft Word, you initially won’t see a preview of what you just inserted. This puts you in the Header & Footer Tools ribbon and lets you start editing the header. To do this, go to the Insert tab and click Header & Footer. The place to add your image is in the header. There is no built-in watermark feature, so instead, you’ll have to insert an image into your spreadsheet and then tweak it a bit. Working with watermarks in Excel is no exception. Add an Image as a Watermark to Your Workbooks in Excel #Ĭompared to Microsoft Word documents, formatting in Excel is a little unintuitive. While encryption and password protection tools in Excel will keep your spreadsheets secure in their digital form, a watermark can help properly mark and control your sensitive data when you print it out. ![]() But occasionally, you will want to get your spreadsheets on paper. Excel, while highly revered for its infinite data-crunching power, isn’t particularly geared toward printer-friendliness. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |