Excel 2008 : Automatically add new row

I am using excel 2008 Mac version. I have created a sales report with column headers at the top and totals at the bottom with data in the middle. Right now I am having to use the insert row function, then drag and drop the formulas down the columns whenever I get the data section rows all filled. Is there away to automatically add a new row with the same formula and formating from the row above after hitting the return key or tab key?

Thanks,
Farris

You could make a macro that puts the formatting in on a worksheet change, or if you use a Excel Data Table format on your data, it may be done automatically for you.