Hi
Just select were you want the row to go, go to insert, then to have the option up or below, (choose) and then insert, this well automatically sort out the sums. also there is a couple of other option using the format painter this option copies what ever is in that cell, i.e font, size...