| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
linking worksheets
I was given a workbook that contains 10 worksheets. The first sheet is called
"index". On this sheet are links to each of the worksheets in the workbook. All the other sheets contain the link "back to main index". Which takes the user back to the index worksheet. Can anyone direct me to the help for this, so I can learn how this is done? Is this something done manually? Or is it a function or macro? Thanks Rob |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
linking worksheets
=HYPERLINK(linklocation,friendlyname)
where linklocation is the filepath (or object in Excel) and friendly name is the name you use. If you know HTML it's somewhat similar to <a href="http://www.cnn.com"Click here for CNN</a where "Click here for CNN" would appear as text on screen, and the link would take you to cnn.com. HTH, Dave -- Brevity is the soul of wit. "RobC" wrote: I was given a workbook that contains 10 worksheets. The first sheet is called "index". On this sheet are links to each of the worksheets in the workbook. All the other sheets contain the link "back to main index". Which takes the user back to the index worksheet. Can anyone direct me to the help for this, so I can learn how this is done? Is this something done manually? Or is it a function or macro? Thanks Rob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking Worksheets | Excel Worksheet Functions | |||
| I am getting #VALUE! when linking worksheets - what am i doing wro | Excel Discussion (Misc queries) | |||
| Linking Excel Worksheets | New Users to Excel | |||
| Linking between multiple worksheets, workbooks and columns | Excel Discussion (Misc queries) | |||
| Linking across worksheets not working as desired | Excel Worksheet Functions | |||
Linear Mode
