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

When we open new Excel workbook has only one sheet by default. In this article we will learn about how we can change the default number of sheets in a new workbook in Microsoft Excel.

To change the default number of the sheets in a new workbook follow below given steps:-

  • Go to the File tab.



image 1


image 2

  • Click on the options.
  • Excel options dialog box will appear.
  • In the General option.


image 3

  • In the group of when creating new workbook increase the sheet number in the option of Include this many sheets.

image 4



  • Click on OK.
  • When you will open new workbook increased worksheet will appear in new workbook.

image 5


This is the way we can change the default Number of the sheet in a new workbook in Microsoft Excel.

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>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube