How To Use Ribbon Keyboard Shortcuts For Excel: An Example. To show Trace Dependents arrow: Select cell you need and click Formulas > Trace Dependents. To show Trace Precedents arrow: 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. Step 3: Continue Pressing The Key (s) That Corresponds To What You Want To Activate. It is easy to show the trace arrows in Excel. Step 2: Press The Key (s) That Corresponds To The Ribbon Section You Want To Go To. This video lesson is from our complete Excel tutorial, titled “ Mastering Excel Made Easy v.2019 and 365. Ribbon Keyboard Shortcuts for Excel: Key Tips. The following video lesson, titled “ Tracing Errors,” shows you how to use Trace Error in Excel. Then select the “Trace Error” command in the drop-down menu to draw arrows to the cells causing the error.Click the “Trace Error” drop-down button in the “Formula Auditing” button group on the “Formulas” tab in the Ribbon.To use Trace Error in Excel, select the formula cell with the error displayed in it.Trace Error in Excel – Instructions: A picture of formula auditing arrows shown in a worksheet after using the Trace Error tool in Excel. If the cell referencing turns out to be the reason why the formula will not function, you can then fix the cell references within the formula cell to correct the error.
Click the Trace Precedents or Trace Dependents button in the Formula Auditing group of the Formulas tab. Select the cell in which you want to check precedents and/or dependents.
Using the Trace Error tool in Excel shows you the cells referenced by a selected formula that contains an error message. Open your workbook to a sheet that contains cells with precedents or dependents. Invalid or inaccurate cell referencing is often a common cause of formula errors within Excel worksheets. Finally, select the “Trace Error” command in the drop-down menu to draw arrows to the cells causing the error. Then click the “Trace Error” drop-down button in the “Formula Auditing” button group. Then click the “Formulas” tab in the Ribbon. In the image below I have selected the J10 cell (which contains a formula. Then we select the Formulas tab and then from the area of the ribbon named Formula Auditing we select either Trace Precedents or Trace Dependents as we can see in the image below. To use Trace Error in Excel, first select the formula cell with the error displayed in it. First of all we must select the cell that we want to trace the Precedents or the Dependents. Note that the formula cell that you select must contain an error to use the Trace Error tool in Excel. The Trace Error tool is available when auditing a worksheet within a workbook. Trace Error in Excel lets you trace arrows back to cells referenced by a formula if it displays an error.