Inserting and Deleting a Row or Column

   Overview   

You can add additional or remove rows or columns in an Excel spreadsheet.

   Instructions   

  1. Step 1: Click the row header.
  2. Step 2: Click the dropdown arrow.
  3. Step 3: Click the Insert Sheet Rows option.
  4. Step 4: A new row is inserted.
  5. Step 5: Select the column header.
  6. Step 6: Click the dropdown arrow.
  7. Step 7: Click the Insert Sheet Columns option.
  8. Step 8: A new column is inserted.
  9. Step 9: Click to select the appropriate row(s) or column(s).
  10. Step 10: Click the dropdown arrow to the right of the Delete button.
  11. Step 11: Click the Delete Sheet Rows link.
  12. Step 12: The selected row is deleted.
  13. Step 13: Click in the appropriate column header.  
  14. Step 14: Repeat the same steps.
  15. Step 15: Click the Delete Sheet Columns link.
  16. Step 16: The selected column is deleted.

In this article, you will learn the steps to insert and delete rows and columns in an Excel worksheet.

1. Step 1

step image

In a worksheet, click the row header where you want to insert a row.   

Example shown here: Click row header 17 .

2. Step 2

step image

The selected row is highlighted.

To insert a row at the selected location, click the dropdown arrow to the right of the Insert button on the Home tab.

3. Step 3

step image

Click the Insert Sheet Rows option.

4. Step 4

step image

A new row is inserted at the designated location.

5. Step 5

step image

Next, select the column header where you want to insert a column in the worksheet.  

Example shown here: Click column header M .

6. Step 6

step image

To insert a column at the selected location, click the dropdown arrow to the right of the Insert button.

7. Step 7

step image

Click the Insert Sheet Columns option.

8. Step 8

step image

A new column is inserted at the designated location.

9. Step 9

step image

You can also delete a row or column.

Within an Excel worksheet, click to select the appropriate row(s) or column(s) you would like to delete.   

Example shown here: Click row header 18 .

10. Step 10

step image

The selected row is highlighted.

To delete the row, click the dropdown arrow to the right of the Delete button on the Home tab.

11. Step 11

step image

Click the Delete Sheet Rows link.

12. Step 12

step image

The selected row is deleted.

13. Step 13

step image

To delete a column in your worksheet, click in the appropriate column header.  

Example shown here: Click column header AS.

14. Step 14

step image

The selected column is highlighted.

Repeat the same steps by clicking the dropdown arrow to the right of the Delete button.

15. Step 15

step image

Click the Delete Sheet Columns link.

16. Step 16

step image

The selected column is deleted.