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.