Articles → EXCEL → Insert And Delete Worksheets In Excel

Insert And Delete Worksheets In Excel






Software Requirement





Prerequisite Knowledge





Open A New Excel





Add Worksheet In Excel




  1. Method 1 –
    1. Select any worksheet
    2. Right click on any worksheet and click ‘Insert’
    3. Picture showing the Insert option for inserting the new worksheet

      Click to Enlarge

    4. A popup appers as shown in figure below
    5. Picture showing the popup window for selecting worksheet

      Click to Enlarge

    6. Select ‘Worksheet’
    7. Click ‘Ok’
  2. Method 2 –
    1. Select any worksheet
    2. Click on ‘Insert Sheet’ option of ‘Insert’ button
Picture showing the Insert sheet option for inserting the new worksheet

Click to Enlarge



Picture showing the new worksheet added in the workbook

Click to Enlarge


Delete Worksheet In Excel




  1. Method 1 –
    1. Select any worksheet
    2. Right click on any worksheet and click ‘Delete’
    3. Picture showing the Delete option for deleting the worksheet

      Click to Enlarge
  2. Method 2 –
    1. Select any worksheet
    2. Click on ‘Delete Sheet’ option of ‘Delete’ button
Picture showing the Delete sheet option for deleting the worksheet

Click to Enlarge



Picture showing the worksheet deleted from the workbook

Click to Enlarge


Posted By  -  Karan Gupta
 
Posted On  -  Friday, February 28, 2014

Query/Feedback


Your Email Id  
 
Subject 
 
Query/FeedbackCharacters remaining 250