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?

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?