3 Easy Ways to Select Every Other Row in Excel (Select Alternate Rows) 

If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos. Also, I have made all of my Excel courses available for free. You can check these out using the below links: ✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/ ✅ Free Dashboard Course - bit.ly/free-excel-dashboard-course ✅ Free VBA course - bit.ly/excel-vba-course ✅ Free Power Query Course - bit.ly/power-query-course

Very helpful. Your instruction is easily understood. Thanks for your videos!

SO MUCH HELP!!! THANK YOU

So helpful! Thank you so much!

Thank you......its really helpful.....

Thank you sir ❤

Thanks for your valuable info. Will surely save a lot of time & effort.

Really helpful, thank you so much

Great tutorial. Thank you Sumit!!!

Very nice!

Thx. Very useful.

What about the fourth option of using conditional formatting? You can use the second method as a conditional format. This way, even sorting will not mess up your rows. Adding a row above it will make you have to chance isodd formula into iseven though… Anyways, thank you for the video!

Thank you sir

Nice video especially the VBA solution

Excellent video. Is there any similar procedure to select every other column?

great video

It was amazing to learn with you. Thanks for helping us learn! I have a scenario where I have data in Column B2 to H2 and Row 2 to Row 10. I want to highlight every 4th row, but I don't want to highlight the entire 4th row, only from Column D2 to F2. Is it possible to highlight in this way? The thing to remember is that the data is in Excel worksheet not in table

Superb Genius Idea U R Greatttttttttttttt

Hello Sumit...great job! Thank you for the great tips and lessons I've learnt from your channel. Just curious ..... Would you someday have a playlist grouped for Power BI? I would love to listen to your lessons on Power Bi as you teach in a very concise and easily understandable manner. Thank you!

I’d go for conditional formatting and use int(row()/2)=row()/2 and format where true to grey

amazing

we can achieve this an offset function

Hey, i have a query, i have two columns with different different amount in 100+ rows and i have to manually check for all the possible combination of one to one or one to many to match the amounts. I am doing it manually from past 1 year, is there any way to do it quickly in Excel without manual efforts? Thanks in advance.

Bro please help me. Im having 5 million rows data of 4 years in multiple books and when I try to add it in to data model in power query it will take long time and application closes itself. Based on research and advice i have converted the files in to CSV then added to data model. it's loaded but in few columns data showing wrong means in between few rows data interchanged and data is missing in few columns in between but orginal CSV is correct only there is no interchange or blank rows

after clicking run in basic visual it shows Macro name what to add there?

When i create new Excel file on desktop by right click on new context menu .. how to set it to create a .xlsb file instead of .xlsx file??? Please help

I want to join classes on daily basis

In my case it only selects 114 of maximum rows my data set has more rows. any one can help

Which version of office are you using?

how can we learn to make the code for VBA method?

where is the code, please?

I need a certificate Sumit

What about column