Select all cells that depend on the active cell

- [Voiceover] This worksheet called Formulas…has a lot of formulas in it, and you've discovered…after looking at it for five or 10 minutes…that cell B3 is pretty important.…What you'd like to be able to know, also,…is if you change B3, what are the implications of that?…Which other cells will change?…In other words, which cells have formulas…that refer to B3, or even going a step further,…which cells have formulas that refer to other…cells that refer to other cells that refer to B3?…And so on and so on.…So we can get there quickly with a keystroke shortcut.…

Select the cell we're interested in, in this case B3,…and press Control Shift ]…That key is two letters to the right of the letter P…on most keyboards, and whether you say right bracket…or right brace, ultimately we mean the same thing…because we're holding down Control and Shift.…So what happens?…These cells are highlighted.…I'll scroll up and down a little bit.…There are a few down there as well.…Now, if you want to you can apply a color to these,…and for the moment, maybe you'll keep that handy,…