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.

 
img1
 

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

 
img2
 

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

 
img3
 

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

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

  • Click on File tab.

 

img5
 

  • Click on Options.

 
img6
 

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

 
img7
 

  • 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 *

*

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>