Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 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.

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
Unless your complex spreadsheet is using indirect cell referencing, when you insert the new column your existing formulas should automatically adjust. – Daniel Dec 13 '12 at 23:44

You must log in to answer this question.