Deleting Rows

Delete rows that are no longer needed, contain superfluous data, or were created accidentally.

If your worksheet has extra unnecessary rows, it is easy to delete the row or values in the row. You may want to delete a row if you accidentally duplicate a row, no longer need an entry in your worksheet, or simply want to delete something and start over. 

How to Delete a Row

There are multiple ways to delete a row. You can delete a row by right clicking on the row header and selecting “Delete row __” from the dropdown. Alternatively, you can select a cell in the row you want to delete, right click, and select "Delete row __" from the dropdown.

RC-Delete-Row.jpg

You can also access delete options from the Edit menu in the top menu bar. With the column you want to delete selected, open the Edit menu and select "Delete column __" from the dropdown.

M-Delete-Row-Locate.jpg

Want to delete multiple rows at once? Select all of the contiguous rows you want to delete and follow any of the three processes described above. Note that if your multi-row selection includes your table header row, the “Delete rows” option will not be available since your table header row cannot be deleted.

Deleting Data but Retaining the Row

You can also delete the data in a row, but retain the empty row. This allows you to retain the formatting and data types of the row, but replace the data in it. To delete data, but not the row, in this way, simply select the desired row and press the Delete or Backspace key. Or, open the Edit menu and select "Delete value" from the dropdown.

M-Delete-Value-Locate.jpg

Undo

It's easy to fix any mistakes with undo. For instance, if you accidentally delete a row, or the data in a row, and wish to restore it. To undo an action, either use the keyboard shortcut Ctrl + Z, select the Undo button mceclip5.png in the Toolbar, or choose the Undo option in the Edit menu.

Undo-Locate.jpg

Deleting the Table Header Row

The Table Header Row cannot be deleted. However, you can change which row the table header row is and then delete the previous table header row. Table header rows are not deletable by default because table header rows are instrumental to your worksheet, with the table header row itself distinguishing between where the header ends and the table data begins.

Formulas

Most formulas should automatically remap cell references even after you delete a row or rows. However, some formulas may be impacted by inserting a new row or may return a #REF error and may need to be adjusted. For details on how to adjust formulas, see our article on Formula Readjustment.

Sometimes, after deleting a row, you may want to insert new rows, copy existing rows, or reorder rows in your worksheet. Read on to learn about these row functions and more.