If you find my Excel videos useful and would like to support me, you can buy me a coffee – https://www.buymeacoffee.com/SumitB

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:

‘Code developed by Sumit Bansal from https://trumpexcel.com
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.

Free Excel Course (Basic to Advanced) – https://trumpexcel.com/learn-excel/
Free Dashboard Course – https://bit.ly/free-excel-dashboard-course
Free VBA course – https://bit.ly/excel-vba-course
Free Power Query Course – https://bit.ly/power-query-course
Best Excel Books: https://trumpexcel.com/best-excel-books/

Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexcel?sub_confirmation=1

#Excel #ExcelTips #ExcelTutorial

Please take the opportunity to connect and share this video with your friends and family if you find it useful.