{"id":36401,"date":"2026-07-30T06:46:21","date_gmt":"2026-07-30T13:46:21","guid":{"rendered":"https:\/\/www.podfeet.com\/blog\/?p=36401"},"modified":"2026-07-30T06:46:21","modified_gmt":"2026-07-30T13:46:21","slug":"excel-find-dependencies","status":"publish","type":"post","link":"https:\/\/www.podfeet.com\/blog\/2026\/07\/excel-find-dependencies\/","title":{"rendered":"Tiny Excel Tip \u2014 Find Dependencies"},"content":{"rendered":"

Early one evening, Allister Jenks sent me a fun Excel question. Unfortunately, that was 10 PM the day before for me, as he\u2019s in New Zealand. I was so intrigued by the question that I told him I\u2019d work on it tomorrow. And as no surprise to anyone, it was the first thing I thought of when I woke up the next day.<\/p>\n

Allister asked:<\/p>\n

\n Do you know if there is a way in Excel (for Mac) to find out everywhere a cell is referenced?\n<\/p><\/blockquote>\n

You know what I asked him before looking into this, right? “What problem are you trying to solve?” He answered with:<\/p>\n

\n 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). It\u2019s all finely balanced and results in real money going places, so before I change one of the values, I want to see what areas I need to consider. I could just look to see what changes but it would be easy to miss things.\n<\/p><\/blockquote>\n

Now I was invested in the solution. I mean, not financially<\/em> invested, but mentally invested on behalf of my friend.<\/p>\n

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.<\/p>\n

Keystrokes to Find Dependents and Precedents<\/h2>\n

The first method is a hidden keystroke, not shown in any of the menus. Select the cell for which you want to see dependents, and then hold down \u2303-] and all dependent cells 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 all to yellow, making them easier to find as you work on the spreadsheet.<\/p>\n

\"Keystroke
\u2325-] Finds Dependents<\/br>(Red Arrows added by Me)<\/figcaption><\/figure>\n

If you want to find the precedents, meaning all cells on which the selected cell is dependent, you would use \u2303-[.<\/p>\n

\"Keystroke
\u2325-[ Finds Dependents<\/br>(Red Arrows added by Me)<\/figcaption><\/figure>\n

This is quite useful, but it won\u2019t actually solve Allister\u2019s problem, because it only finds dependents and precedents on the same sheet as the selected cell.<\/p>\n

Trace Dependents and Precedents from the Menus<\/h2>\n

The second option is a more effective solution to Allister\u2019s problem. It\u2019s also quite clever and not like anything I\u2019ve seen in Excel before. If you select the cell you want to trace, switch to the Formulas tab; you should see a section with three commands: Trace Precedents, Trace Dependents, 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 the options.<\/p>\n

Now let\u2019s talk about what happens if we select a cell and choose Trace Dependents from the ribbon. Excel draws arrows<\/em> from the selected cell towards the dependent cells!<\/p>\n

\"Trace
Excel Added These Arrows<\/figcaption><\/figure>\n

That\u2019s great for the cells on the current sheet, but it also puts an arrow indicating any dependents that exist on other sheets. If you click on the arrow indicating other sheets, you get a little pop-up window that says \u201cGo to:\u201d and then lists all of the dependent cells. Click on any one of them, and their sheet will open with the cell selected.<\/p>\n

\"Go
Select Cell Reference to Open In Sheet<\/figcaption><\/figure>\n

The arrows you apply stay on the screen while you\u2019re working, but disappear when you save. As with the keystroke, I would suggest color coding the dependents so they\u2019re easier to spot if you have to come back to the spreadsheet.<\/p>\n

Excel also has a command in the same section of the ribbon to Trace Precedents, which finds all cells on which your selected cell depends and indicates those with arrows.<\/p>\n

All these arrows flying about can get confusing. You can manually remove the arrows in the same section of the ribbon using the Remove Arrows dropdown. From there, you can choose to remove dependent arrows, precedent arrows, or all arrows.<\/p>\n

If you don\u2019t favor the ribbon, all of these dependent\/precedent and arrow removal options are available from the menu bar for Excel in the Tools Menu under Auditing.<\/p>\n

Copilot<\/h2>\n

Or you can have all the fun of learning and exploration ruined by selecting a cell and asking Copilot, \u201c What cells depend on this cell?\u201d I tried it, and it got the right answers. The good news is that it took a lot longer than tapping the Trace Descendants button, and it didn\u2019t give me a handy \u201cGo to:\u201d dialog box to quickly navigate to the dependent cells.<\/p>\n

\"Copilot
Copilot \u2014 Slower and Less Helpful<\/figcaption><\/figure>\n

Bottom Line<\/h2>\n

The bottom line is that I really enjoyed the discovery of a new trick in Excel. I\u2019m sure I\u2019ve had this same problem to be solved, but it never occurred to me to see if Excel could do this automatically and in such an intuitive graphical way. So thanks for asking the question, Allister!<\/p>\n","protected":false},"excerpt":{"rendered":"

Early one evening, Allister Jenks sent me a fun Excel question. Unfortunately, that was 10 PM the day before for me, as he\u2019s in New Zealand. I was so intrigued by the question that I told him I\u2019d work on it tomorrow. And as no surprise to anyone, it was the first thing I thought […]<\/p>\n","protected":false},"author":1,"featured_media":36403,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[147],"tags":[1897,8366,8367,8368,8369],"class_list":["post-36401","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog-posts","tag-excel","tag-find-dependents","tag-find-precedents","tag-trace-dependents","tag-trace-precedents"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/www.podfeet.com\/blog\/wp-content\/uploads\/2026\/07\/Trace-dependents-shows-arrows-to-the-cells-even-on-different-sheets-1040x520-1.png","_links":{"self":[{"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/posts\/36401","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/comments?post=36401"}],"version-history":[{"count":1,"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/posts\/36401\/revisions"}],"predecessor-version":[{"id":36402,"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/posts\/36401\/revisions\/36402"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/media\/36403"}],"wp:attachment":[{"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/media?parent=36401"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/categories?post=36401"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/tags?post=36401"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}