Excel - Set the default number of sheets for your workbooks

By default Excel already includes3 sheets in your new workbooks (sheet1, sheet2...).

You can configure Excel to display a custom number of sheets, via the below manipulation:
  • Click on File > Options > General
  • In the "When creating new workbooks" section, increase the value next to "Include this many sheets:"
  • Click on OK to validate.
Published by jak58. Latest update on August 8, 2012 at 09:16 AM by jak58.
This document, titled "Excel - Set the default number of sheets for your workbooks," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (https://ccm.net/).
VBA - A macro to create multi-sheet pivot tables
Excel - Copy data into next empty cell in new sheet