Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have completed a very complex Excel spreadsheet with a lot of equations, except I forgot to include September.

I have January through December, all the months, except the calculations for September. Of course all the equations are currently perfect for the data that's here.

How do I add a whole new column without ruining the previous equations?

share|improve this question

migrated from dba.stackexchange.com Dec 13 '12 at 23:01

This question came from our site for database professionals who wish to improve their database skills and learn from others in the community.

3  
Otherwise, simply insert a whole new column, it won't ruin your equations. Have you tried this yet? –  dezso Dec 13 '12 at 22:58
2  
Unless your complex spreadsheet is using indirect cell referencing, when you insert the new column your existing formulas should automatically adjust. –  Daniel Cook Dec 13 '12 at 23:44
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.