Insert or Delete a Row or Column in Microsoft Excel

While working in Excel we have to take so many actions and activities in which insertion and deletion is most commonly used. In this article, we will learn how we can insert and delete a Row/Column in Microsoft Excel by using the shortcut key.

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.

Insert row in data

Follow below given steps:-

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

Row will get inserted in between 3^rd and 4^th row.

Delete entire row in data

To delete the 4^th row, select the 4^th row.

The Excel delete row shortcut is press Ctrl+- (Ctrl with minus) key on your keyboard.

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.

Column will get inserted in between B and C column.

To delete the C column, select the Column C.

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

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

If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com

Rameez
January 14, 2016 at 8:58 am

You can select the whole column by pressing Ctrl+Space bar and whole row by pressing Shift+Space bar, then press Ctrl+- for delete and Ctrl++ for insert.

Reply ↓
Unknown
December 3, 2015 at 7:16 am

Nice article, Thank you for sharing.A very useful website specially for learner, weldone

Reply ↓
Government Jobs in Maharashtra
November 30, 2015 at 5:41 am

I would like to thank you for the efforts you have put in penning this site. I’m hoping to view the same high-grade content by you later on as well. In fact, your creative writing abilities has inspired me to get my own site now

Reply ↓
Giri Patel
November 19, 2015 at 10:46 am

Highlight the whole row by clicking on the row label and that will eliminate the need for the inserting dialogue box

Reply ↓
Preeti
June 25, 2015 at 10:55 am

Thanks for Sharing Nice Information ..

Reply ↓
JROVH
May 11, 2015 at 12:13 am

THANKS FOR REMIND.

Reply ↓
arif ansari
August 6, 2014 at 8:49 am

Thanks for sharing it's really helpful for me.

Reply ↓
Mike
August 23, 2013 at 11:38 am

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.

Reply ↓
Mike
August 23, 2013 at 11:38 am

Highlight the whole row by clicking on the row label and that will eliminate the need for the insert/delete dialogue box

Reply ↓
- scott
  May 10, 2016 at 6:53 pm
  
  also you can use Ctrl + Spacebar to select the current column, or Shift + Spacebar to select the current row, then use the Ctrl + +/- to insert or delete.
  
  You can select multiple columns or rows if you have a selection that spans multiple columns or rows
  
  hope that was clear enough
  
  Reply ↓
Mike
August 23, 2013 at 11:37 am

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?

Reply ↓