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 Jan through Dec, 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?

PS: tomorrow is my holidays and I have to go to work to finish this table, so bad.

would really appreciate some kind expertise :)

share|improve this question

Assuming the following:

The equations are using the format (A1:D1) and not (A1,B1,C1,D1). You want the new data to be FACTORED INTO the equation.

The following will work: Right-click on the column letter above the October column. Click Insert. Type all your data in. Your equation column should reflect your new data.

Please tell me if my above assumptions were incorrect.

share|improve this answer
thank you very much dave im going to work in 4 hours its 2am im in valencia spain but once im at work ill try it. – Craig Gunn Dec 14 '12 at 0:46
no prob craig! tell me whether it works or not! – golddove Dec 14 '12 at 4:28

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .