Aug 3, 2026 · 1 hr 46 min · 12 segments
- Tiny Excel Tip — Find Dependencies - [Virtual \]\[ — an Apple \]\…
George from TulsaUnfortunately, that was 10 p.m. the day before for me, as he's in New Zealand.
I was so intrigued by the question that I told him I'd work on it the next day.
And as no surprise to anyone, it was the first thing I thought of when I woke up the next day.
The question Alistair asked was, do you know if there's a way in Excel for Mac to find out everywhere a cell is referenced? You know what I asked him before looking into this, right? What problem were you trying to solve? He answered with, I have a complicated workbook with multiple sheets and all sorts of bespoke calculations.
I have a set of values, numbers of days, that have been unchanged almost since I started working on this months ago.
So before I change one of the values, I want to see what areas I need to consider.
I mean, I wasn't financially invested, he was, but I was mentally invested on behalf of my friend.
I have to confess that I had to search for the answer, and what I discovered was that there are two methods, both with their own merits.
Select the cell for which you want to see Dependence, and then hold down Control and the right bracket, and all dependents of that cell on the same sheet will be selected.
Using this method, you could then tap the paint bucket icon in the Home tab to set them, say, all to yellow, making them easier to find as you work on the spreadsheet.
If you want to see the precedence, meaning all cells on which the selected cell is dependent, you use Control-Left Bracket.
Now, this is quite useful, but it won't actually solve Alistair's problem because it only finds dependence and precedence on the same sheet as the selected cell.
It's also quite clever and not like anything I've ever seen in Excel before.
You should see a section with three commands, trace precedence, trace dependence, and remove arrows with a downward chevron.
As always with Microsoft Office, remember that if your window is too narrow, you may not see all of these options.
Now, let's talk about what happens if we select a cell and we choose Trace Dependence from the ribbon.
Unfortunately, that was 10 p.m. the day before for me, as he's in New Zealand.
I was so intrigued by the question that I told him I'd work on it the next day.
And as no surprise to anyone, it was the first thing I thought of when I woke up the next day.
The question Alistair asked was, do you know if there's a way in Excel for Mac to find out everywhere a cell is referenced? You know what I asked him before looking into this, right? What problem were you trying to solve? He answered with, I have a complicated workbook with multiple sheets and all sorts of bespoke calculations.
I have a set of values, numbers of days, that have been unchanged almost since I started working on this months ago.
So before I change one of the values, I want to see what areas I need to consider.
I mean, I wasn't financially invested, he was, but I was mentally invested on behalf of my friend.
I have to confess that I had to search for the answer, and what I discovered was that there are two methods, both with their own merits.
Select the cell for which you want to see Dependence, and then hold down Control and the right bracket, and all dependents of that cell on the same sheet will be selected.
Using this method, you could then tap the paint bucket icon in the Home tab to set them, say, all to yellow, making them easier to find as you work on the spreadsheet.
If you want to see the precedence, meaning all cells on which the selected cell is dependent, you use Control-Left Bracket.
Now, this is quite useful, but it won't actually solve Alistair's problem because it only finds dependence and precedence on the same sheet as the selected cell.
It's also quite clever and not like anything I've ever seen in Excel before.
You should see a section with three commands, trace precedence, trace dependence, and remove arrows with a downward chevron.
As always with Microsoft Office, remember that if your window is too narrow, you may not see all of these options.
Now, let's talk about what happens if we select a cell and we choose Trace Dependence from the ribbon.
The rest of this transcript — segmented and speaker-labeled, so you land on the exact moment something was said
Search every transcript — by keyword, by phrase, or by meaning, across every show Radar indexes
Trends — what is surging across podcasts, measured against its own baseline
Alerts — when a name you follow appears in a newly indexed episode
No account is needed to search Radar.