![]() |
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. |
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. |
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