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.
You can also access delete options from the workbook menu by navigating to Edit > Delete row.
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 workbook menu and navigate to Edit > Delete value.
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 in the Toolbar, or choose the Undo option in the Edit menu.
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.
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.