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?
|