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?

Improve company productivity with a Business Account.Sign Up

x
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.