How to eliminate blank rows between information

J

juliomex

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

Max

Try this quick sequence on a copy of your sheet ..

Assume col A is the key col which defines the blank rows
(ie where col A is blank, then the entire row is considered as blank)

Select col A (select the col header)
Press F5>Special>Check "Blanks">OK
Right-click>Delete>Check "Entire Row">OK
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
 
D

Dave Peterson

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.
 
Top