![]() ![]() To display a tracer arrow to each cell that directly provides data to the active cell, on the Formulas tab, in the Formula Auditing group, click Trace Precedents.ĭisk utility clone partition for mac.Select the cell that contains the formula for which you want to find precedent cells.Trace cells that provide data to a formula (precedents) To assist you in checking your formulas, you can use the Trace Precedents and Trace Dependents commands to graphically display, or trace the relationships between these cells and formulas with tracer arrows. For example, if cell D10 contains the formula =B5, cell D10 is a dependent of cell B5. Dependent cells - contain formulas that refer to other cells. For example, if cell D10 contains the formula =B5, cell B5 is a precedent to cell D10. Sometimes, checking formulas for accuracy or finding the source of an error can be difficult when the formula uses precedent or dependent cells: Precedent cells - are cells that are referred to by a formula in another cell. Double-click the dotted line to see the off-sheet precedents. The icon in the lower left means there were some off-sheet precedents. Excel will draw blue arrows to show all the cells that flow into this cell. It is on the Formulas ribbon in Excel 2007 and the Tools - Formula Auditing menu in Excel 97-2003.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |