F2 Highlights in Excel

[cspgsl]

Pressing F2 in Excel highlights all of the cells on the same sheet that are part of the formula. When I have two sheets, or more open on screen and have a formula with a reference to one or more of the other sheets is there a way F2 will highlight the cells on the other sheets in the same way?

Thank you, one and all, once again.

 

[karenbobby]

Hello,

Please try to use the Audit Function in TOols > Audits and there should be one call "Precedents", click on it and it will show you all the related cells incorporated in your formula, even off-sheet cells.

Good Luck