Add or Remove Rows and Columns

In Word, to work on rows and columns we needed Table. However, in Excel, we directly work on rows and columns. These rows and columns when intersect together, make cells.

Let’s say we have entered 41 in A3 and 45 in A4.

Now, we’ll see how to add a new row and a new column in Excel with the above data.

To insert a new row

  • We have to first decide where we want to add the new row. Suppose I want to insert new row above the number 45.
  • I’ll do a right click on this row. Remember you can do right click on any cell in the same row.
  • When you get the drop-down menu, click Insert button and Insert window will open.
  • Select Entire row and click OK.
  • You’ll see a new row added above the current row.

To add a new column

We’ve entered data in column A and there is no column before column A. So if we have to add a new column before column A, how’ll we do that?

  • Right-click on any of the cells in column A, we’ll again see the Insert drop-down menu.
  • Now, select Entire column and click OK button.
  • As we’re adding a new column before column A (this is the first column), Excel will move the current column data to the next column and title it with column B; and make the newly added column as column A.

Please note when you add a new row, it is added above the current selected row and when you add a new column, it is added before the current selected column.

To delete or remove a row

  • Right-click on the row that you want to delete.
  • From the drop-down menu, click Delete button.
  • When you see Delete window, select Entire row and click OK.
  • The selected row will be deleted.

To delete or remove a column

  • Right-click on any cell in the column that you want to delete.
  • In the drop-down menu, click Delete and when you see the Delete window, select Entire column.
  • Click OK button to remove the current selected column.