Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I delete alternating rows in excel
I have over 5,000 rows of data. I only need the odd number rows (1,3,5) and
need to delete the even rows. Is there a faster way then hold CTRL and clicking on even number rows and then deleting? How can select all the even number of rows and then delete all? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I delete alternating rows in excel
gump wrote:
I have over 5,000 rows of data. I only need the odd number rows (1,3,5) and need to delete the even rows. Is there a faster way then hold CTRL and clicking on even number rows and then deleting? How can select all the even number of rows and then delete all? Insert a column. Put =MOD(ROW(),2) in row 1 and copy down. Sort all of your data by that column. Delete the appropriate rows. Delete the column. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I delete alternating rows in excel
gump
Put this formula in a spare column =mod(row(),2) copy it down all your relevant rows. convert the formula to values (paste special values on top of the mod formula) sort by that column, the zeros will come to the top where they can all be deleted at once the other rows should still be in the same order as prior to the sort since they are all 1's Good luck Ken Norfolk, Va On Jul 29, 3:41*pm, gump wrote: I have over 5,000 rows of data. *I only need the odd number rows (1,3,5) and need to delete the even rows. *Is there a faster way then hold CTRL and clicking on even number rows and then deleting? *How can select all the even number of rows and then delete all? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I delete alternating rows in excel
You have a couple of suggestions but they both ibvolve sorting.
Do you want to do that? If not, in an adjacent column in cell 2 enter an X In cell 4 enter an X Select cell 2 to cell 5 Double-click to fill down. AutoFilter for X and delete those rows. Gord Dibben MS Excel MVP On Wed, 29 Jul 2009 12:41:02 -0700, gump wrote: I have over 5,000 rows of data. I only need the odd number rows (1,3,5) and need to delete the even rows. Is there a faster way then hold CTRL and clicking on even number rows and then deleting? How can select all the even number of rows and then delete all? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I shade alternating rows in spreadsheet | Excel Discussion (Misc queries) | |||
Alternating Color Rows | Excel Discussion (Misc queries) | |||
fill rows with alternating data ? | Excel Discussion (Misc queries) | |||
shade alternating rows in excel | Excel Discussion (Misc queries) | |||
Alternating colors for rows | Excel Discussion (Misc queries) |