View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
gump gump is offline
external usenet poster
 
Posts: 3
Default 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?