bertusgeert 1 #1 October 4, 2007 I'm looking a cell B3, and i'm wondering - what other cells reference cell B3. How do I find out? --------------------------------------------- As jy dom is moet jy bloei! Quote Share this post Link to post Share on other sites
tweak 0 #2 October 4, 2007 Edit->Find. Enter 'B3' or the cell you're looking for and make sure 'Formulas' is selected in the 'Look In' box and click 'Find Next'. Quote Share this post Link to post Share on other sites
billeisele 130 #3 October 4, 2007 or just "turn on" the auditing toolbar an duse those functionsGive one city to the thugs so they can all live together. I vote for Chicago where they have strict gun laws. Quote Share this post Link to post Share on other sites
Elisha 1 #4 October 4, 2007 Quoteor just "turn on" the auditing toolbar an duse those functions Yes....and then click on the "trace precedents" button to see what cells factor into the formula in B3 or whatever cell you're looking at. Quote Share this post Link to post Share on other sites
bertusgeert 1 #5 October 5, 2007 Quote Quote or just "turn on" the auditing toolbar an duse those functions Yes....and then click on the "trace precedents" button to see what cells factor into the formula in B3 or whatever cell you're looking at. I don't like to use the word unless I mean it. AWESOME! I love learning new things in .xls all the time, it's kind of (but i'm sure not quite) like the Bloomberg machine i'm on right now - VERY powerful - if I only knew how to utilize them better. But i'm learning...THANKS --------------------------------------------- As jy dom is moet jy bloei! Quote Share this post Link to post Share on other sites
