Solved

Linking a hyperlink to a named Excel cell

Posted on 2004-03-29
4
278 Views
Last Modified: 2013-12-24
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.

0
Comment
Question by:patriciasrinath
  • 3
4 Comments
 
LVL 31

Accepted Solution

by:
seanpowell earned 500 total points
ID: 10714818
Like this:

<a href="myworkbook.xls#mylink">Sheet 3, Column A</a> ... where A1 has the name "mylink"
0
 
LVL 31

Expert Comment

by:seanpowell
ID: 10726338
I take it that worked for you - I wasn't sure how much information to provide ...

Thanks,
Sean
0
 

Author Comment

by:patriciasrinath
ID: 10727378
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
 
LVL 31

Expert Comment

by:seanpowell
ID: 10727396
Gotcha - thanks Pattie :-)
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

When deciding to adopt any help desk solutions many factors should be explored before taking decisions. This will change from business to another but in general there are some kind of rule of thumb. Here are some quick tips: Do we need only ticket…
Now that Expression Web 4.0 (http://www.microsoft.com/expression/products/Upgrade.aspx) is free if you buy or have the full version of Expression Web 3.0, now is the best time to  migrate from FrontPage to Expression Web (http://www.frontpage-to-exp…
The purpose of this video is to demonstrate how to make a WordPress Site faster and smaller in size by cleaning up the database. This will be demonstrated using a Windows 8 PC. Plugin WP Optimize will be used. Go to your WordPress login page. T…
The purpose of this video is to demonstrate how to properly insert a Vimeo Video into a WordPress site or Blog. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now