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.