Remove blank row

  • Thread starter Thread starter Riz
  • Start date Start date
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.
 
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.
 
Choose "Blank" at your filter and then Select black rows and delete them at
once. it then open your filter .
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Row height setting problem 8
Deleting blank rows 4
Deleting blank rows with formulas in them 7
Force a filter beyond blank rows 1
Deleting Multiple Blank Rows 6
Excel 2007 Data Filter - When using cut it clears all data 2
Need to highlight cells in special order 0
Auto Hide Blank Rows 1

Back
Top