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

☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee –

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

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) –
✅ Free Dashboard Course –
✅ Free VBA course –
✅ Free Power Query Course –
✅ Best Excel Books:

Subscribe to get awesome Excel Tips every week:

#Excel #ExcelTips #ExcelTutorial

Watch more new videos about Excel Office | Synthesized by Mindovermetal English

Rate this post

Bài viết liên quan

Theo dõi
Thông báo của
Cũ nhất
Mới nhất Được bỏ phiếu nhiều nhất
Phản hồi nội tuyến
Xem tất cả bình luận
TZ Vlogs

Hi Sumit, I have one more trick, you can click anywhere in the data set and convert it to a table, which will make your rows coloured alternate, and now you can again convert that table to Range and then appy filter by color method.

Iván Cortinas

Great tutorial. Thank you Sumit!!!


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) – 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