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