» Changing the Default Number of Sheets in a New Workbook in Excel 2007
Excel can hold an unlimited number of sheets in a workbook.
To change the default number of sheets in a new workbook:
1. Select File -> Excel Options -> Personalize.
2. Set the number of Sheets in When creating new workbook section in Include this many sheets and click OK.