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!
@85MA
8 ай бұрын
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
@kostasbatzanis9896
Жыл бұрын
Excellent video. Is there any similar procedure to select every other column?
@scottwall8887
Жыл бұрын
Very helpful. Your instruction is easily understood. Thanks for your videos!
@VBASqlAccessPowerApps
Жыл бұрын
sure
@kalalramulugoud7494
Жыл бұрын
Thank you sir ❤
@sanithaprakashps9548
6 ай бұрын
Thank you......its really helpful.....
@trumpexcel
6 ай бұрын
Glad to hear that
@Allmec
Жыл бұрын
I’d go for conditional formatting and use int(row()/2)=row()/2 and format where true to grey
@trumpexcel
Жыл бұрын
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)
@chathuraganasuru7796
5 ай бұрын
Thank you sir
@rushabh191187
Жыл бұрын
Thanks for your valuable info. Will surely save a lot of time & effort.
@aio4128
Жыл бұрын
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!
@mounikau3469
10 ай бұрын
Really helpful, thank you so much
@gurningbadger1
3 ай бұрын
Very nice!
@osmansafi1972
10 ай бұрын
In my case it only selects 114 of maximum rows my data set has more rows. any one can help
@HelloMadrasTV
11 ай бұрын
Superb Genius Idea U R Greatttttttttttttt
@elaineh9432
7 ай бұрын
So helpful! Thank you so much!
@Jay-qx8ms
8 ай бұрын
SO MUCH HELP!!! THANK YOU
@nadermounir8228
Жыл бұрын
Nice video especially the VBA solution
@trumpexcel
Жыл бұрын
Thanks... Glad you found the video useful :)
@IvanCortinas_ES
Жыл бұрын
Great tutorial. Thank you Sumit!!!
@trumpexcel
Жыл бұрын
Thanks Ivan... Good to see you in the comments section. Glad you liked the video
@Satwant2463
Жыл бұрын
Thx. Very useful.
@krishnakulkarni8816
Жыл бұрын
after clicking run in basic visual it shows Macro name what to add there?
@osmansafi1972
10 ай бұрын
great video
@ankitagarwal9533
Жыл бұрын
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
@rajeshg6076
Жыл бұрын
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
@VBASqlAccessPowerApps
Жыл бұрын
we can achieve this an offset function
@NiteshYadav-yz2ki
Жыл бұрын
how can we learn to make the code for VBA method?
@nitinagrawal3205
Жыл бұрын
Which version of office are you using?
@VBASqlAccessPowerApps
Жыл бұрын
I think he is using office 2019 the latest one
@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.
@mounikau3469
10 ай бұрын
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
@AqilAzizpondok
Жыл бұрын
amazing
@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: ✅ 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
@ankitagarwal9533
Жыл бұрын
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
@davidlorn5348
Жыл бұрын
where is the code, please?
@trumpexcel
Жыл бұрын
My bad... I forgot to add it in the description. Have added it now
Пікірлер: 42