Changing the Default Number of Sheets in a New Workbook in Excel 2010

 

In this article, we will learn how to change the default number of sheets.

Excel can hold an unlimited numbers of sheets.

To change the default number of sheets in a new workbook, follow the below mentioned steps:

  • Click on File ribbon
  • Select Excel Options
  • Select General menu
  • Set the number of Sheets in “When creating new workbooks” section in “Include this many sheets”.

 
img1
 

  • Click OK.
  • 1 is the default number of sheet which will be available for use in excel.

Next time when you click on New Workbook, you will find the number of sheets that you have set.
 
 



One thought on “Changing the Default Number of Sheets in a New Workbook in Excel 2010

  1. The greater scheme like this one I nave never see, so this one shows us to do everything under a great control, as everthing demads the control, control helps us to get rid of the mistakes.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>