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

In this video, I will show you three easy ways to select every other row in your dataset in Excel. Whether you're working with a large data set or you just want to quickly select specific rows, these techniques will save you time and effort.

00:00 Intro
00:18 Select Every Other Row Manually
01:20 Select Every Other Row Using Helper Column and Filter
03:35 Select Every Other Row Using VBA

------------------------------------------------------------------------------------------------------------------------------------
Below is the VBA Code used in this video:

Sub SelectEveryOtherRow()

Dim MyRange As Range
Dim RowSelect As Range
Dim i As Integer
Set MyRange = Selection
Set RowSelect = MyRange.Rows(3)
For i = 3 To MyRange.Rows.Count Step 2
Set RowSelect = Union(RowSelect, MyRange.Rows(i))
Next i
Application.Goto RowSelect
End Sub

------------------------------------------------------------------------------------------------------------------------------------

If you've ever struggled with selecting every other row in Excel, this video is for you! So grab a cup of coffee and join us as we explore the world of Excel data management.

#Excel #ExcelTips #ExcelTutorial

[rushabh]

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

[scottwall]

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

[aio]

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!

[trumpexcel]

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:

[kostasbatzanis]

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

[nadermounir]

Nice video especially the VBA solution

[Pronellyllon]

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!

[MA]

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

[Allmec]

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

[jayeshsuthar]

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.

[rajeshg]

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

[NiteshYadav-yzki]

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

[krishnakulkarni]

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

[VBASqlAccessPowerApps]

we can achieve this an offset function

[ankitagarwal]

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

[osmansafi]

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

[nitinagrawal]

Which version of office are you using?