I have a large table with a lot of emty rows and to use autofilter I need to remove all these.
D Dan Feb 19, 2007 #1 I have a large table with a lot of emty rows and to use autofilter I need to remove all these.
J Jim Cone Feb 19, 2007 #2 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.
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.
G Gord Dibben Feb 19, 2007 #3 Dan Without sorting............... Select a column. F5>Special>Blanks>OK Edit>Delete>Entire Row. Gord Dibben MS Excel MVP
Dan Without sorting............... Select a column. F5>Special>Blanks>OK Edit>Delete>Entire Row. Gord Dibben MS Excel MVP
