Solved

Linking a hyperlink to a named Excel cell

Posted on 2004-03-29
4
281 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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

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…
Turn A Profile Picture Into A Cartoon Using Photoshop And Illustrator This tutorial will teach you how to make a cartoon style image out of a regular picture. I have tried to keep the tutorial as simple as possible. I used Adobe CS4 for this tuto…
The purpose of this video is to demonstrate how to create a Printer Friendly PDF on a WordPress Page. This will be demonstrated using a Windows 8 PC. Tools Used are Photoshop, Awesome Screenshot” Google Chrome Extension, and SmallPDF.com Log…
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…

680 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