By default, whenever you create a new blank Excel workbook, Excel automatically includes one blank worksheet. In previous versions of Excel, three blank worksheets was the default. You can however, change the default to as many as you like (up to 255) from the General tab of the Excel options window.
To Change the Number of Default Worksheets
- Click the File tab on the Ribbon.
- Click Options.
- Click General in the left pane.
- Under the When Creating New Workbooks section, enter in the desired number of sheets in the Include This Many Sheets: box.
- Click OK.
Share this post