How do I delete even rows (2,4,6) in an excel?

  • Thread starter Thread starter Karthik
  • Start date Start date
K

Karthik

I have 1000 rows in a excel. I want to delete all alternative rows beginning
with 2 till 998. i dont know how to use this.

Please reply
 
Pick an un-used column and insert:
=MOD(ROW(),2) into, say Z2, and copy down

Autofilter column Z and then select rows with 0 in that column

Then delete the visible rows.
 
You must log in or register to reply here.

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

Why Excel Does not increment by 2 or 3, odd/even numbers? 6
delete rows 4
Match and delete rows on two different sheets from reference numbers 4
Selecting rows. 3
How do I delete alternating rows in excel 4
How to increase the row num in hlookup 0
How can i Show .... 1
How do i match simillar data between two different rows in excel? 3

Back
Top