How to add Watermark to an Excel Document:
In this blog , i am going to explain that how to add Watermark in Excel Spreadsheet:
Here's some steps that you must follow:
1: TEXT WATERMARK:
.
.
Microsoft Excel 97/2000/XP (2002)/2003:
- Open the Excel document that you want to add watermark to.
- Select "Insert" from the top menu, then select "Picture" > "WordArt...".
- In the "WordArt Gallery" dialog, select a WordArt style that you like then click "OK".
- In the "Edit WordArt Text" dialog, type in your desired text, select the font style and size, then click "OK".
- Right-click on the newly inserted WordArt on the Excel document, then select "Format WordArt...".
- In the "Format WordArt..." dialog, select "No fill" for "Fill"/"Color".
Also select a brighter color (i.e. gray) for "Line"/"Color" then click "OK". - Right-click on the WordArt on the Excel document, then select "Order." > "Send to Back".
- Click and drag the WordArt to position it where you like.
Note: The WordArt needs to be manually placed on each page of the document.
Microsoft Excel 2007/2010:
- Open the Excel document that you want to add watermark to.
- Select the "Insert" tab from the top menu, then in the group "Text", select "WordArt".
- Select the WordArt style you want, then type the text for your watermark.
- Under "Drawing Tools", select "Format".
- In the group "WordArt Styles" change "Text Fill" to "No fill".
- Also in the same group "WordArt Styles", change "Text Outline" to "Automatic".
- In the group "Arrange" select "Send to Back".
- Click and drag the WordArt to your preferred position.
Note: The WordArt needs to be manually placed on each page of the document.
2: IMAGE WATERMARK:
Microsoft Excel 97/2000/XP (2002)/2003:
- Open the Excel document that you want to add watermark to.
- Select "View" from the top menu, then select "Header and Footer".
- In the "Page Setup" dialog, click on the "Custom Header..." button in the middle of the dialog.
- In the "Header" dialog, click on the middle box "Center section"
- In the middle of this dialog box, there are some tool buttons. We're going to use the last two buttons to insert and format the image.
- Click on the Insert Picture button (the second-to-last button with an image of a mountain)
- Navigate to the folder where your watermark image is located. Select the image and click "Insert".
- A text "&[Picture]" is now placed in the middle box named "Center section".
- Click on the Format Picture button (the last, right-most button).
- Adjust the scale and size if you wish, then select the "Picture" tab. Change the "Color" under "Image Control" to "Washout", then click "OK".
- At this point, you can click "OK" to finish, and do a "Print Preview" to see your watermark. However, you will notice that the image is placed far on the top of the page, which doesn't look usual for watermarks. To fix this, click on the middle box named "Center section" again and enter a few blank lines before the text "&[Picture]".
- Once you're all done, click "OK" to exit and open "Print Preview" to see your watermark. (The watermark will not be displayed in normal view.)
Microsoft Excel 2007/2010:
- Open the Excel document that you want to add watermark to.
- Select the "Insert" tab from the top menu, then in the group "Text", select "Header & Footer".
- Excel will now switch to Page Layout view, and the cursor will be moved to the center top of the page.
- On the "Design" Tab, in the group "Header & Footer elements" Select "Picture".
- Navigate to the folder where your watermark image is located. Select the image and click "Insert".
- A text "&[Picture]" is now placed in the middle box of the header.
- To move the picture down on the page, click on the header and place the cursor before the text "&[Picture]", then hit Enter a few times.
- To see the watermark, either open the "Print Preview" or click on any cell of the document.
.jpg)
