You can delete Excel rows and columns easily and quickly. Remember that deleting a row or column removes all content from the selected row or column, not just the content of a single cell.
Click the Home tab.
Click the column heading letter or row heading number of the column or row you want to delete.
Click the Delete button. Excel deletes the selected content.
Tip
Delete Multiple Columns or Rows To delete more than one column or row, select the content you want to delete with your mouse, and click the Delete button. For example, if you select the row heading numbers for rows 7 through 9, Excel deletes those rows.