| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
link cell to open a worksheet
I want to open up worksheet2 when I click on a cell in worksheet1, how can I
do this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
link cell to open a worksheet
Select the cell in worksheet1 where you want this to work. Insert a hyperlink
to the other worksheet. In Excel 2003, it's Insert Hyperlink. In Excel 2007, it's Insert | Links | Hyperlink. Browse to the desired worksheet/workbook/etc. then click OK. Hope this helps, Hutch "wilbo" wrote: I want to open up worksheet2 when I click on a cell in worksheet1, how can I do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why is it that when I link a cell to one from another worksheet, | Excel Worksheet Functions | |||
| doubleclick in cell to open link - how | Excel Worksheet Functions | |||
| Can you link a worksheet name into a cell? | Excel Discussion (Misc queries) | |||
| How can I link cell colours from worksheet to worksheet/workbook? | Excel Worksheet Functions | |||
| Why can't I link a cell from worksheet to another when it has an . | Excel Worksheet Functions | |||
Linear Mode
