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
|