follow link
 

I have linked a number of figures from other sheet. Now if I want to check
from where it is coming, I have to go to that cell, read the reference and go
to the sheet manually. The other option is through auditing tool bar. I have
seen a friend who used to double click the cell and it automatically goes to
that sheet from where the figure is coming. How do you do that?

Good afternoon Kumail

Are you sure that your friend wasn't using Lotus 1-2-3? I seem to
remember that this program has that particular feature but not Excel.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=391749

FindLink is a popular utility for dealing with external workbook links. I've
not used it myself but many folks here have recommended to other posters.

http://www.bmsltd.ie/MVP/






"Kumail" wrote:

I have linked a number of figures from other sheet. Now if I want to check
from where it is coming, I have to go to that cell, read the reference and go
to the sheet manually. The other option is through auditing tool bar. I have
seen a friend who used to double click the cell and it automatically goes to
that sheet from where the figure is coming. How do you do that?