Apr 20, 2020
How can I enlarge an in-cell image in Google Sheets? Ideally through mouse/automatically?
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!
Details
Community content may not be verified or up-to-date. Learn more.
All Replies