Delete the row - but only if certain cells are blank

Hello,

This is my first post here. This community seems very helpful from some of the searches I have done recently.

I have a very large Excel spreadsheet and I need to sift through the data and delete certain rows. Let's say the spreadsheet has 10 columns. I only want to delete rows that contain empty cells from two specific columns. If cells from one or both columns contain data, the entire row must remain.

Basically: [Delete entire row if cells from columns 1 and 2 are blank]

Is there an efficient way to delete these specific rows?

Thank you,
Rook

Select all your data, let's say A1:Z3000

Activate the filter (Home > Sort & Filter > Filter) or (Data>Filter)
Then Let's say you want to delete all rows where C and R are blank
Filter those two columns for blanks, then delete those rows

Does that work for you?

No need to use the control key. Filter one, then the other. Only rows where both are blank will be showing.

If you have selected all of your data prior to applying the filter, no blank rows will make it through your filter.

See attached.

Thank you for the attached file. Using a simple example help me to extrapolate the principle to my several thousand row spreadsheet.

Edit: I forgot to mention that I suspect my problem with the filter feature yesterday was the result of miscellaneous blank rows within my data set. It seems like they somehow were interfering with the filtering.

What often happens when there are miscellaneous blank rows is that the entire range of rows is not filtered. It's important to select the entire range before engaging a fillter, otherwise Excel picks the range down to that first blank row.