View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default How to eliminate blank rows between information

Maybe you can select the range and sort it by a key column.

The blanks will be grouped together (maybe at the top), but they'll be easy to
delete.

Another way is to pick out a column that always has something in it if the row
is used.
Then apply data|filter|autofilter and show the blank cells.
Then delete the visible rows
And remove the autofilter.



juliomex wrote:

I need to delete many blank rows between information but i do not want to go
one by one how can I delete it.


--

Dave Peterson