Adding rows to a spreadsheet

Hi,

I have quite a weighty spreadsheet containing 10,000 rows/100 columns of data in Excel 2007. Most of the columns contain 'formulas' and 'Sum' totals that are referenced in other worksheets.

When setting up the spreadsheet I thought 10,000 rows would be fine but alas it's nearly full.

I know I can add rows one at a time via the menu that will maintain the integrity of all the cell references but is there a simple way to add say another 10,000 rows to the spreadsheet whilst maintaining that integrity?

Thanks