How to eliminate blank rows between information

  • Thread starter Thread starter juliomex
  • Start date Start date
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.
 
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Deleting blank rows 4
Insert blank rows 2
Deleting/removing unused rows in a worksheet 3
Inserting Blank rows between items 6
Deleting Multiple Blank Rows 6
deleting every other row in Excel 2
Delete blank rows if more than one 5
Deleting Blank Rows. 3

Back
Top