| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Click on a word and have it link to another page
Excel 2007.
Would like to have a hyperlink built-in to the page so that when I click on a word it will bring up a sheet that is in the same workbook. How would I go about doing this? I've read about linking but I don't want to transfer any values. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Click on a word and have it link to another page
Type the word you want, select the cell with the word you just typed and do
inserthyperlinkplace in this document and select the sheet and cell -- Regards, Peo Sjoblom "Courtneyf04" wrote in message ... Excel 2007. Would like to have a hyperlink built-in to the page so that when I click on a word it will bring up a sheet that is in the same workbook. How would I go about doing this? I've read about linking but I don't want to transfer any values. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Click on a word and have it link to another page
Hi
Type any text you want in a cell. Right click on the cellHyperlinkin left hand pane chooseplace in this DocumentSelect Sheet in Type the cell Referenceenter the cell you wish to be activated on pressing the link. -- Regards Roger Govier "Courtneyf04" wrote in message ... Excel 2007. Would like to have a hyperlink built-in to the page so that when I click on a word it will bring up a sheet that is in the same workbook. How would I go about doing this? I've read about linking but I don't want to transfer any values. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Link table from excel to word using word VBA | Excel Discussion (Misc queries) | |||
| if i sort cell that has link to another page how to keep link | Excel Discussion (Misc queries) | |||
| if i sort cell that has link to another page how to keep link | Excel Discussion (Misc queries) | |||
| Excel: How do I set up a cell to click it to link a database? | Excel Discussion (Misc queries) | |||
| how do i link a word to a colour so everytime i type the word gre. | Excel Discussion (Misc queries) | |||
Linear Mode
