Tip Printed from ExcelTip.com

---

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.