How to insert or delete a row or column in excel

In Microsoft Excel Insert or Delete is a function that can use inserts/delete row or column in a worksheet. Also, we can add a sheet by using these tab options.

When you click the Insert button, Excel displays the Insert Function dialog box. You can use its options to insert cells/rows or sheet

To insert new cells, rows, or columns in Excel worksheet, follow these steps:

Select the cells, rows, or columns where you want to add the new, blank cells.

Click on Insert button the drop-down arrow in the Cells group of the Home tab.

Click Insert Cells on the drop-down menu and choose the option required for your work.

OR

Shortkey to insert a row to quickly insert a row in Excel, select a row and use the shortcut CTRL SHIFT  +

how to insert a row in excel 

insert a row in excel

Another useful option in insert function is you can change row/column up or down and left or right without change the whole data.

insert shift cell down

To delete the cell, row, or column in Excel worksheet follow these steps:

Select the cells, rows, or columns you want to delete.

Click on Delete button the drop-down arrow in the Cells group of the Home tab.

Click Delete Cells on the drop-down menu and choose option required for your work.

OR

Short key to delete row to quickly delete a row in Excel, select a row and use the shortcut (control+minious) CTRL  -. 

how to delete row