Embedding image into cell

  • Thread starter Thread starter Yossi Reznick
  • Start date Start date
Y

Yossi Reznick

Is there a way to embedd an image into a cell, so it will become the cell's
content?

Thanks
 
No. You can make the image the exact size of a cell, and format it
to move and size with cells.
 
Thanks for the quick reply.
The problem is this:
I have a table with data and the image is part of the data. I configured the
image positioning to move and resize together with cell.
BUT when I select the table and sort it, the image does not move together
with the rest of the record (row).
 
You might consider putting the image into a comment on a cell in the row.
The comment will sort with the rest of the cells in that row.

Do a google search on "excel comment picture" for directions.

Good luck.

Frank
 
Hi Yossi,
and so maybe it's not such a great idea. You would have the
same problems with cell borders and sorting.

I don't know of any real solution.

The following seems to work but may not fit your requirement,
because it will no longer completely obscure the cell.

Change the zoom to 200% so you can resize the cell smaller
and align only on the left side. Change the formatting properties
to move with cell but don't resize. Change zoom back to normal.

You might want to change the cell background to match the
overlaying shape.

Maybe if you stated the reason it is necessary there might be
other solutions. Basically I think it might come down to
can you recreate pictures and overlay they with a macro.
Or maybe a macro that resizes shapes before and after the sort.
Make sure you have backups of your workbooks..
 
Back
Top