From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,400 courses taught by industry experts.

Tracking down cell dependencies across multiple worksheets and workbooks

Tracking down cell dependencies across multiple worksheets and workbooks - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Tracking down cell dependencies across multiple worksheets and workbooks

- [Instructor] Worksheet Troubleshooting 2 and Worksheet Auditing are difficult tasks 3 if performed manually. 4 Excel has some keystroke shortcuts, 5 some techniques for helping you 6 figure out the implications 7 for example, of changing a sales content. 8 This is a particularly unwieldy worksheet. 9 Got lots of different formulas in it, 10 interrelationships. 11 Maybe you've looked at it for 5 or 10 minutes. 12 You've come to realize that cell B3 13 is pretty important. 14 And you're wondering if you change that, 15 which other cells will change. 16 So for example, you might click on cell E5, 17 double click or look in the formula bar. 18 It directly relates back to B3. 19 How about cell F12? 20 That does too. 21 How about cell E13? 22 Well, that doesn't say B3, 23 but it does refer to B8. 24 Does B8 refer to B3? Let's go to B8. 25 Looks like that doesn't. 26 But we could have some layers here, 27 of…

Contents