Can I create a hotlink to go from one cell to another in a wrksht
 

Is there a way to create a hotlink from one cell in a worksheet to another?
I want to be able to lick on the cell and be taken immediately to the one to
which it is linked.

Can I create a hotlink to go from one cell to another in a wrksht
 

=HYPERLINK("#Sheet2!Z100")

you can to to a cell in any worksheet.

You can also use:
Insert Hyperlink to a place in this document
--
Gary''s Student - gsnu200745


"Jim B-H." wrote:

Is there a way to create a hotlink from one cell in a worksheet to another?
I want to be able to lick on the cell and be taken immediately to the one to
which it is linked.

Can I create a hotlink to go from one cell to another in a wrksht
 

Look up HYPERLINK in Excel help.
--
David Biddulph

"Jim B-H." <Jim wrote in message
...
Is there a way to create a hotlink from one cell in a worksheet to
another?
I want to be able to lick on the cell and be taken immediately to the one
to
which it is linked.