The fastest way to remove a row or column
To delete a row, right-click on the row number on the left side of the spreadsheet — the gray column that shows 1, 2, 3, and so on. A menu will appear. Click Delete. The entire row disappears, and all rows below it move up to fill the space.
To delete a column, right-click on the column letter at the top — A, B, C, and so on. Click Delete. The entire column disappears, and all columns to the right shift left.
If you need to delete multiple rows or columns at once, click on the first row or column number, then hold Shift and click on the last one you want to remove. All rows or columns in between will highlight in blue. Right-click and select Delete.
Key Takeaways
- Right-click the row number or column letter and select Delete to remove the entire row or column in one step.
- Multiple rows or columns can be deleted together by clicking the first, holding Shift, clicking the last, then right-clicking and selecting Delete.
- Deleting a row or column shifts everything below or to the right upward or leftward automatically.
- If you delete something by mistake, press Ctrl+Z (or Cmd+Z on Mac) when ready to undo the deletion.
Selecting rows and columns before you delete
Before you delete, make sure you have selected exactly what you want to remove. A single click on a row number or column letter selects the entire row or column — you will see it highlight in blue. This is different from clicking inside a cell, which selects only that one cell.
If the rows or columns you want to delete are not next to each other, you can select them one at a time while holding Ctrl (or Cmd on Mac). Click the first row number, then hold Ctrl and click each additional row number you want to remove. They will all highlight. Then right-click and delete.
Take a moment to look at what is highlighted before you right-click. Once you delete, the data is gone from the spreadsheet — though you can undo with Ctrl+Z if you catch the mistake right away.
What happens to your data when you delete
When you delete a row, everything in that row is removed permanently from the spreadsheet. All rows below it shift upward to close the gap. If row 5 contained important data and you deleted it, that data is no longer in the spreadsheet unless you undo the action.
The same applies to columns. When you delete a column, all data in that column is removed, and all columns to the right shift left. If you had formulas in other columns that referenced the deleted column, those formulas will show an error because the data they pointed to no longer exists.
This is why it is worth taking a second look at what you have selected before you right-click. If you are not certain, you can always undo by pressing Ctrl+Z when ready after the deletion.
Using Undo if you delete the wrong row or column
If you delete something by mistake, press Ctrl+Z on Windows or Cmd+Z on Mac right away. The deleted row or column will reappear exactly where it was. You can undo multiple times in a row if you need to reverse several actions.
The undo history is only available while you are working in the spreadsheet. Once you close the file without saving, you cannot undo deletions from a previous session. If you realize the mistake after you have closed the file, you may be able to recover an earlier version if your file is stored in OneDrive or Google Drive, but this depends on your backup settings.
For this reason, if you are deleting a large section of data and you are not completely certain, consider saving a copy of the spreadsheet first under a different name. That way you have a backup if something goes wrong.
Deleting rows or columns without losing data
Sometimes you want to remove a row or column from view but keep the data somewhere safe. Instead of deleting, you can cut the data and paste it elsewhere. Click on the row or column number to select it, then press Ctrl+X (or Cmd+X on Mac) to cut. Click where you want to paste it — perhaps a blank area of the same spreadsheet or a different sheet — and press Ctrl+V to paste.
Another option is to hide the row or column instead of deleting it. Right-click the row or column number and select Hide. The row or column disappears from view, but the data remains in the spreadsheet. You can unhide it later by selecting the rows or columns on either side of the hidden one, right-clicking, and selecting Unhide.
Hiding is useful when you have data you do not need to see right now but might need later. Deleting is the right choice when you are certain the data is no longer needed.
Clearing cell contents instead of deleting rows
If you only want to remove the data inside cells but keep the row or column structure intact, you can clear the contents without deleting the row. Click on the cells you want to empty, then press the Delete key on your keyboard. The data disappears, but the row or column stays in place.
This is different from right-clicking and selecting Delete, which removes the entire row or column and shifts everything else. Pressing Delete only empties the cells you selected. This is useful when you have formulas or formatting in other cells that depend on the row or column structure staying the same.
Frequently Asked Questions
Can I delete a row without losing the data in it?
Yes. Instead of right-clicking and selecting Delete, select the row and press Ctrl+X to cut it. Then click where you want to paste it — another area of the spreadsheet or a different sheet — and press Ctrl+V. The row data moves to the new location, and the original row is removed.
What happens to formulas when I delete a column?
If other cells contain formulas that reference the deleted column, those formulas will show a #REF! error because the data they pointed to no longer exists. Before you delete a column, check whether any formulas depend on it. You can search for formulas by pressing Ctrl+` (backtick) to show all formulas in the spreadsheet.
Can I undo a deletion after I close the file?
No. Undo only works while the file is open. Once you close the spreadsheet, the undo history is gone. If your file is stored in OneDrive or Google Drive, you may be able to recover an earlier version through your cloud storage settings, but this is not may provide.
How do I delete multiple non-consecutive rows?
Click the first row number, then hold Ctrl (or Cmd on Mac) and click each additional row number you want to remove. All selected rows will highlight in blue. Right-click and select Delete. All selected rows will be removed at once.
Is there a difference between Delete and Clear Contents?
Yes. Delete removes the entire row or column and shifts everything else to close the gap. Clear Contents (pressing Delete key) only empties the cells you selected and leaves the row or column structure in place. Use Delete when you want to remove the row or column itself, and Clear Contents when you only want to empty the data inside.