Row Insertion
 

This is something minor, yet annoying. When I delete a row in 2007 Excel the
new row will have fill-ins from the row either above or below it. For
instance if I have a block of data that is colored in, the color will move to
the new row. I never had this problem in '03 Excel, has anyone else ran into
this? Any help will be appreciated, thanks.