Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HYPERLINKS
I have an excel workbook with 3 work sheets. I want to hyperlink a cell in
one worksheet to a cell in another worksheet. How do I do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
HYPERLINKS
BG,
What you need to do is Link them. The easiest way I have found, and make the fewest errors typing is as follows: Open both worksheets and resize them to fit side by side on your screen. Say the cell in worksheet1, cell a16 has the value you want in worksheet2, cell b45. On worksheet2 in cell b45 select it and type "=" without "". Then select worksheet1 cell a16, by just selecting the cell. What you should see in the cell b45 is something like "=worksheet!1$A$16" without the "". hth "BG" wrote: I have an excel workbook with 3 work sheets. I want to hyperlink a cell in one worksheet to a cell in another worksheet. How do I do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlinks: Hyperlinks change on copy/paste? | Excel Worksheet Functions | |||
Update 2000 Excel hyperlinks to 2003 hyperlinks | Excel Worksheet Functions | |||
How toi turn-off hyperlinks [excel]? Email hyperlinks pop up ! | Excel Discussion (Misc queries) | |||
Hyperlinks | Excel Worksheet Functions | |||
Excel Hyperlinks- cell content v. hyperlinks | Excel Discussion (Misc queries) |