0
votes
2answers
32 views

Add two variables to a Hyperlink

I know this works: = hyperlink( "https://www.google.com/search?q=" & B2 ) But I can't get two variables to work so the link would look like: https://www.google.com?var1=[insert cell ...
2
votes
0answers
66 views

Is there another way to click on the hyperlink in a Google Spreadsheet?

I am aware of the process to click a link on the spreadsheet. However, is there a way where the user of the sheet can directly click on the link? I am trying to prepare a decision tree where, once a ...
5
votes
2answers
2k views

Link to a cell in a Google Spreadsheet via URL?

One can link to a Google Spreadsheet via key, and via key and worksheet id: https://docs.google.com/spreadsheet/ccc?key=SOME_KEY ...
4
votes
1answer
1k views

Generating Google Spreadsheet hyperlinks from cell contents

I have a column of cells in a Google Spreadsheet with values such as: 37683 36583 38637 32391 What I would like to do is generate a hyperlink for each cell like: http://mywebsite.com?id=xxxxx ...
3
votes
2answers
2k views

A Way to Add Text Before Your Hyperlink in Google Spreadsheets?

Is there a way to add text before the hyperlink? So for example: This section needs reworking. You can find the section HERE. HERE would be the text replacement for the actual link. The actual ...
4
votes
1answer
3k views

How do I add a hyperlink to a cell in Google Spreadsheets?

In Excel, I can easily add a hyperlink to a cell by choosing the corresponding toolbar button. How do I do the same thing in a Google Doc spreadsheet? I don't see any corresponding toolbar button or ...