Deleting Every Other Row
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 |
Deleting Every Other Row
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 |
All times are GMT +1. The time now is 11:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com