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




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

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

img3

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

Please follow and like us:
6


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>