Excel 2010: Change Default Number Of Sheets In Workbook

By default, Excel 2010 include 3 worksheets in a workbook. If you need to work on more than 3 worksheets, you can change the number of sheets to be included in new workbook. This post covers how to change default number of included sheets.

To change the default number of sheet in Excel, On File menu, Click Options.

563d1274874046changedefaultnumbersheetsincludeworkbook Excel 2010: Change Default Number Of Sheets In WorkbookView in gallery

This will bring up Excel Options dialog, now under main window, enter the sheets number from Include this many sheets options.

562d1274874045changedefaultnumbersheetsincludeworkbook Excel 2010: Change Default Number Of Sheets In WorkbookView in gallery