1-866-245-5224 sales@keystonelearning.com

Excel 2007: Insert & Delete Worksheets

Excel 2007: Insert & Delete Worksheets

As you already know, most new workbooks open with three worksheets. This just seems to be the Excel standard. And, while you can change the number of worksheets that open with the new template, it’s often easier to just delete worksheets you no longer need or add additional worksheets whenever needed.

Remember, you can insert over 250 worksheets stored in any one workbook. So, having the ability to insert and delete those worksheets as needed is extremely beneficial.

Inserting Worksheets Using the Ribbon

     
  1.  Click the Insert command in the Cells group on the Home tab
     
  2.  
  3. Choose Insert Sheet
      The new sheet is inserted in front of the active sheet named with the next consecutive sheet number
     

Inserting Worksheets Using the Shortcut Menu

     
  1. Right-click any sheet tab
     
  2.  
  3. Choose Insert…
     

Figure 3. Insert Sheet Dialog Box

    3.       Select Worksheet

    4.       Click OK
The new sheet is inserted in front of the active sheet named with the next consecutive sheet number



Deleting Worksheets Using the Ribbon

     
  1. Click the Delete command in the Cells group on the Home tab
     
  2.  
  3.  Choose Delete Sheet
      The new sheet is inserted in front of the active sheet named with the next consecutive sheet number
     

Deleting Worksheets Using the Shortcut Menu

     
  1. Right-click any sheet tab
     
  2.  
  3. Choose Delete