Tracing precedants in another worksheet

[samidodger]

Basically I have a worksheet and it has cells. These cells are linked to other cells on another worksheet. When I click on one cell and then click on the "Trace precedants" button in Excel it will just come up with a picture saying 'another worksheet'. Is there a way to exactly find what worksheet in the book it is picking up the data from and what cell?

Im using Microsoft Excel 2007.

 

[VaraK]

Hi,

Welcome to the board.

Press Ctrl+[ . This will take you to the linked cell. Hope this helps.

 

[samidodger]

Hi,

Welcome to the board.

Press Ctrl+[ . This will take you to the linked cell. Hope this helps.

Thanks very much appreciated.