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

Just select the whole data range, and sort the data by one of the columns.
The sort action will move all blank rows together to the beginning (or to
the end, depends on teh sort), and then you can easily delete them altogether.


--
<a href="http://www.free-training-tutorial.com"Microsoft Excel Training
Tutorial</a
<a
href="http://www.free-training-tutorial.com/function-vlookup.html"vlookup</a



"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.

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.