I have 2 screens. Sometimes, when I have one excel sheet on one screen, and
another in the same workbook on the other screen, hitting F2 on a formula
will highlight the dependent cells on each screen (i.e., in each worksheet).
Other times, it only highlights the dependent cells on the sheet on which my
formula exists. It is quite helpful to see the depedent cells on in all
sheets. Any thoughts? Thanks