Changing the Default Number of Sheets in a New Workbook in Microsoft Excel

When we open new Excel workbook has only one sheet by default. In this article we will learn about 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.