Do not drag through to select them because this will include the hidden data. Select the rows separately or use the Ctrl key to select them. You should then see all of your blank rows with blue highlighted row numbers.

Below the Search option, click Select All to deselect all of the options.

Click one of these arrows to open the filter options. This places a filter arrow next to each column header in your range.Go to the Home tab, click Sort & Filter, and choose Filter.Select a column or column header in the cell range containing blank rows.One way to find blank rows easily is using a Filter in Excel. Then remove them with one of the above methods. In this case, use one of the options below to find the blank rows.

If you have a spreadsheet full of data, finding blank rows manually can be time-consuming. Then use one of the above actions to remove them. If the rows are adjacent, you can drag your cursor through the range to select them. Hold your Ctrl/Control key as you select each row. If you spot several blank rows, you can remove them all at once.

Use the keyboard shortcut Ctrl + Hyphen (-) on Windows or Control + Hyphen (-) on Mac.

Click Delete > Delete Sheet Rows in the ribbon on the Home tab.

Right-click and choose Delete or Delete Row.

Select the row and do one of the following: And you have a few methods you can use to delete rows in Excel. If you don’t have a lot of data in your sheet, this may also be the quickest way. Sometimes it’s easiest to remove a blank row that we see.

Use whichever is most comfortable or convenient for your particular sheet.

Here are several ways to find and delete blank rows in Excel.

Ocenaudio delete selected region