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. Select Tools -> Options....
2. In the Options dialog box, click the General tab.
3. Change the value for the Sheets in New Workbook Setting and click OK.
Note: Making this change will affect all new workbooks but will have no effect on existing workbooks.