how to delete rows with no data in excel

Click on Find & Select in the Editing group.

Note: in this example we are selecting rows 3 to 8.ġ0. Select all of the rows in the data (filtered) range. Filter for Text by clicking of the filter box in the Text/No Text cell (F2) and selecting only the Text checkbox.ĩ. Click on Sort & Filter in the Editing group.ħ. Note: in this example we are selecting range (B2:F8).ĥ. Select the data range, including the formula and the associated headings.

We have also inserted a column heading, Text/No Text, in cell F2 associated with formula that is applied.ģ. Note: in this example we are applying the formula for rows 3 to 8. Apply the formula across all of the rows associated with the range. The data_row_rng is a range that represents a single row from a data range that you are testing for text.Ģ. Enter this formula into the column against the first data row (=IF(COUNTIF(data_row_rng,'*')>0,'Text','No Text')). Scroll to the column next to the last data column, which in this example will be column F. This image shows the starting point without any adjustments.ġ. In this example we will be deleting entire rows if there is text in any of the rows, in range (B3:E8). Enter formula in the column next to the last data column > Apply the formula across relevant rows > Select the range, including the formula > Home tab > Editing group > Click Sort & Filter > Click Filter > Filter for Text > Select all the rows within the range > Editing > Click Find & Select > Click Go To Special > Select Visible cells only > Click OK > Delete rows

How to delete rows with no data in excel