Hyperlink help (Specific Cell Link on Excel HTML Pages)

[gottimd]

Is there a way to hyperlink to a specific cell on an excel generated HTML page?

I have a workbook, with 2 pages, and each is formatted in a macro to be an HTML page which I will upload. The First sheet, "x", I want to point to a specific cell in the second sheet "y", when pressed as an Html page. I can get the hyperlink to go to the page but not a specific cell.

So, lets say on HTML page "x.html", I press a hyperlink that I want to open up page "y.html", cell A5, how do I create a hyperlink to do that? All I can do or know how to do is, if you press on the hyperlink in page "x", it opens up page "y.html" but doesn't go to the specific cell. Is this possible?

 

[Greg Truby]

I didn't test this. But as I recall, while you can link to a cell address it works a little cleaner if you name the cell first. I think Excel then puts an anchor tag with that name there. Then you can link to that name fairly easily as I recall. But it's been like two years since I've had to play with Excel-generated HTML and hyperlinks, etc.; but hope that leads in the right direction...

 

[gottimd]

Ok, so I named the Cells specific names on "y.html" in the excel spreadsheet that makes "y.html". How do I hyperlink it from "x.html" now?

 

[Greg Truby]

I think I'm misunderstanding what you're doing. Are you editing the HTML in a text or HTML editor? Or are you doing all of this in Excel? I assumed you were editing this with an HTML editor and already were very fluent in creating HTML tags by hand.

 

[gottimd]

Doing it in both, but mainly in excel. I think I figured it out through trial and error. Just in case someone is looking at this later....

I named the Cell "HI"
in the hyperlink box, I typed the hyperrlink to go to "www.YYY.com/XXX.html#HI"

Just added the #HI at the end of the webpage it is looking at.

Thanks for the help!

 

[Greg Truby]

Correct, it's pound sign and cell name. (My apology, I assumed you new that.) However, I would leave out the base URL reference, i.e. make it relative that way less maintainence if the underlying path were to change, i.e. something like

test link