How do I delete alternating rows in excel
I have over 5,000 rows of data. I only need the odd number rows (1,3,5) and
need to delete the even rows. Is there a faster way then hold CTRL and
clicking on even number rows and then deleting? How can select all the even
number of rows and then delete all?
|