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?