Image file as value

Question

I have a workbook with a number of sheets. I'd like to be able to put an image in a cell (i.e. A1 of the first sheet in the workbook) and have it populate in cell A1 of all sheets.

I'm assuming the image has to be assigned as a value in order to do so but I can't see how to do it.

I understand how to place an image in a cell (Insert image, adjust size to fit, etc.) but currently I have to do that across all sheets which is cumbersome.

Is what I want to do even possible? How would I go about doing it?

TIA

Rich

ingeborghawighorst · Answer

Hello&nbsp;Rmart911,
&nbsp;
images in Excel don't actually sit inside a cell. They are graphics objects that are in a layer on top of the grid, like a transparent sheet laid over the Excel sheet.&nbsp;
&nbsp;
What you describe is not possible with just worksheet formulas. It would require some serious VBA programming.&nbsp;
&nbsp;
If you create the workbook from scratch, you could place the image in a sheet and use that as a template sheet. When you want to add a sheet, copy the template sheet.

rmart911 · Answer

IngeborgHawighorst&nbsp;I've seen some tutorials that have images embedded in the sheets somehow so that if a value in a cell (A1) is 'orange' for example, a picture of an orange would show up in A2. If A1 'banana', a banana, etc.&nbsp;It seems to me that if that can be done there should be a way to do what I'm looking for. Would be useful.

ingeborghawighorst · Answer

Rmart911&nbsp;The technique you describe is done with a dynamic image that changes its content based on a formula. It is not a new image every time, just what the already positioned and sized image displays will be changing.

twifoo · Answer

If you need a picture lookup, you may refer to this link:https://www.computergaga.com/blog/create-a-picture-lookup-in-excel/

rmart911 · Answer

TwifooThat looks very useful and I'm going to bookmark that page. Thank you. It's more complicated than I need though. I just want to drop an image in a cell on the first sheet and have it show up in the corresponding cells on a dozen other sheets.&nbsp;The image file is provided by clients at infrequent intervals and having to embed each image file into a separate index is too complicated for most of the people who will be using it.&nbsp;Right now we need to place the image in a cell, copy that cell, and paste it into each of the other sheets manually. I'd just like to streamline that step without having to be the goto person to embed each new image into the worksheet.

Forum Discussion

Image file as value

6 Replies

Resources