I want to delete multiple blank rows from a spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have transferred approx 2000 rows of data from a Crystal report and of
these there are approx 1000 blank rows. I want to delete these but not by
selecting each one. Can anyone help
 
Add a new column A,
number it from 1 to 2000
sort by column B
delete all rows below last row of column B
sort by column A again
 
Select the column and F5 Special>Blanks>OK

Then Edit>Delete>Entire Row.


Gord Dibben Excel MVP
 
Back
Top