Timeline for How to create no pop-up Hyperlinks/Bookmarks for an array of cells within the same tab/sheet
Current License: CC BY-SA 4.0
12 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 5, 2020 at 22:28 | comment | added | Kyle Chapman | Good point. I think you're right regarding the accuracy. I'll change the title. Thank you, again, for all of your help. | |
| Feb 5, 2020 at 21:54 | comment | added | marikamitsos | Glad it worked out. You could probably change the question title to "How to create no pop-up Hyperlinks/Bookmarks for an array of cells within the same tab/sheet". I believe it is more accurate or.... not? | |
| Feb 5, 2020 at 21:06 | comment | added | Kyle Chapman | Thank you so much for your time and effort in explaining this to me! This solution produces the EXACT behavior I've been looking for! Thank you for all of your help and patience, you are a lifesaver! | |
| Feb 5, 2020 at 15:34 | history | edited | marikamitsos | CC BY-SA 4.0 |
added 887 characters in body
|
| Feb 4, 2020 at 3:10 | comment | added | Kyle Chapman | Thank you for the update! So my new formula looks like this "=ArrayFormula(HYPERLINK(J2:J632,K2:K632))" But the link it embeds to the text doesn't actually work. It produces links like this: "for%20one%20hour%2C%20the%..." which just open a new blank tab. | |
| Feb 4, 2020 at 2:34 | comment | added | marikamitsos | Please check the updated answer. | |
| Feb 4, 2020 at 2:34 | history | edited | marikamitsos | CC BY-SA 4.0 |
added 211 characters in body
|
| Feb 4, 2020 at 2:12 | vote | accept | Kyle Chapman | ||
| Feb 4, 2020 at 1:49 | comment | added | Kyle Chapman | In other words, I want the <name> in B2 to hyperlink to the description in J2. B3 to J3, and so on. | |
| Feb 4, 2020 at 1:47 | comment | added | Kyle Chapman | Awesome! This definitely seems like a step in the right direction. I'm still learning many of the intricacies in Google Sheets/Excel, so forgive my ignorance. Here is an image of the sheet I have been working on. I have been making modifications to an existing spreadsheet to make a gaming tool for my group on Discord. The goal is to keep the text already in the cells under column B, but have the text hyperlink to a cell in column J on the same row. Because of existing formulas and formatting on this worksheet, I'm avoiding adding/removing rows. | |
| Feb 4, 2020 at 1:06 | history | edited | marikamitsos | CC BY-SA 4.0 |
Added more info and image
|
| Feb 4, 2020 at 0:51 | history | answered | marikamitsos | CC BY-SA 4.0 |