Microsoft Excel by default contains 3 worksheets while creating a new Workbook. For creating a new workbook you can specify the number of Worksheet that a Workbook needs to contain. This can be modified using Excel Options. Listed below are steps for increasing number of Worksheets for a new Workbook in Excel 2013, Excel 2010 and Excel 2007
In Excel 2013 and Excel 2010 –> Click on File menu and then Options.
In Excel 2007 –> Click on Excel Options and then Popular menu.
Under When creating new workbooks section there is include this many sheets fields. This can be used for increasing the number worksheets while creating a new workbook. The minimum value is 1 and the maximum is 255. Check out the below video demo to increase worksheets size in Excel 2013
[…] the default number of worksheets included in a new workbook is 3. We have already seen how to change the number of worksheets in Excel 2007. Similarly using Excel 2010 options the number of sheets can be increased on […]