| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create a hyperlink to a cell with the hyperlink function
I am trying to link from one cell to another in Excel 2003 with the hyperlink
function. When I use the following format shown in the hyperlink function help, it does not work. =HYPERLINK("[Budget]June!E56", E56) I have also tried removing the file name ([Budget]) and the double quotes. I have tried using the single quotes around the sheet name ('June') as in a cell reference, but the link still does not work. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I create a hyperlink to a cell with the hyperlink function
David McRitchie posted this and it might help you:
=HYPERLINK("#"&CELL("address",C5),C5) =HYPERLINK("#"&CELL("address",sheetone!C5),sheeton e!C5) =HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5) S. Bevins wrote: I am trying to link from one cell to another in Excel 2003 with the hyperlink function. When I use the following format shown in the hyperlink function help, it does not work. =HYPERLINK("[Budget]June!E56", E56) I have also tried removing the file name ([Budget]) and the double quotes. I have tried using the single quotes around the sheet name ('June') as in a cell reference, but the link still does not work. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I create a hyperlink to a cell with the hyperlink function
i've never used that function before but this worked for me =HYPERLINK([Book2]Sheet1!$E$56,"E56") *edit* beaten to the punch -- MDubbelboer ------------------------------------------------------------------------ MDubbelboer's Profile: http://www.excelforum.com/member.php...o&userid=36330 View this thread: http://www.excelforum.com/showthread...hreadid=563434 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a function to extract the URL part of a hyperlink in another cell? | Excel Worksheet Functions | |||
| Create a Function similar to multiple IFs | Excel Discussion (Misc queries) | |||
| How do I create a footnote for a cell that holds a SUM function . | Excel Discussion (Misc queries) | |||
| Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
| create hyperlink in one cell with URL in a different cell | Excel Worksheet Functions | |||
Linear Mode
