EXCEL ROW DELETIONS

  • Thread starter Thread starter Laine
  • Start date Start date
L

Laine

I have a workbook with 10,000 rows of zipcodes, every
other row is blank. I need to delete these blank rows. Is
there a way it can be done all at once instead of
selecting each one?
Thanks
 
Laine said:
I have a workbook with 10,000 rows of zipcodes, every
other row is blank. I need to delete these blank rows. Is
there a way it can be done all at once instead of
selecting each one?
Thanks
Click to expand...

If you sort the data, all the blank rows will sort together at the end.

If you need to retain the order:
First insert a new column A and enter =ROW() in A1.
Copy this down to A10000.
Then sort on a column other than A.
Delete the rows that are blank (other than in column A).
Then sort by column A.
Lastly delete column A.
 
I think the easiest way is to apply an autofilter on
columnA.
Choose "Blank" from the drop down
Then select and delete all the rows.
Lastly take off the autofilter and all the rows with data
will remain unaffected, less the blank rows.
 
You're doing nothing wrong. The answer will delete all your data.
Instead, after applying the autofilter, you need to select only the
visible rows. One way:

Select from the cell under the header to the first line past your
data. Choose Edit/Goto/Special/Visible cells only. Right-click one
of the row headers and select Delete Row.
 
I think it was meant to select the blank rows.

Laine said:
Hi John,
I am good up until "Then select and delete all the rows".
When I do this I lost everything. What am doing wrong?
Laine
Click to expand...
 
Back
Top