Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlink to a specific cell
Hi all,
I have a file with 2 sheets. One with Anual Sales, the other with client information. I would like to be able to click on the client number on the anual sales and get to that specific client on the client information sheet (both sheet have client number). I tried the hyperlink but I don't know how to set it to point to a specific cell. Any help will be very welcome! Barbara |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlink to a specific cell
Hi,
Select the cell you want to Hyperling to and then Insert|name|define and give your cell a meaningful name. Click OK Select the cell to Hyperlink from and then InesrtHyperling|Place in this document You should see the name you just created appear. Select it and click OK and your done. Mike "Barbara" wrote: Hi all, I have a file with 2 sheets. One with Anual Sales, the other with client information. I would like to be able to click on the client number on the anual sales and get to that specific client on the client information sheet (both sheet have client number). I tried the hyperlink but I don't know how to set it to point to a specific cell. Any help will be very welcome! Barbara |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlink to a specific cell
Hi Mike,
Very sorry Mike but I believe I explain the problem wrong. The Client Number cell in Anual Sales sheet must redirect me to some cell in Contact Information Sheet. Ex. Client Number cell in Anual Sales sheet = 9101 Contact Information Sheet= must find the client with number 9101. Hope to hear from you soon with any suggestion. Thanks. "Mike H" wrote: Hi, Select the cell you want to Hyperling to and then Insert|name|define and give your cell a meaningful name. Click OK Select the cell to Hyperlink from and then InesrtHyperling|Place in this document You should see the name you just created appear. Select it and click OK and your done. Mike "Barbara" wrote: Hi all, I have a file with 2 sheets. One with Anual Sales, the other with client information. I would like to be able to click on the client number on the anual sales and get to that specific client on the client information sheet (both sheet have client number). I tried the hyperlink but I don't know how to set it to point to a specific cell. Any help will be very welcome! Barbara |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink to specific text within a cell | Excel Discussion (Misc queries) | |||
Hyperlink to a cell, in a different sheet, that cointains a specific taxt | Excel Worksheet Functions | |||
How do I hyperlink to a specific cell in other excel worksheet? | Excel Worksheet Functions | |||
hyperlink to specific cell/row | Excel Discussion (Misc queries) | |||
Hyperlink button to a specific cell in excel | Excel Discussion (Misc queries) |