☕ 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