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

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?