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

[sumesh56]

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

 

[Spencer101]

i have a worksheet in which there are data in some rows say in ever
fifth or sixth rows. the in between rows are blank. now i want to delet
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 dir
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, g
to cell F2 and enter =COUNTA(A2:E2). Copy that formula down to th
last populated row of data, apply an autofilter to row A and restric
column F to zero.

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

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

S

 

[Don Guillett]

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?

Select the column>f5>special cells>blanks>edit>delete

 

[Gord Dibben]

Select a column then F5>Special>Blanks>OK

Edit>Delete>Entire Rows


Gord

 

[sumesh56]

;1600330']Select a column then F5>Special>Blanks>OK

Edit>Delete>Entire Rows


Gord

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

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 t delete
those blank rows. how can i accomplish this task in a single step?-

thanks all for the suggestion