excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

resolvedResolved · 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?

Edited on Fri 22 Feb 2008, 16:43

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


 

Excel tip:

Do a fast scroll

In 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.

View all Excel hints and tips


Server loaded in 0.09 secs.