Let's say you want to insert a new column D. Then highlight the
existing column D by clicking on the letter at the top of the column,
and then click on Insert | Column. The other columns will move over to
the right to allow a new column D to be inserted. Any formulae on the
sheet will be adjusted automatically to take account of the fact that
some columns have moved.