How to show trace dependents or precedents arrow in Excel?
In some cases, if there are many formulas in your sheet, you may want to clearly see the relationships among the cells in Excel. To show the trace dependents or precedents arrow will be a good way.
It is easy to show the trace arrows in Excel.
There are two trace arrow types, one is Trace Precedents arrow, and the other is Trace Dependents arrow.
To show Trace Precedents arrow:
Select cell you need and click Formulas > Trace Precedents.
To show Trace Dependents arrow:
Select cell you need and click Formulas > Trace Dependents.
Tip: You can only add a trace arrow at each time.
With Excel built-in function, you only can show one type of trace arrows once time, but with Kutools for Excel's Monitor of Dependents and Precedents, you can show all precedents or dependents or booth precedents and dependents in a range once time.
After installing Kutools for Excel, please do as below:(Free Download Kutools for Excel Now!)
1. Click Kutools > More (in the Formula gourp), and then enable one operation you need in the sub menu, See screenshot:
2. Then select a cell or a range that you want to show the trace arrows, and now the type of trace arrow you select are shown in the selection.
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!