remove emty rows in a table

[Guest]

I have a large table with a lot of emty rows and to use autofilter I need to
remove all these.

 

[Jim Cone]

Sort the table. The empty rows will sort to the bottom.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Dan" <[email protected]>
wrote in message
I have a large table with a lot of emty rows and to use autofilter I need to
remove all these.

 

[Gord Dibben]

Dan

Without sorting...............

Select a column.

F5>Special>Blanks>OK

Edit>Delete>Entire Row.


Gord Dibben MS Excel MVP