Peri, you may want to explore Lists in Excel 2003 (tables in 2007)

When you define a data block as a list, Excel will apply all formatting and formulas to new rows. Place your cursor in the table, then go Data - Lists - Create List.

Have a read in the Help files.

cheers