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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Renee working on data - 12 Sep 2007 21:02 GMT

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?

Reply to this Message

Peo Sjoblom - 12 Sep 2007 21:07 GMT

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

Signature

Regards,

Peo Sjoblom

>I have downloaded an excel document from PDF format to Excel and doing so
>has
[quoted text clipped - 3 lines]
> my
> worksheet and make it a more workable document?

Reply to this Message

David Biddulph - 12 Sep 2007 22:17 GMT

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

Signature

David Biddulph

> 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 have downloaded an excel document from PDF format to Excel and doing so
>>has
[quoted text clipped - 3 lines]
>> my
>> worksheet and make it a more workable document?

Reply to this Message

Peo Sjoblom - 12 Sep 2007 22:33 GMT

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

Signature

Regards,

Peo Sjoblom

> That, of course, will delete a row if *any* cell in the row is blank,
> rather than just rows where *all* cells are blank..
[quoted text clipped - 9 lines]
>>> my
>>> worksheet and make it a more workable document?

Reply to this Message

ilia - 12 Sep 2007 21:16 GMT

On Sep 12, 4:02 pm, Renee working on data <Renee working on
d...@discussions.microsoft.com> wrote:

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

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.

Reply to this Message