View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default how to remove empty rows?

Ron's reply is for one column

If you want to check more columns you can look here for code
http://www.rondebruin.nl/delete.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Joe" wrote in message ...
one more question on cleaning up this spreadsheet. After migrating a
list into excel there are a significant number of empty rows in
between. Is there a way to eliminate all the empty rows at once?