Excel - Set the default number of sheets for your workbooks

April 2017


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


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 (ccm.net).