This article explains three methods to delete blank rows in an Excel spreadsheet in Microsoft Excel 2019, Excel 2016, and Office 365. These methods include manual deletion, deletion using a keyboard shortcut, and deletion using the Find & Select option.

If you’re working with a small, uncomplicated spreadsheet, there are a few simple ways to delete a single row or even a few rows without too much hassle. The easiest way is to highlight the row by selecting the row number and then use the keyboard shortcut Ctrl + – to delete the row. This is quick and easy if you only want to delete a small number of rows or even the occasional quirky blank row.

Another easy way to delete a single row in Microsoft Excel is to right-click on the row number and then select Delete from the context menu that appears. This will delete only the selected row.

When you’re working with a large spreadsheet in Excel, deleting rows individually, or even a few at a time, can be a hassle, not to mention time-consuming. Luckily, there’s an easy way to delete all of your blank rows at once.