Selectively deleting rows

D

Del

I have a long list of data in two columns and i want to delete each alternate cell to reduce the amount of data. i.e delete cells A3,A5,A7,A9.........A30507 etc. How to i do this without using CTRL + CLICK on mouse and selecting each cell/row manually?
 
J

JE McGimpsey

One way without a macro:

Enter in a third column:

C1: 1

leave C2 blank.


copy C1:C2 down to C30507

Choose Data/Filter/AutoFilter. In the C1 dropdown choose "Show Blanks"
or "Show Non-blanks", depending on which rows to delete. Choose
Edit/Goto/Special, Check the Visible Cells only. Choose Edit/Delete Row.
 
Top