Deleting blank rows

  • Thread starter Thread starter Joana
  • Start date Start date
J

Joana

How can I quickly delete blank rows from a list I've
imported to an Excel worksheet so that I can after order,
filter the entire list?
 
Joana

Pretty quickly!
Select a column which includes the blank rows. Click Edit/Go To/Special . .
Blanks - and OK. Then Right click on your selection and click Delete . . .
and select Entire Row.
Or, you could sort on a column containing the blank rows and that would put
them all together, for easy deletion.

Andy.
 
Hum... my problem is that I don't have some columns with
blank rows, I have entire blank rows in the middle of my
list...
And I can not use sort to solve it because it sorts only
until it finds the first blank row in the list...
 
Back
Top