Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, 2016, 2019, and 2021. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Understanding Auditing.
Written by Allen Wyatt (last updated April 26, 2025)
This tip applies to Excel 2007, 2010, 2013, 2016, 2019, and 2021
Auditing is the process of analyzing the contents and formulas in a worksheet to make sure they are correct. Excel provides several tools that make auditing as painless as possible. Even so, auditing can be difficult and tedious work if your worksheet is large, complex, or poorly put together.
Excel uses some specific terminology that refers to the concepts involved in auditing, namely precedents and dependents. Precedents are those cells on which a formula is based. Thus, if cell A5 contains the formula =A3 + A4, then both A3 and A4 are precedents for cell A5. Dependents are the reverse of precedents. Thus, in this example, cell A5 is a dependent of cells A3 and A4.
You can further break down the distinction by having direct and indirect relationships. In the previous example, cell A5 is actually a direct dependent of (it directly depends on) cells A3 and A4. Likewise, A3 and A4 are direct precedents for cell A5. Suppose, however, that cell A6 contained the formula =A5 * 1.05. As you might imagine, cell A6 is a direct dependent of cell A5, but it is also an indirect dependent of cells A3 and A4. Similarly, A5 is a direct precedent of A6, and A3 and A4 are indirect precedents. It is possible to have many different levels of indirect precedents in a worksheet.
The tools that Excel provides to perform auditing tasks are available on the Formulas tab of the ribbon. (The tools are in the Formula Auditing group.)
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (8565) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, and 2021. You can find a version of this tip for the older menu interface of Excel here: Understanding Auditing.
Program Successfully in Excel! This guide will provide you with all the information you need to automate any task in Excel and save time and effort. Learn how to extend Excel's functionality with VBA to create solutions not possible with the standard features. Includes latest information for Excel 2024 and Microsoft 365. Check out Mastering Excel VBA Programming today!
When importing text into your worksheet, Excel defaults to using a comma as a delimiter. If you would prefer a different ...
Discover MoreOnce you've created your custom add-in, you need to know how you or other people can use it. Here are the simple steps to ...
Discover MoreCells that affect another cell are called precedent cells. If you need to know which cells affect a particular cell, ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2025-04-26 12:39:02
J. Woolley
For more on this subject, see https://excelribbon.tips.net/T008271_Accessing_Dependent_and_Precedent_Information.html
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2025 Sharon Parq Associates, Inc.
Please Note:
This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, 2016, 2019, and 2021. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here:
Comments