topic Re: Google Sheets & Hyperlinked Images - Help Please! in Electronics

Google Sheets & Hyperlinked Images - Help Please!

LAllyR — Sun, 01 Jan 2023 22:18:56 GMT

I have a spreadsheet set up in Google Sheets that has photos inserted in a column of cells but they are so small that we can't view them when wanting to reference them. I found a way that I can get this set up by installing a browser extension called Hover Zoom+ but in order for it to work, I have to insert the photos as hyperlinks. I have watched YouTube videos on how to hyperlink the photos into the sheet but even though the link is there, the photo isn't showing up. I'm wondering what I'm doing wrong. Maybe it's the site where my photos are? I have them uploaded to Winkflash.com photo site and assumed that would work. If I click on each individual photo in Winkflash, they each have a unique url that should work but it doesn't.

Does anyone have any experience in setting these photo hyperslinks up that could help me? Any tips are greatly appreciated.

Re: Google Sheets & Hyperlinked Images - Help Please!

CAcableGirl2 — Mon, 02 Jan 2023 01:46:26 GMT

@LAllyR I'm not much help, but can you just copy and paste the picture into the column?

Re: Google Sheets & Hyperlinked Images - Help Please!

LAllyR — Tue, 03 Jan 2023 04:34:47 GMT

@CAcableGirl2 Yes that can be done but for me to use the Hover Zoom+ extension that will enlarge the photo when I hover over it, it requires the photo to be inserted as a hyperlink.

Re: Google Sheets & Hyperlinked Images - Help Please!

Desert Lily — Tue, 03 Jan 2023 05:10:55 GMT

@LAllyR I googled and found this. You can probably find more info if you google.

In Sheets, click the cell you want to add the link to.
Click Insert. Link.
In the Link box, click Select a range of cells to link.
Highlight the cell or range of cells you want to link to. ...
Click OK.
(Optional) Change the link text.
Click Apply.

Re: Google Sheets & Hyperlinked Images - Help Please!

LAllyR — Wed, 04 Jan 2023 07:17:08 GMT

@Desert LilyThank you for your response, however that is not what I'm trying to do. I have already done an exhaustive search online and have watched numerous YouTube videos and read many articles/instructions on how to add a photo to a cell that has a hyperlink. I know the formula that needs to be used (according to all of the sites I've researched) which is =image("url") but when I do that, my photo is still not visible. Others have had the same issue and none of the suggestions that have been given to fix it has worked for me. Thus my reason for posting my question on here.

Re: Google Sheets & Hyperlinked Images - Help Please!

Mz iMac — Wed, 04 Jan 2023 20:21:57 GMT

@LAllyR wrote:
I have already done an exhaustive search online and have watched numerous YouTube videos.....

@LAllyR

Have you contacted Google Sheets customer support or posted on their forums?

Re: Google Sheets & Hyperlinked Images - Help Please!

LAllyR — Fri, 06 Jan 2023 03:22:38 GMT

@Mz iMacThanks for the response. I have been on their forums and have found that others are having the same issue of not being able to see the photo once the formula is inserted. I haven't been able to find a solution that works in the forums. I haven't contacted their support team yet. I didn't have high hopes since it seems it's been an ongoing issue for a number of years and others said it's a Google Sheets issue. I may have to give it a shot but thought I'd ask here on the off chance someone knew the answer.