removing blank lines

  • Thread starter Thread starter PeterM
  • Start date Start date
P

PeterM

I have a spreadsheet in ?AC2003 that looks like this

Smith
Jones

Anderson

Brown
Johnson

What I am looking to do is to come up with a way to scan the column and
remove any rows where the name column is blank. Do I have to do it in VBA or
is there another way to do it?

thanks in advance for your help!
 
Look here:

http://www.cpearson.com/excel/deleting.htm#DeleteBlankRows

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have a spreadsheet in ?AC2003 that looks like this
|
| Smith
| Jones
|
| Anderson
|
| Brown
| Johnson
|
| What I am looking to do is to come up with a way to scan the column and
| remove any rows where the name column is blank. Do I have to do it in VBA or
| is there another way to do it?
|
| thanks in advance for your help!
 
Select the column.

F5>Special>Blanks>OK

Edit>Delete>Entire Rows


Gord Dibben MS Excel MVP
 
Back
Top