Watermarks in Excel
Excel has no Watermark option but you can do it by using WordArt or using an image for the Background.
- Click on the worksheet where you want to display the watermark
- From the Insert tab, in the Text group, choose WordArt
- Click the WordArt style that you want to use
- Type the text that you want to use for the watermark
- To change the size of the WordArt
- Right-click the WordArt
- On the shortcut menu, click Font , and then enter a new number in the Size box
- To add transparency so that you can see more of the worksheet data underneath the WordArt
- Right mouse click the WordArt
- Choose Format Text Effects
- In the Text Fill category, make sure Solid Fill is selected. You can select a fill colour
- Drag the Transparency slider to the percentage of transparency that you want
- To rotate the WordArt, select it, and then drag the rotation handle to turn the WordArt
Using an image
To create the "Text" picture
- Open GIMP (or any other Paint Program)
- Open a new image, size 500x500
with a white background
- Open the Text tool and create a
text in light grey
- Tilt the text to make it 45°
- Save as a .jpg file.
To create the Background
- Open Excel
- From the Page Layout ribbon, in the Page Setup group,
- Locate and select your picture for the background.
- Click Insert.