Insert Row -- but formulas not placed into new cells

[jase]

Dang, this shouldn't be an issue in Excel

Let's say I have a spreadsheet that from cells a1 to a3 looks to see if the cell beside it is blank.

A1 =ISBLANK(B1)
A2 =ISBLANK(B2)
A3 =ISBLANK(B3)

Now, if I insert a new row between A2 and A3 -- you'd think that the resultant new cells would have the formula in them -- but they don't. The new row of cells, even though inserted between cells with formula, do NOT contain any formula. Excel DOES of course make the adjustment to what used to be A3 (and is now A4), such that it reads =ISBLANK(B4).

IOW, the outcome looks like this:

A1 =ISBLANK(B1)
A2 =ISBLANK(B2)

A4 =ISBLANK(B4)

This is particularly frustrating when you have a very wide spreadsheet that has column after column of formula -- I think that when I add a new row, it should not only insert the new row, push the others down, adjust the cells that were pushed down to keep their formula references accurate -- BUT IT SHOULD ALSO BE SMART ENOUGH TO PUT THE FORMULA IN THE NEWLY CREATED ROW OF CELLS.

Or maybe I'm the idiot :-/
Who knows.

As it stands now, when I insert a new row, I have to go highlight the row above it, all the way across my very wide spreadsheet, and then drag the highlighted cells down a notch so as to copy their formula to the new row of cells.

Anyway, anyone else find this exasperating? Is there any way around this?

Jase.

 

[Aladin Akyurek]

If you are on Excel 2003, convert A1:B3 into a list by means of Data|List|Create List. The list functionality will take care of formula copying that you need when you insert a row in between or add a new record at the end.

 

[jase]

If you are on Excel 2003, convert A1:B3 into a list by means of Data|List|Create List. The list functionality will take care of formula copying that you need when you insert a row in between or add a new record at the end.

I am on 2003. I have never heard of this, I'll check it out -- thanks!