I'm working on an inventory system where each item receives a photo ID. When I select the desired cell for the photo ID, I go to the ribbon across the top, open the "Insert Picture" command, and the picture is inserted into the cell. However, the picture opens automatically, as if by hyperlink or something similar.
With the photo open like this, it is large enough that neighboring cells are obscured. Looking for a way to just insert the .jpg file into the cell, where it could be opened when needed, but otherwise, remain closed.
A couple of photos are attached to help illustrate what I'm trying to explain. Thanks in advance for all your responses.
Hmm....I'm wondering of the lack of replies since my original post two days ago means that the task I'm trying to accomplish can't be done. Or, maybe I'm simply not wording my question the right way. Using an Excel spreadsheet, I have a single row of data for each object I'm listing. Each row has several cells. I would like to be able to insert a photo ID file (.jpg) into a cell on each row. I thought I would just be able to copy and paste the .jpg file into a cell, allowing me to open it when needed. But, when I put the file into the cell, the actual picture is displayed, or opened - and, the display is large enough that nearby cells are partially obscured. I was hoping that I could insert the .jpg file into the cell with the .jpg file info (text only) displayed, not the photo itself. Is this the appropriate community to be asking this question? Thanks in advance for all responses.