Delete the blank rows

[Earl]

I was able to filter non-blanks. Now how dow I delete
those blank rows and turn off the filter?

 

[Don Guillett]

just highlight the row numbers and right click & delete.
Then data>filter>autofilter

 

[Gord Dibben]

Earl

If your non-blank rows are hidden, select to the bottom of the blank rows and
Edit>Go To>Special"Visible cells only">OK

Now Edit>Delete>Entire Rows.

To turn off Autofilter: Data>Filter>Autofilter - click it.

Alternative: Turn off Autofilter by Data>Filter>Autofilter - click it.

Select your data range in a column including blank rows.

Edit>Go To>Special>Blanks>OK

Edit>Delete>Entire Rows.

Gord Dibben Excel MVP

 

[Earl]

Thanks Don, that was too easy!

-----Original Message-----
just highlight the row numbers and right click & delete.
Then data>filter>autofilter

--
Don Guillett
SalesAid Software
(e-mail address removed)



.

 

[sokevin]

thi help me alot for autofilter...


just do

Alt D F F to turn on and then

Alt D F F to turn off.

cheer