Reply
Frequent Contributor
Posts: 124
Registered: ‎03-20-2010

Google Sheets & Hyperlinked Images - Help Please!

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.

Respected Contributor
Posts: 3,650
Registered: ‎06-03-2010

Re: Google Sheets & Hyperlinked Images - Help Please!

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



......You look like I need a drink.....
Frequent Contributor
Posts: 124
Registered: ‎03-20-2010

Re: Google Sheets & Hyperlinked Images - Help Please!

[ Edited ]

@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.

Respected Contributor
Posts: 4,299
Registered: ‎06-24-2011

Re: Google Sheets & Hyperlinked Images - Help Please!

[ Edited ]

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

 
  1. In Sheets, click the cell you want to add the link to.
  2. Click Insert. Link.
  3. In the Link box, click Select a range of cells to link.
  4. Highlight the cell or range of cells you want to link to. ...
  5. Click OK.
  6. (Optional) Change the link text.
  7. Click Apply.
Frequent Contributor
Posts: 124
Registered: ‎03-20-2010

Re: Google Sheets & Hyperlinked Images - Help Please!

@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.

Honored Contributor
Posts: 21,049
Registered: ‎07-26-2014

Re: Google Sheets & Hyperlinked Images - Help Please!


@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?

"Never argue with a fool. Onlookers may not be able to tell the difference."


220-AuCC-US-CRM-Header-Update.gif

Frequent Contributor
Posts: 124
Registered: ‎03-20-2010

Re: Google Sheets & Hyperlinked Images - Help Please!

@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.