why not? good question.....
it looks like they wanted to accomodate this in
tools<options<edit<extend data range format and formulas
but this did not work in my 2003 version.

a useful work around is

keep one line with the formula's only ............no other data.
copy that line.
go to where you want to insert
right click and select "insert copied cells"


--
bill k


------------------------------------------------------------------------
bill k's Profile: http://www.excelforum.com/member.php...nfo&userid=821
View this thread: http://www.excelforum.com/showthread...hreadid=483209