Thinking now about workarounds, if you placed the URL in another cell, you leave a Hyperlink formula in your target cell, something that looks to the URL holder cell to complete itself. Something like:

=IF( D2 = "", , Hyperlink( D2, "Click Me") )

Needs testing!

If you'd like help entered directly on a Google Sheet, from me or dozens of other forum contributors, please share an editable copy we can all work on. Please take a look at: Google Product Experts' TIPS FOR POSTING

(Have sensitive info in your sheet? Read the tips!)

Best

Lance

Noelle Sillart

Dec 27, 2019

You can use the =HYPERLINK(...) formula. Start typing out that formula in the cell, and you will see the formula auto populate on the left bottom corner, click on the hyperlink formula, then type the link and label text in the correct format. For example:

=HYPERLINK(“www.google.com”, “Google”)

Don’t forget to use double quotes, not single quotes.

However, there doesn’t seem to be a “clickable” UI button to tap that simulates the same functionality in Docs/Slides. Bad Google.

Last edited Dec 27, 2019

Library Girl

Jan 11, 2020

Why is there not a way to do this? Seems like a very basic task. Super frustrating.