The first step is to select the entire control column. To begin, chose a column of data that has empty cells in the same rows where the other columns of data also have empty cells. The first method works when you want to remove empty rows from your data.
I frequently use two quick and easy methods that solve this problem nearly every time.įor both methods, you’ll rely on one column in your data, a column with characteristics that apply to the other columns. At other times, you’ll want to delete rows with irrelevant data.
When you bring data from another source into an Excel worksheet, the data often includes rows that you’ll want to delete.
