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
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

tusharm

MrExcel MVP
Joined
May 28, 2002
Messages
11,023
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:
 

Watch MrExcel Video

Forum statistics

Threads
1,112,884
Messages
5,543,023
Members
410,583
Latest member
gazz57
Top