Two Ways to Delete Individual Rows in Microsoft Excel
If you’re working with a small, uncomplicated spreadsheet, there are a couple of easy ways to delete a single row or even a few rows without too much trouble. The easiest of those ways is to highlight the row by selecting the row number and then use the Ctrl + - keyboard shortcut to delete the row. This is fast and easy if you have only a small number or even the occasional wayward blank row to delete. Another easy way to delete a single row in Microsoft Excel is to right-click the row number and then select Delete from the context menu that appears. This deletes only the row selected.
How to Delete Empty Rows in Excel With Find & Select
If you’re working with a larger worksheet in Excel, deleting rows individually, or even a few at a time, can be a pain, not to mention time-consuming. Fortunately, there’s an easy way to delete all your blank rows at one time.
