Excel 2013 Trace Precedents On Another Sheet
Excel 2013 Trace Precedents On Another Sheet Pdf
On the Excel tab, go to the Formulas tab and locate the Trace Precedents tool under the Formula Auditing section. Next, click the Trace Precedents button and wait for Excel to audit the cells. If a blue arrow appears, it indicates that there are no errors on the current Excel worksheet. Click “Trace Precedents” again to continue auditing. What causes Excel to activate this behavior? I was working on an Excel spreadsheet that I had created a while back and wanted to use the Formula Auditing 'Trace Precedent' functionality. To my surprise it was grayed out. Everything else worked fine except that feature. Neither the workbook nor the worksheet were protected.
Excel 2013 Trace Precedents On Another Sheet In Excel
When I view this tutorial page, I found the following:
Use Trace Precedents Choose a formula and click Trace Precedents. It is on the Formulas ribbon in Excel 2007 and the Tools - Formula Auditing menu in Excel 97-2003. Excel will draw blue arrows to show all the cells that flow into this cell.
The icon in the lower left means there were some off-sheet precedents. Double-click the dotted line to see the off-sheet precedents.
I clicked the dotted like to see the off-sheet precedents, and find it doesn't lead me directly to the cell, what's wrong with it?
related link to full article Tracking Formulas in Microsoft Excel
Use Trace Precedents Choose a formula and click Trace Precedents. It is on the Formulas ribbon in Excel 2007 and the Tools - Formula Auditing menu in Excel 97-2003. Excel will draw blue arrows to show all the cells that flow into this cell.
The icon in the lower left means there were some off-sheet precedents. Double-click the dotted line to see the off-sheet precedents.
I clicked the dotted like to see the off-sheet precedents, and find it doesn't lead me directly to the cell, what's wrong with it?
related link to full article Tracking Formulas in Microsoft Excel