Insert New Sheet in Microsoft Excel 2010

In this article, we will learn how we can insert new sheet in Microsoft Excel 2010.

By default, Excel provides three worksheets in a workbook, but we can increase it as per the requirement, and we can change the default settings as well.

Let’s take an example and understand how we can insert new sheet in Microsoft Excel.

  • Open a workbook.


  • Right click on tab with the mouse.
  • A Pop up will get appear.


  • From the list, click on insert.
  • Insert dialog box will appear.


  • To insert the worksheet, click on worksheet.
  • Click on OK.
  • Worksheet will get inserted with the name of Sheet4.

To change the default setting, follow below given steps:-

  • Click on File tab.



  • Click on Options.


  • Excel Options dialog box will appear.
  • Click on the General tab.


  • Increase the sheets till 4 in the option ‘Include this many sheets’.
  • Click on OK.

When you will open Excel workbook, by default 4 sheets will appear in Microsoft Excel.

Leave a Reply

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

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.