how to delete some rows without data which comes in between rows with data
 

i have a worksheet in which there are data in some rows say in every fifth or sixth rows. the in between rows are blank. now i want to delete those blank rows. how can i accomplish this task in a single step?

I'm sure there are more elegant ways, but for a quick and dirt method...

In a blank column to the right of your data put in a =COUNTA() formula.

If for example your data was in colums A to E, and headers in row 1, go to cell F2 and enter =COUNTA(A2:E2). Copy that formula down to the last populated row of data, apply an autofilter to row A and restrict column F to zero.

These will be your blank rows. You can then highlight and delete these rows only.

Not the best way I'm sure, but quick and easy.

S.

how to delete some rows without data which comes in between rowswith data
 

On Sunday, April 1, 2012 2:58:28 AM UTC-5, sumesh56 wrote:
i have a worksheet in which there are data in some rows say in every
fifth or sixth rows. the in between rows are blank. now i want to delete
those blank rows. how can i accomplish this task in a single step?




--
sumesh56

Select the columnf5special cellsblankseditdelete

how to delete some rows without data which comes in between rows with data
 

Select a column then F5SpecialBlanksOK

EditDeleteEntire Rows


Gord

On Sun, 1 Apr 2012 07:58:28 +0000, sumesh56
wrote:


i have a worksheet in which there are data in some rows say in every
fifth or sixth rows. the in between rows are blank. now i want to delete
those blank rows. how can i accomplish this task in a single step?

thanks all for the suggestions