Worksheets – Changing the Default Number of Sheets in a New Workbook

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

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

Leave a Reply