View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default 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........