Choose "Blank" at your filter and then Select black rows and delete them at
once. it then open your filter .

"Riz" wrote:

how do i remove blank row from a sheet present at many places, which
restricts me from filtering all data in a sheet.