Why formula doesn't change on column insertion?

  • Thread starter Thread starter Fred Boer
  • Start date Start date
F

Fred Boer

Hello:

I know I will feel stupid when I hear the answer, but...

If I have a formula ( =average(a1:a5) ), and I insert a new column, the
formula, being relative, changes to ( =average(a1:a6) ). This works fine
in a test. BUT I have a working spreadsheet in which inserting a column does
*not* change the relative formula. Why? I can't see anything different in my
working spreadsheet...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average Question 2
Formula Query 9
Not so simpel copying of a simple formula 5
Horserace Form Revisited 2
Amending a Formula 5
Formula using current row 4
why won't text-to-columns work here? 6
Inserting rows into sheet that contains a formula 2

Back
Top