setting image layout to "behind text"

basher450

New Member
Joined
Jan 26, 2005
Messages
23
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?
 

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

IML

MrExcel MVP
Joined
Feb 15, 2002
Messages
1,743
This would be for onscreen only, but you can insert a picture under
format sheet background.
 

basher450

New Member
Joined
Jan 26, 2005
Messages
23
IML said:
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

Well-known Member
Joined
Feb 25, 2002
Messages
4,053
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
 

Forum statistics

Threads
1,148,526
Messages
5,747,216
Members
424,069
Latest member
kamkwok1hh

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
Top