how to remove empty rows?

J

Joe

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?
 
R

Ron Coderre

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete extra empty rows 2
Deleting empty rows automatically 2
Delete Empty Rows 4
Deleting/removing unused rows in a worksheet 3
Write a macro that hides rows based on empty cells 3
How Do U number a list of names, but there are empty rows in betw 5
Help on Macro to hide empty rows 4
Cannot remove empty rows 8

Top