setting image layout to "behind text"

[basher450]

hi

this question seems pretty easy, but I just can't find a way to do it - I must be missing out something:
In word, when inserting an image, you can format the pic's layout to go "behind text", so it looks like a background.

how do you do that in Excel?

 

[Barry Katcher]

I just did a search, and, per the experts, this can't be done in Excel. But see the following link for a work-around from Ivan Moala.

http://www.mrexcel.com/board2/viewtopic.php?t=19963&highlight=image+behind+text

Barry

 

[IML]

This would be for onscreen only, but you can insert a picture under
format sheet background.

 

[basher450]

This would be for onscreen only, but you can insert a picture under
format sheet background.

this will do it, thanks
now how do I make it none repeatable?

 

[Barry Katcher]

When you insert a sheet background, it is automatically tiled (repeated) and covers the entire sheet, from A1 to IV65536. The size of each tile is most likely determined by the size in pixels (pixel width x pixel height) of the particular image. You can lighten the image (before insertion) by manipulating its visibility in an image editing program, such as Photoshop or Paint Shop Pro, but I don't see anything in Excel (I'm working with Excel 2000) that would either dis-allow tiling or allow placement of the image in a particular cell or a range of cells.

Barry