F2 Edit Key

D

dr

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
 
L

Leo Rod

tools
formula auditing
Trace precedents

Check the precedents and then delete the lines with
tools
formula auditing
Remove all arrows
 
D

dr

Thanks - I'm looking for the way to do it without trace precedents, as doing
so creates the reference box to another sheet, whereas I'm looking to see the
boxes immediately highlighted. But appreciate the suggestion! thx
 
Top