automate the copying of formulas and cell formatting

when you copy a cell that shows the autosum, you are actually copying the formula, NOT the sum. so you can copy the cell which has your sum, and then paste it into all the cells you want to add. Hope that helps

Another simple way if this is an uncommon occurrence is to highlight the entire new row and hit Ctrl+D. It copies everything from the row above. It will copy raw data, too, but if you're just entering a new record from scratch and overwriting every line, that won't matter. If entering new lines happens often, though, teylyn's suggestion is better.

To Teylyn. Thanks for the table suggestion, but am not used to work with them, and they seem complicated and create a whole lot of new problems. Maybe someday I can learn tables, but not now. (Am using 2007 but saving in 2003). Using tables appears more difficult to me than manually copying the formulas.

To Darkyam. The Ctrl D works beautifully, but only for one row. If you select a block of rows, nothing happens with Ctrl D. Is there any way at all to make it work with several rows at once, since I always extend data ranges by at least 10 rows when new space is required.

When doing that for multiple rows, you have to grab the row you're copying as the first row. So if you insert 10 rows under row 4, you have to grab rows 4:15 and hit Ctrl+D.

Yipee, it works perfectly. Thank you very much.