MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Deleting blank lines.

Posted by ExcelUser on June 14, 2001 11:57 PM

Hi, i was wondering if anyone can help me with these Q's:

1. i work with large excel files with usually 1000+ lines. There are blank rows after each row with information. How do i delete all the blank rows without going through them 1 by 1 (or even holding down CTRL and selecting them all individually)?
2. I have certain keywords in rows (for example the keyword CHICAGO may appear on column H in row 1 and column A in row 2). I want to group these rows together with a certain keyword value. how do i do that?

Thanks a lot for your help. :)

A newbie Excel User

Posted by Malc on June 15, 2001 3:04 AM

Have you tried selecting all 100 rows and sorting them. The empty rows would go the the bottom and your keywords would be togrther

Posted by Loren on June 15, 2001 4:52 AM

Before you sort, insert a column and number it. This allows you to restore
your row order: after you sort on other columns and delete, sort on this new col.