how to remove empty rows?
 

one more question on cleaning up this spreadsheet. After migrating a
list into excel there are a significant number of empty rows in
between. Is there a way to eliminate all the empty rows at once?

how to remove empty rows?
 

Try this:

Select an entire columne from the data area
Press the [F5] key........a shortcut for <edit<go to
Click the [Special] button
Check: Blanks
Click [OK]

That will select the blank cells

From the Excel Main Menu:
<edit<delete
....Check: Entire Row
....Click [OK]

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Joe" wrote in message
...
one more question on cleaning up this spreadsheet. After migrating a
list into excel there are a significant number of empty rows in
between. Is there a way to eliminate all the empty rows at once?

how to remove empty rows?
 

Ron's reply is for one column

If you want to check more columns you can look here for code
http://www.rondebruin.nl/delete.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Joe" wrote in message ...
one more question on cleaning up this spreadsheet. After migrating a
list into excel there are a significant number of empty rows in
between. Is there a way to eliminate all the empty rows at once?