Microsoft Office Tutorials and References

In Depth Information

**Deleting cells, columns, and rows**

Fixing formula problems

In the following worksheet, notice that the formulas in row 16 have small triangular

indicators in the upper-left corner of each cell (they are green on your screen):

These triangles indicate an anomaly of some kind; in this case, we moved cells around

within the table, so the formulas no longer include the cells we moved. Notice in the

graphic that the formula bar displays the formula =SUM(B4:B47), omitting cells B8:B15.

We used the Insert Cut Cells technique described in this chapter to move the rows

containing January through August data from the top of the table to the bottom, which

created the problem. When you insert or move rows or columns at the edge of cell

ranges referred to by formulas, the formulas might not be able to adjust properly, as is

the case here. Excel offers help. As shown here, not only do the little lags appear, but

when you select one of the formula cells, a menu appears offering a Formula Omits

Adjacent Cells item containing pertinent options.

The Update Formula To Include Cells option works correctly in our example. This is a

much easier solution than editing each formula manually.