Tip Printed from ExcelTip.com

---

Changing the Default Number of Sheets in a New Workbook


Excel can hold an unlimited numbers of sheets.

To change the default number of sheets in a new workbook:

1. From the Tools menu, select Options, and then select the General tab.
2. In the Sheets in new workbook box, enter a new default number (up to 255 sheets).
3. Click OK.