MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Insert Row - Weird behavior?


Posted by Paul Hermans on November 21, 2001 11:32 AM

I have a simple spreadsheet with several rows of data in it.
For argument sake, say column A has numbers in it and Column B has a formula that looks like this:
=if(a1>1,"big","small")
and Column C has a formula that looks like this:
=a1

If I insert a row in the middle of a table, and then enter a number in column A suddenly the formula for column B appears but not the formula for column c.

My question is, WHY does the IF satement suddenly show up? After inserting the row, I checked to see if the formula was in the cell already, it wasn't....so I'm very confused.

I am using Office 2000 on Windows 2000.

Any ideas would be greatly appreciated.


Posted by Richard S on November 21, 2001 1:23 PM

I've noticed the same thing in Excel 2000. I think it is trying to be "intuitive" and guess what you are trying to do. I have had instances where it puts formulae in by itself, but not everything. Not sure what the rules for this "autocomplete" are. Not much help, sorry.

Richard

Posted by Ivan F Moala on November 21, 2001 7:05 PM

Have a look @
Tools | Options | Edit

you will see a check box named;
extend list formulas & formats.
Right click on this for a discription.
It should tell you why this happens.


Ivan