How to delete alternate rows in Excel

I need to index 6 raws of my excel file. Do you know how to do it? It would bevery helpful!

Cheers.

It takes too much time. There are many other tricks to solve this

Very much helpful bro

Saved my lots of time sir. Thank you for this.

P.S.: Alternatively we can sort the "0101" column and can delete the unwanted rows which will be collected simultaneously :)

When I try to paste the 1 and 0, it only pastes to the next two rows and not the entire column.

Thank you - super helpful!

thank you buddy.

So excel has no command for this? So sad..lol

Thank you so much!

thank you sir

Even I was able to follow along and get it done. THANKS so VERY MUCH!!

When I go to paste the copied cells after highlighting the entire column using control+shift+down, it only pastes in the next 2 cells

What a trick! Thank you.

Man you Literally Saved me, Keep this Channel Up. One Love

Thanks man....searched this for long, no one could explain except u....Hats off

Very helpful

The video was helpful ,thanks man

Thank you sir..

thank you

Sir,
Thank you so much

Thanks man

thanks bro

Thank you sir

when I paste the 0 and 1 to the down, my excels stopped running

The entire data is being deleted, both 1 and 0