| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
links?
How do I set up a cell so that when you click on it, it directs you to an
explanation of the data on another worksheet? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
links?
--Right click on the cellHyperlinkFrom the left "Link to" icon list select
''Place in this document' Select the sheet name and enter the cell reference.. --OR try the below formula to refer Sheet2 cell C3 =HYPERLINK("#Sheet2!C3","") -- Jacob "anne" wrote: How do I set up a cell so that when you click on it, it directs you to an explanation of the data on another worksheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Slow opening links between workbooks with links created in 2003 | Excel Discussion (Misc queries) | |||
| Update links box gives Continue or Edit Links dialog | Excel Discussion (Misc queries) | |||
| Edit Links: Changing links on a protected worksheet | Excel Discussion (Misc queries) | |||
| EXCEL - LINKS cannot easily get list of all links & names in book | Excel Worksheet Functions | |||
| can't update links...can't find links | Excel Discussion (Misc queries) | |||
Linear Mode
