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.

Auditing cell content with Watch Window and dependent cell formulas

Auditing cell content with Watch Window and dependent cell formulas - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Auditing cell content with Watch Window and dependent cell formulas

- [Lecturer] If you've got a workbook 2 where there are formulas in one worksheet 3 that get data from other worksheets, 4 sometimes it's a bit tricky 5 to track down all those interdependent formulas. 6 And there's a feature called Watch Window that we're about 7 to show you that will allow us to keep an eye 8 on this cell or that cell, 9 even quite a few different cells at the same time, 10 and always have them visible on our screen. 11 In this worksheet here, it's called "Fine Formulas", 12 if you look at this for a while, 13 you'll discover that cell B3 is pretty important. 14 And sometimes you want a more formal way of saying that. 15 You want to say, "I want to show you all the cells 16 that are dependent upon B3." 17 And on the Formulas tab in the ribbon 18 is a feature called Trace Dependents. 19 I want to know which cells will change if I change B3, 20 or, more precisely, which cells could change. 21 Click this once…

Contents