I have the same problem (with Excel 2007). My worksheet has two columns with
formulae, several others without. When I insert rows, even in between
existing rows, the formulae do not copy (the resulting cells are empty). I
have checked my Excel options and can't find anything that would cause this
behavior. (Used to be so easy...in older versions)!

Can anyone help?
--
Joaneee


"David Biddulph" wrote:

You say that the formulae don't copy. What is in the cells where the
formulae should be?
--
David Biddulph

"FlashGordon64" wrote in message
...
I just re-installed Excel and the defaults that I am used to are not
active.
Now when I copy a column that has formulas in it the formulas don't copy.
Any suggestions?