Menu
In google spreadsheets, it is possible to add a hyperlink to a cell as:
=hyperlink("www.google.com", "search the web") This will show the text search the web which will hyperlink to google. However, I am wondering:
How can this rule be inserting into the middle of a cell? In other words, I'd like a single cell to look like:
click here for answer
389
On a worksheet, select the cell where you want to create a link. On the Insert tab, select Hyperlink. You can also right-click the cell and then select Hyperlink... on the shortcut menu, or you can press Ctrl+K. Under Display Text:, type the text that you want to use to represent the link.
Right click in your spreadsheet and select the Insert link option. Use the Ctrl + K keyboard shortcut (Cmd + K on a Mac). In the “Text” field that appears, type or edit the text you'd like displayed in the cell containing the link.
As of now (June, 2020), it is possible to do what you described. Here is an official documentation.
Shortly:
Select part of text where you want to add a link, then click Insert -> Link or using shortcuts - CMD + K/CTRL + K. Personally, when I was clicking Insert from menu bar, my text was deselected, so shortcut solved the issue.
Extra Note: You can also link to other cells or sheet in a spreadsheet. Really cool feature.
88
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
