| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make a hyperlink cell-specific between two XL sheets?
Suppose you want to jump from A1 of sheet1 to B10 of sheet2 - put this
formula in A1 of sheet1: =HYPERLINK("#sheet2!B10","jump") The word "jump" will appear in the cell, and when you click on this your cursor will jump to B10 of sheet2. Just adjust the sheet name and cell reference to suit your situation. Hope this helps. Pete On Apr 29, 10:27*am, Brian RRR <Brian wrote: When creating a hyperlink between two separate XL sheets, how do I make it cell-specific? Currently all I can do is make the hyperlink point to the sheet overall, not to the specific cell. I am using Excel 2003. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hyperlink to a specific cell | Excel Discussion (Misc queries) | |||
| Hyperlink to specific text within a cell | Excel Discussion (Misc queries) | |||
| How do I hyperlink to a specific cell in other excel worksheet? | Excel Worksheet Functions | |||
| hyperlink to specific cell/row | Excel Discussion (Misc queries) | |||
| How do I make a cell date specific to input a value on a specific. | Excel Discussion (Misc queries) | |||
Threaded Mode
