To copy cells down, use the keystrokes CTRL D (assuming you haven't redefined
CTRL D to some other function).

"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?