Charity Worker in Africa wrote:
I have a table which has a column that uses a formula. When I insert a new
row in the middle of the table, Excel inserts a blank cell into the column
with formulas, rather than keeping the formula that applies to the adjacent
rows.

How do I insert a row and keep the column with a formula so it applies to
that new row?

-----------------------

There may be a better way, but what I do is "copy" an existing row, then "insert
copied cells" where I want the new row. At that point you can put your new data
over top of the old and the formula columns all work properly.

Bill