I am attempting to insert photos into specific cells on an Excel spreadsheet.
I can insert photos just fine, but they are not anchored to any specific
cell. For example, I want a photo in cell A1 as part of a large spreadsheet
of photos and data. How do I do it?

On 5/13/2010 1:35 PM, Artemis Bob wrote:
I am attempting to insert photos into specific cells on an Excel spreadsheet.
I can insert photos just fine, but they are not anchored to any specific
cell. For example, I want a photo in cell A1 as part of a large spreadsheet
of photos and data. How do I do it?

In Excel 2007, right click on your picture, click on Size and
Properties, click the Properties tab, select Don't Move or Size with
Cells, click Close.

The photo isn't "in" the cell; it's over the cell...

I'm pretty sure Excel 2003 includes this capability, but it might not be
quite the same commands.

Bill

Photos or other objects cannot ne inserted "into" a cell.

They can only lay on top of the cell or cells.

Do you want photos to sort with the cells?

The photo must lie within the cell boundaries and "move and size with cells"
must be enabled.


Gord Dibben MS Excel MVP

On Thu, 13 May 2010 13:35:01 -0700, Artemis Bob <Artemis
wrote:

I am attempting to insert photos into specific cells on an Excel spreadsheet.
I can insert photos just fine, but they are not anchored to any specific
cell. For example, I want a photo in cell A1 as part of a large spreadsheet
of photos and data. How do I do it?

"Artemis Bob" <Artemis wrote in message
...
I am attempting to insert photos into specific cells on an Excel
spreadsheet.
I can insert photos just fine, but they are not anchored to any specific
cell. For example, I want a photo in cell A1 as part of a large
spreadsheet
of photos and data. How do I do it?

Try these two macros:

http://www.exceltip.com/st/Insert_pi...Excel/486.html

--
Fred

try this
-Right-click on the cell
-Insert Comment
-Double-click on the border of the comment
-Choose the Colors and Lines tab
-In the Fill section, click the drop-down for Color
-Choose Fill Effects... | Picture | Select Picture...
-Choose your picture and click Insert
-Click OK

all the best