In this article, we will learn how we can change the default number of sheets in a new workbook in Microsoft Excel.
To change the default number of the sheets in a new workbook, follow below given steps:-
- Go to the File tab.
- Click on the options.
- Excel options dialog box will appear.
- In the General option.
- In the group of when creating new workbook increase the sheet number in the option of Include this many sheets.
- Click on OK.
- When you will open new workbook, increased worksheet will appear in new workbook.
This is the way we can change the default Number of the sheet in a new workbook in Microsoft Excel.
Or If we do not want to insert in the all new workbook so we can simply insert the worksheet by just clicking on the + symbol.