remove emty rows in a table
 

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

remove emty rows in a table
 

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


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

remove emty rows in a table
 

Dan

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

Select a column.

F5SpecialBlanksOK

EditDeleteEntire Row.


Gord Dibben MS Excel MVP

On Mon, 19 Feb 2007 09:12:11 -0800, Dan wrote:

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