When You Insert Rows in a List of Values That

Essay

When you insert rows in a list of values that are being calculated, such as with a total, Excel most often includes the newly inserted values and recalculates the formulas affected. Depending on what values are in the list and how they are formatted, however, this might not always work as anticipated.
If you think additional rows will be needed, describe two ways to avoid potential problems.