Object behind text in cells?

P

pickytweety

Hi,
How do you make a picture show up BEHIND the text in cells in Excel 2007? I
see a "send to back" command that works with multiple objects, but it's
grayed out if there is only one picture. I want the picture to show up
behind the words (so you can still read the words). Any ideas?
 
J

John Calder

Hi

I dont use 2007 but in Excel 2000 you can insert a comment box and format it
to have a picture in it then fill your comment box with text. You can then
adjust you box size to whatever you want.

John
 
S

Steve Dunn

I don't think it can be done directly, but for print purposes it can
certainly be achieved.

Copy the range of cells that you want in front of the picture, and paste it
on a different sheet, as a "linked picture". Put your background picture in
the same sheet, and you can arrange them as you like. The linked picture of
your cells will update automatically.
 
S

Steve Dunn

After a bit of experimentation I found it under Page Layout > Page Setup >
Background (Excel 2007).






Steve Dunn said:
I don't think it can be done directly, but for print purposes it can
certainly be achieved.

Copy the range of cells that you want in front of the picture, and paste
it on a different sheet, as a "linked picture". Put your background
picture in the same sheet, and you can arrange them as you like. The
linked picture of your cells will update automatically.
 
T

thoriqiqbalrusty

If you want to put a picture as printing background in excel 2007 you can try to make it as header or footer because when you put it in page setup>background>picture it will only be a background in your sheet and it's not printable.
 
U

uglybeauty76

1.Insert picture
2.Click picture. go to format
3.Adjust
4.Recolor
5.Set transparent color
6.Click on picture
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top