| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Connect Two Cells
Dear Experts,
In sheet 1 A1, I typed "See details". I want when this wording is pressed, it will then go to sheet 2 B3 and this cell is selected. This action is just like linking sheet 1 A1 to go to sheet 2 B3 and the value in these two cells will not be changed. Is it possible? If yes, how can I do it? Please kindly advise. Thanks in advance |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Connect Two Cells
You can use a hyperlink function:
Instead of typing "See details" in the cell enter this formula in cell A1: =HYPERLINK("#Sheet2!B3","See Details") Now, just click on "See Details" and it will take you to Sheet2 cell B3. -- Biff Microsoft Excel MVP "Freshman" wrote in message ... Dear Experts, In sheet 1 A1, I typed "See details". I want when this wording is pressed, it will then go to sheet 2 B3 and this cell is selected. This action is just like linking sheet 1 A1 to go to sheet 2 B3 and the value in these two cells will not be changed. Is it possible? If yes, how can I do it? Please kindly advise. Thanks in advance |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Connect Two Cells
Hi Biff,
Thanks for your great help. It works perfectly. Thanks once again. Cheers! "T. Valko" wrote: You can use a hyperlink function: Instead of typing "See details" in the cell enter this formula in cell A1: =HYPERLINK("#Sheet2!B3","See Details") Now, just click on "See Details" and it will take you to Sheet2 cell B3. -- Biff Microsoft Excel MVP "Freshman" wrote in message ... Dear Experts, In sheet 1 A1, I typed "See details". I want when this wording is pressed, it will then go to sheet 2 B3 and this cell is selected. This action is just like linking sheet 1 A1 to go to sheet 2 B3 and the value in these two cells will not be changed. Is it possible? If yes, how can I do it? Please kindly advise. Thanks in advance |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Connect Two Cells
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Freshman" wrote in message ... Hi Biff, Thanks for your great help. It works perfectly. Thanks once again. Cheers! "T. Valko" wrote: You can use a hyperlink function: Instead of typing "See details" in the cell enter this formula in cell A1: =HYPERLINK("#Sheet2!B3","See Details") Now, just click on "See Details" and it will take you to Sheet2 cell B3. -- Biff Microsoft Excel MVP "Freshman" wrote in message ... Dear Experts, In sheet 1 A1, I typed "See details". I want when this wording is pressed, it will then go to sheet 2 B3 and this cell is selected. This action is just like linking sheet 1 A1 to go to sheet 2 B3 and the value in these two cells will not be changed. Is it possible? If yes, how can I do it? Please kindly advise. Thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I connect Excel cells to cells in an embedded Word table? | Excel Discussion (Misc queries) | |||
| how do I connect cells on two pages? | New Users to Excel | |||
| How do I connect two cells? If one cell changes the other changes | Excel Discussion (Misc queries) | |||
| How to connect characters together in different cells? | Excel Discussion (Misc queries) | |||
| Connect two Cells without loosing content | Excel Discussion (Misc queries) | |||
Linear Mode
