If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
hyperlink
Hi, I am a newbie,please help. I created a hyperlink to jump from cell a1 to n1 on sheet1, I copied this link to sheet2, it will work the same on sheet2, however when I modified the cell address on this hyperlink, it will only work on sheet2 only. When I copied this hyperlink from sheet2 to sheet3, and when I clicked on the link, it went from sheet3 back to sheet2, seems to me when you modified a hyperlink, it will become worksheet specific. Can someone please tell me how to correct this? Thanks in advance! Tom -- pohaku ------------------------------------------------------------------------ pohaku's Profile: http://www.excelforum.com/member.php...o&userid=29329 View this thread: http://www.excelforum.com/showthread...hreadid=490516 |
#2
|
|||
|
|||
hyperlink
Did you look at the actual hyperlink Ctrl+K,
you would have to click and not release, then release slowly to not take the link so you can use Ctrl+K. More information in http://www.mvps.org/dmcritchie/excel/buildtoc.htm Anyway there are two parts to the hyperlink, what you see and the hyperlink. If you type something into the cell you are not changing an existing hyperlink.- --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "pohaku" wrote in message news Hi, I am a newbie,please help. I created a hyperlink to jump from cell a1 to n1 on sheet1, I copied this link to sheet2, it will work the same on sheet2, however when I modified the cell address on this hyperlink, it will only work on sheet2 only. When I copied this hyperlink from sheet2 to sheet3, and when I clicked on the link, it went from sheet3 back to sheet2, seems to me when you modified a hyperlink, it will become worksheet specific. Can someone please tell me how to correct this? Thanks in advance! Tom -- pohaku ------------------------------------------------------------------------ pohaku's Profile: http://www.excelforum.com/member.php...o&userid=29329 View this thread: http://www.excelforum.com/showthread...hreadid=490516 |
#3
|
|||
|
|||
hyperlink
Hi David, After I posted the thread, I was able to find the solution for myself by doing a search on the forum, I found the formula "=HYPERLINK("#"&CELL("address",C7),"text")"tha t works for my what I wanted. Thanks for your kind reply! Tom -- pohaku ------------------------------------------------------------------------ pohaku's Profile: http://www.excelforum.com/member.php...o&userid=29329 View this thread: http://www.excelforum.com/showthread...hreadid=490516 |
#4
|
|||
|
|||
hyperlink
Hi Tom,
You're welcome. I do hope that you will look at the webpage, actually for this aspect this one is better http://www.mvps.org/dmcritchie/excel....htm#hyperlink so that it is better understood. It took a lot of work to make it so that you could refer to a cell address not within quotes, that would work in Excel 97 through Excel 2000. Later versions are more straight forward, as described there, but would not be backward compatible. . Google web searches and Google Groups searches would be a lot more efficient without the over 50 Forums copying a small group of Excel newsgroups into web pages making it bloody difficult to do web searches without really complicated means of eliminating "forums". The newsgroup don't have things repeated because they are where the questions are answered so you normally only have one copy of a thread. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "pohaku" wrote in ... Hi David, After I posted the thread, I was able to find the solution for myself by doing a search on the forum, I found the formula "=HYPERLINK("#"&CELL("address",C7),"text")"tha t works for my what I wanted. Thanks for your kind reply! Tom -- pohaku ------------------------------------------------------------------------ pohaku's Profile: http://www.excelforum.com/member.php...o&userid=29329 View this thread: http://www.excelforum.com/showthread...hreadid=490516 |
#5
|
|||
|
|||
hyperlink
Hi David, that was a good link, I learned more from this link, now I am going to try apply some of them, thanks again! -- pohaku ------------------------------------------------------------------------ pohaku's Profile: http://www.excelforum.com/member.php...o&userid=29329 View this thread: http://www.excelforum.com/showthread...hreadid=490516 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I add a Hyperlink field from a table to a data access page | mcavallaro | Database Design | 0 | August 31st, 2005 08:31 PM |
Hyperlinks in Access 97 | Mike in L.A. | Using Forms | 1 | March 1st, 2005 08:17 AM |
How do I get all hyperlink fields to use the base hyperlink inst.. | daddyman | Database Design | 0 | January 19th, 2005 07:27 PM |
Using Hyperlinks in Mail Merge IF...THEN...ELSE Statements | Mark V | Mailmerge | 8 | November 30th, 2004 01:31 PM |
Multiple hyperlink and followed hyperlink styles | skellis | Formatting Long Documents | 3 | June 17th, 2004 10:18 PM |