I would like to insert ten new rows in an Excel 2003 spreadsheet and have
Excel automatically copy the cell contents of the first row above the
insertion point. This will prevent the need to manually copy the first row
that has the data in the cells and paste this into the newly inserted ten
rows.

Does Excel offer this capability?