Join Dennis Taylor for an in-depth discussion in this video Tracking down cell dependencies across multiple worksheets and workbooks, part of Excel Tips Weekly.
- Worksheet troubleshooting and worksheet auditing…are difficult tasks if performed manually.…Excel has some keystroke shortcuts,…some techniques for helping you figure out…the implications, for example, of changing a cell's content.…This is a particularly unwieldy worksheet.…Got lots of different formulas in it, inner relationships.…Maybe you've looked at it for five or ten minutes,…you've come to realize that cell B3 is pretty important.…And you're wondering if you change that,…which other cells will change.…So for example, you might click on cell E5,…double click or look in the formula bar,…it directly relates back to B3.…
How about cell F12?…That does too.…How about cell E13?…Well that doesn't say B3, but it does refer to B8.…Does B8 refer to B3?…Let's go to B8.…Looks like that doesn't.…But we could have some layers here of dependencies.…Go down to this cell.…That doesn't refer to B3 but it refers to E17, E18,…does one of those refer back to B3?…You start to gather the idea here…that this is not exactly going to be easy.…
Skill Level Appropriate for all
Excel Tips - New This Week
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.