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? |
All times are GMT +1. The time now is 10:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com