Quote:
Originally Posted by 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 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.