Remove blank row

R

Riz

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

Jack Gopher

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

Satyendra_Haldaur

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