Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Is it possible to somehow delete the odd numbered rows in an excel spreadsheet?
My partner and I have a list of 1500 leads in an excel spreadsheet and want to split them by odd and even row numbers. Thanks, Chris |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
with an added help column
enter 1 and 2 selectthe two cells and extend that series using the right hand bottom corner of the second cell and hold the control button so that you'll get 1212121212 going down then sort the data using that column -- Greetings from New Zealand "Chris" wrote in message ... Is it possible to somehow delete the odd numbered rows in an excel spreadsheet? My partner and I have a list of 1500 leads in an excel spreadsheet and want to split them by odd and even row numbers. Thanks, Chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Deleting the text without deleting the formula | Excel Worksheet Functions | |||
Deleting a row | Excel Discussion (Misc queries) | |||
Deleting cell data without deleting formula | Excel Discussion (Misc queries) | |||
deleting values in a worksheet without deleting the formulas | Excel Worksheet Functions | |||
how prevent formula in cell from deleting when deleting value???? | New Users to Excel |