Format Picture to appear behind contents in cell

schick98 · Mar 20th, 2002, 06:01 PM

How do I format a picture so that it appears behind the contents of a cell? My pictures always coverup the cell contents.

schick98 · Mar 20th, 2002, 06:28 PM

What I really need is an image to appear between the color of a cell and the contents of the cell. Any help?

Jay Petrulis · Mar 20th, 2002, 06:39 PM

Hi,

I could be wrong, but I don't think you can get the picture to be transparent (or semi-transparent). You can make a "Watermark" -like effect with WordArt on the sheet, but not with a picture.

One weird idea that may work for you is to copy your cells as a picture and manipulate the image. Possibly even a chart sheet would do it. Here's how:

1. Select your range.
2. Hold down the Shift key
3. Choose the Edit Menu Option
4. Choose copy picture.
5. Paste this picture of your data over the original picture.

I don't follow your second post, so I could be totally misreading your request.

Bye,
Jay

schick98 · Mar 20th, 2002, 06:44 PM

Thanks for your reply Jay - Your first sentence answered my question - I am wanting a picture to be transparant like the Word Art. However, I could not use the word art because I am wanting a logo to appear behind a certain group of cells. You had a great idea with making the cells a picture then pasting, but the contents in my cells are dynamic. Thanks anyways for your help.

Jay Petrulis · Mar 20th, 2002, 06:49 PM

When you say your cells are dynamic do you mean the range size is changing? Much tougher.

If not, you still might be able to do it through a macro. Create another area for your "report" and include the picture there. When you are ready, have the macro do the hard part for you, copying and pasting to the other area.

Of course, this is still just an idea. I believe the tinkering with the sizing and the positioning would be a tough task.

Regards,
Jay

schick98 · Mar 20th, 2002, 06:56 PM

When I said dynamic, I meant the contents of cells are constantly changing, based on the input by the user. But I like the idea with the macro - I will have to play around with it to see if I can get it to work well.

Anne Troy · Mar 20th, 2002, 09:53 PM

Check this out. Get your logo and put it in some graphics program, or use Snag-It from http://www.Techsmith.com to get an image of your logo in the approximate desired position that you would want it on your worksheet and then all the white space you'll need to fill up the rest of the worksheet (this is not a GREAT workaround, mind you, but worth a shot maybe). Then format-background with a picture and choose your picture. The image/logo/white space WILL repeat at some point, but perhaps you're only using a certain print area that won't cause a problem for you.

Anne Troy · Mar 20th, 2002, 09:55 PM

schick: Did you see this?

http://www.mrexcel.com/board/viewtop...2913&forum=2&1

schick98 · Mar 21st, 2002, 06:11 AM

Sorry for the late reply, but thanks a lot Dreamboat - I will try that. Schick

Mar 20th, 2002, 09:53 PM	#7
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	Check this out. Get your logo and put it in some graphics program, or use Snag-It from http://www.Techsmith.com to get an image of your logo in the approximate desired position that you would want it on your worksheet and then all the white space you'll need to fill up the rest of the worksheet (this is not a GREAT workaround, mind you, but worth a shot maybe). Then format-background with a picture and choose your picture. The image/logo/white space WILL repeat at some point, but perhaps you're only using a certain print area that won't cause a problem for you. __________________ ~Anne Troy

Mar 20th, 2002, 09:55 PM	#8
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	schick: Did you see this? http://www.mrexcel.com/board/viewtop...2913&forum=2&1 __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 20th, 2002, 06:01 PM	#1
schick98 New Member Join Date: Mar 2002 Posts: 7	How do I format a picture so that it appears behind the contents of a cell? My pictures always coverup the cell contents.

Mar 20th, 2002, 06:28 PM	#2
schick98 New Member Join Date: Mar 2002 Posts: 7	What I really need is an image to appear between the color of a cell and the contents of the cell. Any help?

Mar 20th, 2002, 06:39 PM	#3
Jay Petrulis MrExcel MVP Join Date: Mar 2002 Location: Chicago, IL USA Posts: 2,042	Hi, I could be wrong, but I don't think you can get the picture to be transparent (or semi-transparent). You can make a "Watermark" -like effect with WordArt on the sheet, but not with a picture. One weird idea that may work for you is to copy your cells as a picture and manipulate the image. Possibly even a chart sheet would do it. Here's how: 1. Select your range. 2. Hold down the Shift key 3. Choose the Edit Menu Option 4. Choose copy picture. 5. Paste this picture of your data over the original picture. I don't follow your second post, so I could be totally misreading your request. Bye, Jay

Mar 20th, 2002, 06:44 PM	#4
schick98 New Member Join Date: Mar 2002 Posts: 7	Thanks for your reply Jay - Your first sentence answered my question - I am wanting a picture to be transparant like the Word Art. However, I could not use the word art because I am wanting a logo to appear behind a certain group of cells. You had a great idea with making the cells a picture then pasting, but the contents in my cells are dynamic. Thanks anyways for your help.

Mar 20th, 2002, 06:49 PM	#5
Jay Petrulis MrExcel MVP Join Date: Mar 2002 Location: Chicago, IL USA Posts: 2,042	When you say your cells are dynamic do you mean the range size is changing? Much tougher. If not, you still might be able to do it through a macro. Create another area for your "report" and include the picture there. When you are ready, have the macro do the hard part for you, copying and pasting to the other area. Of course, this is still just an idea. I believe the tinkering with the sizing and the positioning would be a tough task. Regards, Jay

Mar 20th, 2002, 06:56 PM	#6
schick98 New Member Join Date: Mar 2002 Posts: 7	When I said dynamic, I meant the contents of cells are constantly changing, based on the input by the user. But I like the idea with the macro - I will have to play around with it to see if I can get it to work well.

Mar 21st, 2002, 06:11 AM	#9
schick98 New Member Join Date: Mar 2002 Posts: 7	Sorry for the late reply, but thanks a lot Dreamboat - I will try that. Schick