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