Apr 20, 2020

How can I enlarge an in-cell image in Google Sheets? Ideally through mouse/automatically?

Hello there,

I've been building a sheet that we're going to use for basic inventory (beats walking up and down the stairs to check for certain numbers.) However, just in the first part of adding the data it I've ran into a problem.. 

I've been inserting the images into cells using my Android phone in one column next to the individual part numbers. (using insert from Camera) However, the images are incredibly small. The only 2 ways I've found to expand them so I can see them is to either increase the dimensions of the cell row/column (which is sloppy and moves all the data around the screen), or to reference the cell in a larger merged cell, which I have frozen at the top of the screen. This is still cumbersome, as I have to manually type in the cell location each time I want to browse to a new picture.

Here's where I'm at currently with my testing: is it possible to write a script or something that would trigger on a click of the image cell and update to the frozen larger cell? or some way to open that image cell in a new tab even? 

What I need is to be able to CTRL+F to look for a particular number, then cycle through the different images of that number quickly so I can see each item's condition. 

Any advice would be appreciated!
Locked
Informational notification.
This question is locked and replying has been disabled.
Community content may not be verified or up-to-date. Learn more.
All Replies
Apr 20, 2020
One option at least to getting an image into your 'view' area,  would be to add checkboxes next to each image then in the view cell put
ARRAYFORMULA(IF(the checkbox range=true, the image range, if no match put whatever you want here)
This would search through the checks and return any that are true. If you might be viewing multiple at a time setting multiple view boxes across the same row will return multiple selections. As long as the columns aren't merged, if they are viewing multiple will get messed up. 

You could also have an entry sheet/tab and then a second one to return the items that match a number using a filter or query.
Last edited Apr 20, 2020
false
10263486656673603101
true
Search Help Center
true
true
true
true
true
35
false
false
Search
Clear search
Close search
Main menu