Insert or Delete a Row or Column in Microsoft Excel

Follow by Email
Facebook
Facebook
Google+
http://www.exceltip.com/excel-keyboard-shortcuts/insert-or-delete-a-rowcolumn-in-microsoft-excel.html">
SHARE




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 [email protected]

 

 

Please follow and like us:
39


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

  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 *


one + = 7

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>