3 Easy Ways to Select Every Other Row in Excel (Select Alternate Rows)
Вставка
- Опубліковано 16 лип 2024
- ☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - 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 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) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-c...
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
✅ Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: ua-cam.com/users/trumpexc...
#Excel #ExcelTips #ExcelTutorial
Very helpful. Your instruction is easily understood. Thanks for your videos!
sure
Thanks for your valuable info. Will surely save a lot of time & effort.
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!
So helpful! Thank you so much!
SO MUCH HELP!!! THANK YOU
Really helpful, thank you so much
Great tutorial. Thank you Sumit!!!
Thanks Ivan... Good to see you in the comments section. Glad you liked the video
Thx. Very useful.
Excellent video. Is there any similar procedure to select every other column?
Thank you sir ❤
Thank you......its really helpful.....
Glad to hear that
Very nice!
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
Thank you sir
Nice video especially the VBA solution
Thanks... Glad you found the video useful :)
great video
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!
amazing
I’d go for conditional formatting and use int(row()/2)=row()/2 and format where true to grey
Great tip David. This video is more about selecting the alternate rows (which can be useful when you want to do other stuff apart from highlighting them, such as copying or deleting)
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
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
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
we can achieve this an offset function
how can we learn to make the code for VBA method?
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
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.
u can enter in third column like below which is next to those columns
= select data in frst column's cell = select data in second column's cell
it will show true if both the values match
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?
I think he is using office 2019 the latest one
I want to join classes on daily basis
where is the code, please?
My bad... I forgot to add it in the description. Have added it now
I need a certificate Sumit
What about column