block row from number column

Select the blank rows we want to delete. Hold Ctrl key and click on a row to select it.
When the rows we want to delete are selected then we can right click and choose Delete from the menu

Select the blank rows we want to delete. Hold Ctrl key and click on a row to select it.
When the rows we want to delete are selected then we can right click and choose Delete from the menu.

To find and remove blank rows using Go to Special:
1. Select one column where there are blank cells in the column (we're assuming here that the rest of the row is blank). If there is sensitive data above or below the list that you don't want to delete, select the cells in the column from the first cell in the range to the last cell in the range (you could click in the first cell and Shift-click in the last cell).
2. Press Ctrl + G. The Go To dialog box appears.
3. Click Special to display the Go To Special dialog box. Alternatively, you can click the Home tab in the Ribbon and then select Go To Special from the Find & Select drop-down menu.
4. Select Blanks in the Go to Special dialog box and click OK. Excel will select all of the blank cells within the selected range.
5. Right-click one of the selected blank cells and select Delete. A dialog box appears.
6. Select Entire Row.
7. Click OK.