Inserting and Deleting Rows and Columns

Basic formatting in Excel can customize the look and feel of your Excel spreadsheet. Learn about inserting and deleting rows and columns here.

Deleting columns and rows

Deleting columns and rows is much like inserting columns and rows.

To delete columns and rows:

  • Select one or more columns or rows.
  • To clear the content but leave the emptied row in place, press Delete on your keyboard.

OR

  • To delete the contents and remove the row or column, choose EditDelete from the menu bar.