Insert or Delete a Row or Column in Microsoft Excel 2010





In this article, we will learn how we can insert and delete a Row/Column in Microsoft Excel 2010 and 2013.

Let’s take an example to understand how to insert or delete a Row/Column.

We have data in range A1: C15. Column A contains Agent name, column B contains city, column C contains sales amount, and we need to return the total value in cell C16.
 
img1
 
Insert and Delete row in data

Follow below given steps:-

  • We want to insert the row in between 3rd and 4th row.
  • Select the 4th row and press the key Ctrl+ on your keyboard.

 
img2
 

  • Row will get inserted in between 3rd and 4th row.
  • To delete the 4th row, select the 4th row.

 
img3
 

  • And press Ctrl+- (Ctrl with minus) key on your keyboard.

 
img4
 

  • Row will get deleted from the data.

Insert and Delete Column in data

Follow below given steps:-

  • We want to insert a Column in between B and C column.
  • Select the column C and press the key Ctrl+ on your keyboard.

 
img5
 

  • Column will get inserted in between B and C column.

 
img6
 

  • To delete the C column, select the Column C.

 
img7
 

  • And press Ctrl+- (Ctrl with minus) key on your keyboard.
  • Column will get deleted from the data.

 
img8
 

This is the way we can insert and delete a row/column in Microsoft Excel.
 
 



4 thoughts on “Insert or Delete a Row or Column in Microsoft Excel 2010

  1. when we press ctrl+ and ctrl- to insert and delete the rows it show the delete and insert dialog box is it possible that we can delete or insert directly? 

  2. Play on the keboard: Select cell, press Ctrl+Spacebar and then Ctrl+ or Ctrl- to add/delete a column. Or Select cell, press Shift+Spacebar and then Ctrl+ or Ctrl- to add/delete a row.

Leave a Reply

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


three + 3 =

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>