The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80% 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. Click Kutools > More (in the Formula gourp), and then enable one operation you need in the sub menu, See screenshot:Ģ. ![]() 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.Īfter installing Kutools for Excel, please do as below:( Free Download Kutools for Excel Now!)ġ. Tip: You can only add a trace arrow at each time. Select cell you need and click Formulas > Trace Dependents. Select cell you need and click Formulas > Trace Precedents. There are two trace arrow types, one is Trace Precedents arrow, and the other is Trace Dependents arrow. It is easy to show the trace arrows in Excel. Show all trace dependents (precedents) arrow with Kutools for Excel ![]() To show the trace dependents or precedents arrow will be a good way. In some cases, if there are many formulas in your sheet, you may want to clearly see the relationships among the cells in Excel. How to show trace dependents or precedents arrow in Excel?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |