How to insert a column in Excel without messing up formulas

You can use function offset.

See excel help for better uderstanding

Fill this to A1 and drag down.

=OFFSET(A1;0;2)+OFFSET(A1;0;4)+OFFSET(A1;0;6)-OFFSET(A1;0;3)-OFFSET(A1;0;5)-OFFSET(A1;0;7)

Update

Sorry, I have non-English version of the Excel where ; are as separation character in formulas.

In English Excel is it probably with ,

=OFFSET(A1,0,2)+OFFSET(A1,0,4)+OFFSET(A1,0,6)-OFFSET(A1,0,3)-OFFSET(A1,0,5)-OFFSET(A1,0,7)

Greetings! I look forward to getting to know you all more on this board! It already looks like there's a ton of great answers! Here's mine: I was wondering if there is a way to insert rows or columns without messing up my formulas. Obviously the formulas I have all rely upon Column locations.. For instance I have a number of formulas working with column "E" ... But I need to add a column before E; is there any way to do that and have all the formulas automatically update?

Thanks!

Square and cube roots

Click here to reveal answer

The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).