How to Delete Rows in Excel on PC or Mac

Written by Nicole Levine, MFA

Last Updated: March 29, 2019

This wikiHow teaches you how to delete one or more rows from a spreadsheet in Microsoft Excel.

Method 1

Method 1 of 2:
Deleting One Row

1
Open the spreadsheet in Microsoft Excel. You can do this by double-clicking the file on your computer.
2
Right-click the row number you want to delete. Numbers run along the left side of the screen.
3
Click Delete. The row is now deleted.

Method 2

Method 2 of 2:
Deleting Multiple Rows

1
Open the spreadsheet in Microsoft Excel. You can do this by double-clicking the file on your computer.
2
Click and hold a cell in the first row you want to delete. Any cell in the row is fine.
3
Drag the mouse down to the last row you want to delete. You should now have cells highlighted in every row you want to delete.
4
Right-click any of the selected cells. A menu will appear.
5
Click Delete….
6
Click Entire Row. The selected rows will all be deleted.^{[1]
X
Research source}

You Might Also Like

References

↑ https://support.office.com/en-us/article/insert-or-delete-cells-rows-and-columns-6f40e6e4-85af-45e0-b39d-65dd504a3246

About This Article

Written by:

Nicole Levine, MFA

Tech Specialist

This article was written by Nicole Levine, MFA. Nicole Levine is a Technology Writer and Editor for wikiHow. She has more than 20 years of experience creating technical documentation and leading support teams at major web hosting and software companies. Nicole also holds an MFA in Creative Writing from Portland State University and teaches composition, fiction-writing, and zine-making at various institutions. This article has been viewed 10,376 times.

How helpful is this?

Co-authors: 1

Updated: March 29, 2019

Views: 10,376

Categories: Microsoft Excel