Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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?
|
#2
|
|||
|
|||
Quote:
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
|
|||
|
|||
Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
delete rows if data is either | Excel Programming | |||
Delete rows with data | Excel Programming | |||
How do I delete blank rows (rows alternate data, blank, data, etc | Excel Discussion (Misc queries) | |||
Delete rows with no data | Setting up and Configuration of Excel | |||
Delete certain rows of data... | Excel Programming |