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

Excel 2003: Deleting Rows, Columns & Cells

Excel 2003: Deleting Rows, Columns & Cells

Deleting rows, columns and cells is just as easy as inserting them. In fact, all you need to do is select the row, columns or individuals cells you want to remove and then choose Delete. If you select a row or column, all data in the selected row or column will be deleted and the data to right of a deleted column will shift left while the data below a deleted row will shift up.

Deleting a Column Using the Menu Bar

     
  1. Select the column(s) to be deleted
     
  2.  
  3. Choose Format: Delete from the Menu bar
     

Deleting a Column Using the Shortcut Menu

     
  1. Select the column(s) that to be deleted
     
  2.  
  3. Right-click the selected column heading (letter)
     
  4.  
  5. Choose Delete from the shortcut menu
     

Deleting a Row Using the Menu Bar

     
  1. Select the row(s) to be deleted
     
  2.  
  3. Choose Format: Delete from the Menu bar
     

Deleting a Row Using the Shortcut Menu

     
  1. Select the row(s) to be deleted
     
  2.  
  3. Right-click the selected row heading (number)
     
  4.  
  5. Choose Delete from the shortcut menu
     

Deleting a Cell Using the Shortcut Menu

     
  1. Select the cell(s) to be deleted
     
  2.  
  3. Right-click the selected cells
     
  4.  
  5. Choose Delete from the shortcut menu
     
  6.  
  7. In the Delete Cells Dialog Box, choose your option
     
  8.  
  9. Click OK
     

In addition to being able to delete entire rows, columns and cells, you can also choose to simply “erase” the data contained on the worksheet by using the Clear Contents option.