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

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 have 4000+ rows in a worksheet, how to delete 100's at a time?
 

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 editdelete and
select delete entire row


--
Regards,

Peo Sjoblom



"Renee working on data" <Renee working on
wrote in message ...
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 have 4000+ rows in a worksheet, how to delete 100's at a time?
 

On Sep 12, 4:02 pm, Renee working on data <Renee working on
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.

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

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

"Peo Sjoblom" wrote in message
...
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 editdelete
and select delete entire row
--
Regards,

Peo Sjoblom

"Renee working on data" <Renee working on
wrote in message
...
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 have 4000+ rows in a worksheet, how to delete 100's at a time?
 

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




"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
That, of course, will delete a row if *any* cell in the row is blank,
rather than just rows where *all* cells are blank..
--
David Biddulph

"Peo Sjoblom" wrote in message
...
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 editdelete
and select delete entire row
--
Regards,

Peo Sjoblom

"Renee working on data" <Renee working on
wrote in message
...
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?