From the course: Excel 2016: Tips and Tricks

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Select all cells that depend on the active cell

Select all cells that depend on the active cell

From the course: Excel 2016: Tips and Tricks

Start my 1-month free trial

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…

Contents