Thank you, thank you, thank you!!! This is exactly what I was looking for!!! I had thousands of rows with blanks in between each cell that I needed to autofill down and you saved me hours of work!
You are a real brahmin, an excellent teacher. Straight to the point and exactly what I needed to know with no time wasted on ego stuff. Thank you, thank you, thank you. Truly excellent.
I have been watching and following your tutorial since subscription which are great for excel. God 🙏 bless you. I hope you will get million subscribers soon.
This is so helpful, i happen to do this every week and was using ctrl+d for each set of cells. this will really save atleast 1 hour per week....Thanks a lot
Hi Sumit, Excellent presentations. I enjoy these very much although I do not work with EXCEL as much as I did in the past. Very clear and informative. Thanks for your efforts.
This was very good video. HOwever, when I tried to use Power Query to fill down the cell but the blank cells were not 'Null' but "error'. Do you know how to address this? Many thanks.
Nice. But how to remove filled data back to original. (Or) you will tell how to fill I need how remove like that data. Please help me best option for this
Hi! I need your help. I created a button counter... I placed the activeX button on column C and everytime I click the button it will +1 value to column b. Now its working perfectly fine Now I have several buttons setup in the sheet and what I want to happen is the cell (column b)to highlight each time I click the button and adds a value.
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
@@wasilmufrat1728 Have a full VBA course as well. Here are links to all my courses (available on UA-cam): ✅ 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
hi Sumit, I love your content, it's very helpful. I'd need help, though no idea where to find. I have multiple words in cells in one column. i have to find unique words and put them in one column. usually i do text-to-column and copy them into one column and removed duplicate. is there any easier way, do you have any material on this? thanks a lot, Reka
@@zohurulislam7628 A1 orange apple kiwi A2 lkjfdlsd pear apple A3 blueberry acai apple A4 none A5 pear same concept, much more text per cell, all in one column after text to column they spread out and then I have to put them back into one column B1 orange C1 apple D1 kiwi B2 lkjfdlsd C2 pear D2 apple B3 blueberry C3 acai D3 apple B4 none B5 pear so i need help to break the words into separate cells and line them into one column thanks a lot!
Very nice video. Such coaching should be done at the school level.
Best wishes from Mumbai.
Thank you, thank you, thank you!!! This is exactly what I was looking for!!! I had thousands of rows with blanks in between each cell that I needed to autofill down and you saved me hours of work!
Thank you for this!
I have been looking for it earlier!
SUBSCRIBED!❤
You are a real brahmin, an excellent teacher. Straight to the point and exactly what I needed to know with no time wasted on ego stuff. Thank you, thank you, thank you. Truly excellent.
I have been watching and following your tutorial since subscription which are great for excel. God 🙏 bless you. I hope you will get million subscribers soon.
Thanks a lot
You saved my life today with that trick. Very thank you.
This is so helpful, i happen to do this every week and was using ctrl+d for each set of cells. this will really save atleast 1 hour per week....Thanks a lot
This is really cool way to work in excel
Brilliant THANKS!
Thanks for this tutorial.
Was using Goto... Since long..
But from now, VBA code would be superhandy ..
Thank you once again for sharing 🥂.🤘
I am highly of your opinion
Hi Sumit. Great to see a couple of ways of solving that problem! Thanks for sharing :)) Thumbs up!!
Thanks for your help. I did it effortlessly. Thankyou so much! Keep up the good work! 💪👍🏻
Thank you very much.
Thanks! Mate - this so helpful in data sanitisation you saved hours of mine.
OMG!! THIS IS what I have been looking for!!! THANK YOU !!!
very helpfull techniques
Love all of them, Power Query is my favorite.
Great video and thanks for getting right into the meat of the issue!
Thanks, I need more on how to do in online excel.
Hi Sumit, this is so easy , Thank you so much for sharing.
Hi Sumit, Excellent presentations. I enjoy these very much although I do not work with EXCEL as much as I did in the past. Very clear and informative. Thanks for your efforts.
Thanks for commenting Christie... Glad you found the video useful!
woow very important. thanks
thank you very much!
It's very informative and explained very clearly
Thank you Sumit. I enjoy your tutorials 😊
Thanks for commenting Nader... Glad you found the video useful!
Great tutorial Sumit! Thank you for your explanation!
Thanks for commenting Iván... Glad you found the video useful!
Thanks, that really helped me out today!
Very good information thanks
Thanks for commenting... Glad you found the video useful!
Thank you.
Very nice video. Very effective code for this purpose. Thank you so much
Very Interseting & simple
Thank you. It helped me a lot today
Thank you so much...this is very useful.
Nice learning 👍
Thank you! very helpful
Very good explanation 👍
Thank you so much this was amazing!
You're amazing! A power house of Excel knowledge. Thank you.
This simply Excellent
Very Nice,
Very useful
Hi Sumit,
Thanks for sharing, it was really helpful.
Subscibed and Thumbs up 👍
thanks! I really like your videos
Perfect
Amazing!
Very useful lecture.
Thank you sir.
Nice sir
I liked power query method
Awesome
And we can also do a simple step by just copy the cell and then paste it into the cells below by selecting with Ctrl + shift + ⬇️ key.
Super
Can you save that "VBA" code as an add-in... Or is that something different to a macro?
Ver helpful.... For something I come across quite often....
Awsome!
Nice
This was very good video. HOwever, when I tried to use Power Query to fill down the cell but the blank cells were not 'Null' but "error'. Do you know how to address this? Many thanks.
you can also open go to dialog box by pressing ctrl + g.
Thanks for sharing . Can you pls share link for tutorials on power query
Thanks Shalabh... I have the link of the Free Power Query course in the description. Will put the link here when back on my system
Hi Sumit. Do you have a tutorial on how to use the IF OR Function?
PLZ INFORM HOW TO CHANGE EXCEL SETTING FOR GO TO LINKED CELL DESTINATION BY USING MOUSE SINGLE CLICK INSTEAD OF USING KEY BOARD SHORT CUT CTRL+[ .
Nice. But how to remove filled data back to original. (Or) you will tell how to fill I need how remove like that data. Please help me best option for this
Hi! I need your help.
I created a button counter...
I placed the activeX button on column C and everytime I click the button it will +1 value to column b. Now its working perfectly fine
Now I have several buttons setup in the sheet and what I want to happen is the cell (column b)to highlight each time I click the button and adds a value.
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
dude could you please do more improvised complex formulas and power queries please?
Yeah... Planning to create more formula videos. I also have a full Power Query course as a playlist that you can check out
@@trumpexcel how about a full VBA tutorial? like the way you explain with ease
@@wasilmufrat1728 Have a full VBA course as well. Here are links to all my courses (available on UA-cam):
✅ 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
@@trumpexcel thanks bro
Loan pay back optimizer format can be available in excel?
Multiple loan repayment plan ? Pl share excel file
Multiple person how can maintenance?
hi Sumit, I love your content, it's very helpful. I'd need help, though no idea where to find. I have multiple words in cells in one column. i have to find unique words and put them in one column. usually i do text-to-column and copy them into one column and removed duplicate. is there any easier way, do you have any material on this? thanks a lot, Reka
Need data
@@zohurulislam7628 A1 orange apple kiwi A2 lkjfdlsd pear apple A3 blueberry acai apple A4 none A5 pear
same concept, much more text per cell, all in one column
after text to column they spread out and then I have to put them back into one column B1 orange C1 apple D1 kiwi B2 lkjfdlsd C2 pear D2 apple B3 blueberry C3 acai D3 apple B4 none B5 pear
so i need help to break the words into separate cells and line them into one column
thanks a lot!
How can we connect for 1 on 1 discussion??
i used the first way to fill but after pressing ctr+enter i getting error of =b7 ...can you explian me
Thanks all
How can I say? Really very useful
Glad you found the video useful!
I want to change the last 2 digit in a coloumn 12345
12356 like this in a columns
I am getting error as 'No cells were found'
You are using Excel 365 ?
Yes
👍
Bro it's not working on my file.
Not working
Hi Sumit, i have a query sent you a mail.
Replied to the email
@@trumpexcel Thanks Sumit shared in mail
I have some query could you please solve it.
Just share your mail Id so that I may send there my query Please.
Thank you!
Super
Glad you found the video useful!