• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Find precedence of formula on different sheet

P

Paresh Padhye

New Member
Can Ctrl+[ shown precedences of formula even if some of the arguments of formulas are on other sheet. I tried it but it seems to shows arguments only on the same sheet (which has formula)
 
Paresh
Ctrl [ Precedent and Ctrl ] Dependent will jump to the referenced cells
But will only jump to another sheet if the referring cell only references that sheet alone
If a formula references multiple sheets it stays on the same sheet as the source cell
 
You must log in or register to reply here.
Back
Top