Thread: How do I delete even rows (2,4,6) in an excel?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default How do I delete even rows (2,4,6) in an excel?
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.

--
Gary''s Student - gsnu200814


"Karthik" wrote:

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
Reply With QuoteReply With Quote