I want to delete multiple blank rows from a spreadsheet

S

Sharon43

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
 
P

PY & Associates

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
 
G

Gord Dibben

Select the column and F5 Special>Blanks>OK

Then Edit>Delete>Entire Row.


Gord Dibben Excel MVP
 

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

Top