Help!

Deleting Every Other Row

 
  

Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> General Discussions RSS
Next:  macro stopped working after upgrade to 2007  
Author Message
Chris
External


Since: Apr 10, 2006
Posts: 390



PostPosted: Mon Jun 15, 2009 2:17 pm    Post subject: Deleting Every Other Row
Archived from groups: microsoft>public>excel>misc (more info?)

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
Back to top
Bill Kuunders
External


Since: Aug 31, 2003
Posts: 258



PostPosted: Mon Jun 15, 2009 7:10 pm    Post subject: Re: Deleting Every Other Row [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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" <Chris RemoveThis @discussions.microsoft.com> wrote in message
news:AF46BD5B-624E-4D43-82FF-AE0528AC26E3@microsoft.com...
> 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
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> General Discussions All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum