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.

 

image 1

 

Insert  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.

Delete entire row in data

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

image 2

 

  • The Excel delete row shortcut is 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.

 
image 48

 

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

 

 

Comments

  1. 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.

  2. Government Jobs in Maharashtra

    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

  3. 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.

    • 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

  4. 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? 

Leave a Reply

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

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.