Find links used in formulas. Press Ctrl+F to launch the Find and Replace dialog. In the Find what box, enter.xl. In the Within box, click Workbook. In the Look in box, click Formulas. In the list box that is displayed, look in the Formula column for formulas that contain.xl. In this case, Excel found multiple. Additional Excel tip to do this with NO macro: 1. Go to Options and switch OFF the “Edit directly in Cell” option — now, if you Double-Click on any cell, Excel will Select all the cells its formula refers to (ie, a fast shortcut way to Trace Precedents when trying to work out someone else’s spreadsheet’s logic). Show All Precedents. Excel natively traces precedents only for the active cell in a selection of multiple cells. In other words, Excel only shows you trace arrows for one cell at a time. Macabacus, on the other hand, shows precedent trace arrows for all selected cells at once.
How To Trace Dependents On Another Sheet In 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
