Deleting Every Other Row

C

Chris

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
 
B

Bill Kuunders

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting Dilemma 6
Deleting all even numbered rows?? Help 3
How do I keep my row formatting when sorting data? 1
Insert Cells every other row 1
Simple SUMIF Question 3
Sorting rows into a row 1
Error in Copying "Exact" Function 1
How can I save a 40meg 26,000 row file to Space Delimited format 1

Top