Excel – Using Formula Auditing to Determine What Cells are Used in Formulas (Excel 2007 & Excel 2010)

Excel – Using Formula Auditing to Determine What Cells are Used in Formulas (Excel 2007 & Excel 2010)

There are times you may need to know if a cell is part of a formula.  If you are altering or deleting cells, you can easily cause errors throughout your worksheet.  Using "Formula Auditing" you can easily determine if a cell is part of a formula. The technical terms for this are "Trace Dependants" and "Trace Precedents".

This post is only available to members.
Related Posts

How to Change Time Increments in Outlook Calendar

You can change the time increments shown in your Outlook calendar to allow for smaller more detailed calendar entries.  This will work in Outlook 2003, Outlook 2007, and Outlook 2010.

This post is only available to members.
Back To Top