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?

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?

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?