To reply to your question TSTom, when the precedent is in another sheet, an icon pops up on the screen. You can click on it and it tells you where the cell is being referenced from. you can then chose to be taken to that sheet. My issue is that I want to come back to my original sheet i.e. from where I started, without manually having to come back.