How to change the number of sheets for new workbooks
For example, if you prefer to start each new workbook with a single worksheet. After all, it's easy enough to add new sheets if and when they are needed.
To change the default number of worksheets:
1. Click the Microsoft Office Button , and then click Excel Options.
2. On the Popular tab, in the When creating new workbooks group, change the value for the Include this many sheets:
3. Click OK.
Note: Making this change will affect all new workbooks but will have no effect on existing workbooks.