View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Daren Daren is offline
external usenet poster
 
Posts: 162
Default Deleting Rows Between Empty Cells

Thanks!

"Gord Dibben" wrote:

F5SpecialBlanksOK

EditDeleteEntire Rows


Gord Dibben MS Excel MVP

On Thu, 4 Sep 2008 11:55:01 -0700, Daren
wrote:

I have a large data set that I'm copying from Access into Excel. There are
blank rows between the data I want to analyze. Is there a way to quickly
delete these rows so I can have the date inn consecutive rows? Thanks.