How to increase the default number of sheets in Excel

The default number of sheets for a new workbook is set to 1 in Excel 2016, Excel 2013 and Excel 2010. But Users are allowed to change the default sheet number using the Excel options.


Step 1: Launch Microsoft Excel 2013 and open a workbook.

Step 2: Click File menu and select options from the menu list.


Step 3: In the Excel Options, click the General settings and navigate to When creating new workbooks section.


Step 4: Now using the Include this many sheets option you can increase or decrease the number of sheets included while creating a new workbook.


Step 5: Click Ok button to confirm and save the changes.

In Category: Excel 2010, Excel 2013, Excel 2016, MS Office

Ravi Shankar

A Software developer and blogger who is always looking to provide technical help to the wider community.

Show 0 Comments
No comments yet. Be the first.

Leave a Comment

Get your free copies of the following tech guides by joining the Digital Answers mailing list.