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?

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?