I have 4000+ rows in a worksheet, how to delete 100's at a time?

  • Thread starter Renee working on data
  • Start date
R

Renee working on data

I have downloaded an excel document from PDF format to Excel and doing so has
given me hundreds of blenk rows in the data source. Is there a way to select
the worksheet and tell the program to delete all blenk rows? To condense my
worksheet and make it a more workable document?
 
P

Peo Sjoblom

First save a backup copy of the original file, then select the range of your
data, press F5, select special and select blanks, now do edit>delete and
select delete entire row
 
I

ilia

I have downloaded an excel document from PDF format to Excel and doing so has
given me hundreds of blenk rows in the data source. Is there a way to select
the worksheet and tell the program to delete all blenk rows? To condense my
worksheet and make it a more workable document?
Click to expand...

I use the AutoFilter feature to do this. Select the entire range, and
filter out the column that is always non-blank (usually some kind of
index column). Then select those rows and delete them, or do what Peo
suggested with the "delete entire row". This also works for export
spreadsheets that have repeating column headers on every page, you
just include them in your filter selection.
 
D

David Biddulph

That, of course, will delete a row if *any* cell in the row is blank, rather
than just rows where *all* cells are blank..
 
P

Peo Sjoblom

Of course it will, that's why I told the OP to make a backup.
I based it on experience in converting PDF files where the
extra blanks were indeed all across the sheet.

Of course one can always select shift cells up in the last step


--
Regards,

Peo Sjoblom
 
Top