Excel - Set the default number of sheets for your workbooks

December 2016


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.

Related :

This document entitled « Excel - Set the default number of sheets for your workbooks » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.