Auto enter formulas
 

Hi Groupies:

In Excel 2003 I have a list of data with formulas in column G.
If I insert a new row between 2 rows that already have formulas, is there a
way for Excel to automatically enter the formula in the new row, or is this
only possible if the data is set up as a list?
--
Thanks for the brainwaves!

CJ
I blame the parents........

Auto enter formulas
 

Not sure if it would be better or worse, but you coudl always copy one of the
existing rows and insert copied cells insetad of inserting a blank row.

Other than that, pretty sure Excel will truly enter a blank row, so you'd
have to copy and paste...

"CJ" wrote:

Hi Groupies:

In Excel 2003 I have a list of data with formulas in column G.
If I insert a new row between 2 rows that already have formulas, is there a
way for Excel to automatically enter the formula in the new row, or is this
only possible if the data is set up as a list?
--
Thanks for the brainwaves!

CJ
I blame the parents........

Auto enter formulas
 

Excel does not copy the formula to the cell in the inserted row.

You need to enter the fourmula in the new cell either manually or through a
macro...

If you do it often then you may record a macro while you perform the actions
once and then run that macro anytime you need it.
"CJ" wrote:

Hi Groupies:

In Excel 2003 I have a list of data with formulas in column G.
If I insert a new row between 2 rows that already have formulas, is there a
way for Excel to automatically enter the formula in the new row, or is this
only possible if the data is set up as a list?
--
Thanks for the brainwaves!

CJ
I blame the parents........

Auto enter formulas
 

Thanks to both of you. You have confirmed what I thought.

--
Thanks for the brainwaves!

CJ
I blame the parents........


"Sheeloo" wrote:

Excel does not copy the formula to the cell in the inserted row.

You need to enter the fourmula in the new cell either manually or through a
macro...

If you do it often then you may record a macro while you perform the actions
once and then run that macro anytime you need it.
"CJ" wrote:

Hi Groupies:

In Excel 2003 I have a list of data with formulas in column G.
If I insert a new row between 2 rows that already have formulas, is there a
way for Excel to automatically enter the formula in the new row, or is this
only possible if the data is set up as a list?
--
Thanks for the brainwaves!

CJ
I blame the parents........