ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Click on a word and have it link to another page (https://www.excelbanter.com/excel-discussion-misc-queries/162364-click-word-have-link-another-page.html)

Courtneyf04

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.

Peo Sjoblom

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.




Roger Govier[_3_]

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.





All times are GMT +1. The time now is 08:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com