Set up autofilters and select (blanks) from the pull-down list on the
column. Then highlight all the displayed rows which have been filtered
(row indicator shows as blue) and Edit | Delete Row. Select (All) from
the pull-down filter list and you will have what you have asked for.

Hope this helps.

Pete