A picture as cell bakground or cell pattern

n-kadkhodaei

New Member
Joined
Sep 17, 2006
Messages
1
Hi
How can I insert a small picture as a cell 'Background' or 'Pattern'? How can I assign a picture to a cell. I want to insert a picture as a pattern of a single cell. For example I want to show my photograph in an indivigual cell as cell pattern or cell back ground.
Thank you for your attention.
N-KADKHODAEI
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

tusharm

MrExcel MVP
Joined
May 28, 2002
Messages
11,029
You cannot associate a cell with a picture let alone as a background. In XL, pictures reside in a "layer" above the cells.

That said, you can *simulate* the effect of linking a cell with an image but it will hide anything in the cell.

Through the UI just drag and adjust the shape of the image to fit that of the cell.

Through code, adjust the shape's left, top, width, and height to match those of the cell of interest.

In both cases, ensure that you set the shape's properties so that it sizes and moves with the cell.
 

Bartek

Board Regular
Joined
Jul 29, 2006
Messages
54
Hi,

How can I insert a small picture as a cell 'Background' or 'Pattern'? How can I assign a picture to a cell. I want to insert a picture as a pattern of a single cell. For example I want to show my photograph in an indivigual cell as cell pattern or cell back ground.

You can use a picture as a background (texture) in Excel with Format > Sheet > Background. However, this texture will be applied to all cells in a worksheet.

Background is only visible if ColorIndex of a Cell.Interior is set to xlColorIndexNone, otherwise, interior color will override the background.
Thus, by carefully positioning background image and coloring interior of all cells except a selected few, you can create an illusion that some cells have background picture. But this is rather tiresome and unreliable method - any changes like deleting or resizing rows will spoil the effect :rolleyes:
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,167,834
Messages
5,855,899
Members
431,772
Latest member
dannyboi1

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