Solved

Linking a hyperlink to a named Excel cell

Posted on 2004-03-29
4
283 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When setting up new project requests for our site, one of the most powerful tools our team has available to use is Axure (http://www.axure.com/). It’s a tool for creating software and web prototypes that can function and interact as if it were the a…
This guide will walk you through the essential considerations and tech stack for building scalable websites. Know how to grow your business the smart way!
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…
The purpose of this video is to demonstrate how to set up an RSS Feed on a WordPress Website. This will be demonstrated using a Windows 8 PC. Feedburner will be used for this demonstration. Go to your WordPress login page. This will look like the…

624 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