98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Excel
Excel
Resolved · Low Priority · Version Standard
Emma has attended:
Excel Intermediate course
Access Introduction course
Excel
Is is possible to put a draft watermark on a worksheet?
RE: Excel
Dear Emma
The Watermark feature is not available in Excel.
However you can create something that looks like a watermark by using "WordArt".
1. Select View and click [Page Break Preview[/b]. This allows you to see how Excel is printing the document
2. Click on the WordArt button in the Drawing toolbar
3. Select a WordArt Style (the Simple Outline text is probably best - top left option)
4. Choose the font you want, type your Watermark message and click OK.
5. Then move, size, and turn the WordArt so it's placed as you want it within the boundaries of the first page.
6. The watermark will obscures the numbers in the worksheet. To fix this, right-click on the word and choose "Format WordArt."
Set the Fill Color to one of the patel colours and set the transparency to around 75%. Make sure you also change the line colour and click OK.
You may need to play around with this until you settle on your optimum setting.
If your spreadsheet is a single page, you're done. If not, Copy the watermark and paste it in the other pages as required.
Hope this helps.
Carlos
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Do a fast scrollIn big Excel databases with many records, you can move down thousands of rows super-fast as follows: hold down Shift then click on the scrollbar somewhere below the scrollbar handle. This will move you way down the sheet without your having to use the scrollbar up/down arrows or drag on the scrollbar handle. |