如何将电子表格分割成多个具有设置行数的电子表格?

I have an Excel (2007) spreadsheet with 433 rows (plus the header row at the top). I need to split this up into 43 individual spreadsheet files with 10 rows each and one with the remaining 3 rows. It would be preferable to have the header row at the top of each spreadsheet as well. How can I accomplish this? FYI, I am a bit of a newbie when it comes to "higher level" Excel functions like this.I have an Excel (2007) spreadsheet with 433 row