Hyperlink Function to Cell in the Same Sheet
Solved
Caroline
-
Anonymous user -
Anonymous user -
Hello,
I'm trying to create hyperlinks to jump from cell A1 to cell A500, from cell A500 to cell A1000, and so on, using the hyperlink function because I will need to create a hundred of these links, or more, to allow me to quickly navigate from one range to another.
I want to be able to easily add or modify these links when rows are added in between (which would change my needs, for example, from A1 to A503, then from A503 to A1006, etc.)
I've tried:
=HYPERLINK(CELL("address",Sheet1!A500,"text to display")
in Excel in French would be: =LIEN HYPERTEXTE(CELLULE("adresse";Sheet1!A500;"texte à afficher")
which gives me the error "cannot open the specified file" that I couldn't resolve with the solutions I've found so far.
I then tried:
=HYPERLINK(Sheet1!A500,"text to display")
in Excel in French would be: =LIEN HYPERTEXTE(Sheet1!A500,"texte à afficher")
When I click on my link, there's no error message, but I remain on the cell containing the link instead of being sent to the desired cell.
Could someone guide me on what I might not be understanding correctly in my attempts?
I don't want to go through the link insertion box that I would normally use for smaller files, but this one has over 17,000 rows separated into blocks of 500, each having a link to quickly reach the next one, so that's a lot of CTRL+K clicking...
Thank you in advance!
Configuration: Windows / Chrome 98.0.4758.82
I'm trying to create hyperlinks to jump from cell A1 to cell A500, from cell A500 to cell A1000, and so on, using the hyperlink function because I will need to create a hundred of these links, or more, to allow me to quickly navigate from one range to another.
I want to be able to easily add or modify these links when rows are added in between (which would change my needs, for example, from A1 to A503, then from A503 to A1006, etc.)
I've tried:
=HYPERLINK(CELL("address",Sheet1!A500,"text to display")
in Excel in French would be: =LIEN HYPERTEXTE(CELLULE("adresse";Sheet1!A500;"texte à afficher")
which gives me the error "cannot open the specified file" that I couldn't resolve with the solutions I've found so far.
I then tried:
=HYPERLINK(Sheet1!A500,"text to display")
in Excel in French would be: =LIEN HYPERTEXTE(Sheet1!A500,"texte à afficher")
When I click on my link, there's no error message, but I remain on the cell containing the link instead of being sent to the desired cell.
Could someone guide me on what I might not be understanding correctly in my attempts?
I don't want to go through the link insertion box that I would normally use for smaller files, but this one has over 17,000 rows separated into blocks of 500, each having a link to quickly reach the next one, so that's a lot of CTRL+K clicking...
Thank you in advance!
Configuration: Windows / Chrome 98.0.4758.82
5 answers
Hello
Why not use the menus to insert your links??
Insert Menu, Link
Furthermore, you just need to "name" the areas you want and use them as a link!!!
A+
If the answer helped you, a little click on the thumbs up, that’s great... Resolved, that’s perfect.
Let he who has never opened a user manual throw me the first mouse ;-)
Why not use the menus to insert your links??
Insert Menu, Link
Furthermore, you just need to "name" the areas you want and use them as a link!!!
A+
If the answer helped you, a little click on the thumbs up, that’s great... Resolved, that’s perfect.
Let he who has never opened a user manual throw me the first mouse ;-)
I promise I’ll come back to give a thumbs up if it turns out that this solves my issue for the current file.
But in the meantime, if others have ideas for what isn’t working with my use of the hyperlink function, I feel like I won’t be able to sleep well until I understand why I don’t understand.
However, I imagine that even with defined names, I can’t make it dynamic, or am I wrong?