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.

image

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

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

image

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

image

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.

image

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



Meet the Author

Ravi Shankar

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

0 comments… add one

Leave a Comment

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