Wednesday, November 21, 2012

Trace Dependents before you delete a cell in Excel

A new version of this post has been published here:

Before you delete a cell, you should check if there are other cells that are affected by it.

Select the cell, go to the Formulas ribbon and click on Trace Dependents. The arrows show the dependent cells.

No comments:

Post a Comment