If your worksheet has extra unnecessary rows, it is easy to delete the row or values in the row. For instance, if you accidentally duplicate a row, no longer need an entry in your worksheet, or simply want to delete something and start over.
Topics in this Article:
How to Delete Rows
In Spreadsheet.com there are multiple quick ways to delete a row or rows. For instance, you can right-click on the row header of the row for deletion and select Delete Row. You can also use the Delete Row option in the Edit menu, or right-click on a single cell in the row and select Delete Row. To delete more than one row, simply select multiple rows before right-clicking or using the Delete Rows option in the Edit menu.
|Delete: via right-clicking the row header||Delete: via right-clicking a cell in the row||Delete: via the edit menu|
Deleting a row removes the data and the row from your worksheet. But, you can use undo to restore a recently deleted row. 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.
In the animation below, we demonstrate all three methods of deleting a row or rows and then undo our deletes to restore the deleted rows.
Deleting the Data, but Retaining the Row
It is also possible to empty out the data in a row but retain the row and its formatting. One way to do this is by selecting the data to empty and pressing the delete key on your keyboard. Another is to select the row to be empty and then choose Delete Value from the Edit menu.
Deleting the Table Header Row
The Table Header Row cannot be deleted. However, you can change the table header row and then delete the previous table header row. Table header rows are undetectable 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.
Sometimes, after deleting a row, you may want to insert new rows, copy existing rows, or reorder rows in your worksheet. If so, check out the corresponding article, or, for an overview, check out our Introduction to Rows article.