excel software training london - Linked spreadsheets - inserting columns

Hi Kate

Thanks for your question.

I think it depends which version of Excel you are using - if you are using 2003 then formula results should automatically update themselves when extra columns or rows are inserted.

If the formulas are not automatically updating themselves then I'm afraid you might have to manually adjust the formulas yourself each time new columns are added in.

Amanda