Linking a hyperlink to a named Excel cell

How do I create a hyperlink that links to a specific cell in an Excel spreadsheet? I am only able to do it if I use the cell number, not if I assign a specific name to a cell.

patriciasrinathAsked:
Who is Participating?
 
seanpowellConnect With a Mentor Commented:
Like this:

<a href="myworkbook.xls#mylink">Sheet 3, Column A</a> ... where A1 has the name "mylink"
0
 
seanpowellCommented:
I take it that worked for you - I wasn't sure how much information to provide ...

Thanks,
Sean
0
 
patriciasrinathAuthor Commented:
My method was right but I was linking it to the wrong document.

Your information was fine but I didn't have to add the sheet or column information to make it work.

Thanks,
Pattie
0
 
seanpowellCommented:
Gotcha - thanks Pattie :-)
0
All Courses

From novice to tech pro — start learning today.