F2 Edit Key

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
tools
formula auditing
Trace precedents

Check the precedents and then delete the lines with
tools
formula auditing
Remove all arrows
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Move or Copy Stopped Working? 0
Need VLOOKUP to Work Two Ways 0
INDIRECT with Sheet Level Defined Name 2
How do I change contents of a cell based on drop down list selecte 2
Excel Highlighting duplicates 0
Randbetween Range Problem 0
using the =page! feature to transpose a row to column 0
Excel Count If Formula Question 1

Back
Top