View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Renee working on data Renee working on data is offline
external usenet poster
 
Posts: 1
Default 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?