water mark

NCay

Board Regular
Joined
Jul 15, 2002
Messages
214
quick question, I have to place a water mark saying "draft" behind the sheet, can anyone remind me how?
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
still can't get this to work. Any further explanations would be good.

BTW i'm using office XP
 
Upvote 0
I thought that there was a simple way to place a picture behind the data on the sheet as a transparency or watermark, though I seem to be completely LOST this time, I believe there is an insert picture- image control command in office 2k that does this, but am struggling to find an equivalent in office xp/ excel 2002.
Current attempts leave picture ABOVE the data, even after using the send to back command. Am I missing something??
 
Upvote 0
Thanks Steve W, eventually managed to lose the Monday morning feeling and got this way to work! Though must admit I am disappointed that this is the only simple way to achieve this- especially when there is a Word equivalent devoted to doing this.
 
Upvote 0
Hi all,

One of the ways (thanks, Aaron Blood) is to paste picture link. I'm talking about Excel 2000.

But we have to use reverse logic: you create a watermark, do the coloring, transparency, all the things necessary, WordArt, etc and only THEN you select the data, copy. Push shift and superimpose the picture link with data on top of your watermark.

Works.
 
Upvote 0
If you have a bitmap or jpeg of the word "DRAFT" then you can go to Format, Sheet, and then Background. This will insert the word Draft in your backgroung, although I don't think it prints. Otherwise, I've just used Word Art. I use a light grey outline with no fill...works great!
 
Upvote 0
tbardoni's right, it won't print

check out the settings within your printer settings from the start menu in Windows..... mine all have a watermark option for printing
 
Upvote 0

Forum statistics

Threads
1,223,204
Messages
6,170,723
Members
452,351
Latest member
Giare

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top