I WANT TO DELETE A WIDE OF DATE IN A EXCEL FILE

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Deleting extra rows in Excel 07 2
EXCEL hangs when deleting large blocks of data 2
How to delete Blank lines in excel workbook? 2
MS Excel Filters 1
Excel Macro for deleting Rows containing dates greater than "today" 0
reduce excel file size by deleting blank rows and columns?? 4
How do I delete alternating rows in excel 4
Allowing row deletion in worksheet with locked cells 2

Back
Top