Thread: remove emty rows in a table
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jim Cone Jim Cone is offline
external usenet poster
  
Posts: 3,290
Default 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.
Reply With QuoteReply With Quote