Trace Precedents tool for multiple functions

lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,805
Office Version
  1. 2016
Platform
  1. Windows
Hi
I have multiple functions in a sheet. I want to use Trace Precedents (the arrows tool) for all functions in the sheet. Now it only show arrows for only one cell (the selected) one which has the function. How can I make that tool show all the arrows for other functions as well, or that is not possible? Thank you very much.
 

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

Eric W

MrExcel MVP
Joined
Aug 18, 2015
Messages
11,867
You could run a macro to do it:

VBA Code:
Sub Macro1()
Dim c As Range

    For Each c In ActiveSheet.UsedRange
        If c.Formula <> "" Then c.ShowPrecedents
    Next c
End Sub
 
Solution

lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,805
Office Version
  1. 2016
Platform
  1. Windows
It works amazing. Thank you so much.
 

Rick Rothstein

MrExcel MVP
Joined
Apr 18, 2011
Messages
37,659
Office Version
  1. 2019
  2. 2010
Platform
  1. Windows
You could also do it this way which only iterates the cells containing formulas directly as opposed to examining every cell in the UsedRange and testing them individually to see if they have a formula or not...
VBA Code:
Sub ShowAllPrecedentArrows()
  Dim Cell As Range
  For Each Cell In Cells.SpecialCells(xlFormulas)
    Cell.ShowPrecedents
  Next
End Sub
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,579
Messages
5,770,962
Members
425,653
Latest member
UNSING

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top