View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Barb Reinhardt
 
Posts: n/a
Default I WANT TO DELETE A WIDE OF DATE IN A EXCEL FILE

How about adding a helper column and in that column enter the following:

=mod(row(),2)

You'll get either a 1 or a 0. You can then autofilter to remove whichever
you want.

"Wing" wrote in message
...
I HAVE A EXCEL FILE WHICH CONTAIN ABOUT 5,000 ROWS, BUT I WANT TO DELETE
ALL
THE DATA WHICH PLACED IN ODD ROWS/ EVEN ROWS. (ABOUT 2,500 ROWS)

I TRIED A METHOD: PRESS "ALT" THEN CHOSE THE ROWS WHICH I WANTED TO DELETE
,
THIS METHOD IS GOOD, BUT THIS ISN'T EFFIENCENT. DO YOU HAVE ANOTHER FASTER
METHOD?