Learn Excel from my in-depth course: learn-with-lokesh-lalwani.thinkific.com/courses/Excel-Masterclass 🔥🔥
@ichamatitales9459
3 жыл бұрын
Thank you
@LiteDuniya
3 жыл бұрын
ösûm video sir
@mohtashimu
2 жыл бұрын
For visible cells selection Alt + ; For copy Ctrl + C For paste Ctrl + V
@marksatterfield3100
2 жыл бұрын
Thank you! Thank you! Thank you! I have been banging my head trying to figure out how to do this! Bless you Sir!
@User-zw6vf
2 жыл бұрын
Sir U made my day. I m grateful for solution. One more thing , Explain way is so impressive n short speech
@rd44457
4 жыл бұрын
Crystal Clear. Perfect explanation. Couldn't be better. THANKS! ✨
@NurtureTechAcademy
4 жыл бұрын
Glad it was helpful!
@dileshwardas7027
3 жыл бұрын
Thank you very much because after watching this video I could copy past with filtered data .. Really impressed .
@lhabtshering3962
2 жыл бұрын
so simple and understandable . Sir can u please sho us how to count the selected item in excel after filter
@esmspv198
Жыл бұрын
Wow I tried this and done successfully. Thank you sir. and I liked and subscribed.
@775shahrukh
4 ай бұрын
beautiful style of teaching...more excel plz
@marli1315
9 ай бұрын
Thank you so much for this lesson. I helped me save so much time in my job.
@impooja_pm
5 жыл бұрын
This was miracle for my side because sir today's hole day was waste applying filter and copy paste data .. when I paste filter data i saw the hole sheet was paste without filter this was so so annoying sir .. and your solution was truly truly 1 no. Thank so so much
@NurtureTechAcademy
5 жыл бұрын
Thank you, Pooja for your valuable comment.
@AbdulHameed-iq4hs
3 жыл бұрын
Excellent video. I was struggling. But now your video made me easy. Thank you very much. Go ahead.
@yurikomelgarejo2151
3 жыл бұрын
Aahhh THANK YOU SO MUCH for this video!! Literally EXACTLY what I was hoping to find on KZitem!!
@NurtureTechAcademy
4 жыл бұрын
Hi Guys, I am glad you like this video. Request you to please subscribe to our channel !!!
@zenith19891
3 жыл бұрын
I can't tell you how thankful I am right now. You are the best 💓
@farisal-amer7635
Жыл бұрын
Excellent video and very well explained. Thank you sir.
@simonkamau32
2 жыл бұрын
Excellent explanation! Thank you, I needed to learn that 🙂
@vivianlai8994
3 жыл бұрын
Thank you so much! I was really struggling with this issue. However I realised that this only works for copying datas from unfiltered cells and pasting the copied datas to filtered cells. It does not work when I tried to copy datas from filtered cells and paste the copied datas to filtered cells. Please advise?? Many thanks.
@GlobalMindsInternational-ou9tz
9 ай бұрын
Thanks a lot. What a great solution in a simple way. Thanks again
@rishabhkaushal8206
3 жыл бұрын
Dear sir, I have an query that when I am using only visable cell so it's not show that type or white line and not select only visable cell so what I do can you guide me.
@Killamano034
2 жыл бұрын
Thanks man. This will make my work much easier now🙂. I have subscribed to your channel by the way
@livinginsacramentocalifornia
3 жыл бұрын
Is there a way to set a permanent action for the filtered data to continue copying in the new sheet? I'd like the new sheet to continue copying the new data as I continue to add it in the first sheet. For example, if you kept adding more "North" categorized data, I would want to new sheet to also copy this data since my first sheet will continue to be a working sheet.
@David-ku7mt
3 жыл бұрын
Hi there, thanks for the video! Is that also possible the other way around? Let's say I copy 200 rows of filtered data (visible cells only) and I want to paste these rows into another sheet of filtered data. There are exactly 200 empty cells in the given column that consists of e.g. 1000 cells, yet I face the problem that the copied cells are pasted in the first 200 rows. Is there an add-in or some trick I could use to paste the copied data into the empty cells? I'd be grateful if you gave me a hint. Cheers!
@salimdiab4703
2 жыл бұрын
hey i know its very late but have u found a solution for it?
@David-ku7mt
2 жыл бұрын
@@salimdiab4703 Hi there, unfortunately, I did not or cannot recall it. :( Sorry!
@MaazKhan-dw5ll
Жыл бұрын
I am also looking the same thing but not able to find any solution yet
@mariaentraber8573
4 жыл бұрын
However if there are 30k-50k filtered rows you need to copy or cut and you use visible cells only option it takes time, like 10-20mins. Is there another way to do it without wait time? Your help is much appreciated.
@yourherohere
2 жыл бұрын
Hi, am trying average some number from visible cells only but its calculate all the cell. Any solution for the same. I saw some video about sumtotal but, whenever I add new row which is not comes automatically as whole group. sumtotal is taken values from defined ranges only . For example, last row is 10 and calculated till 10th row, then adding 11 row with data but my sumtotal only calculate till 10 row. Please provide the suggestion.
@amratbhaipadhiar9511
3 жыл бұрын
Sir,Very good Skil,I was in sirch of this idea.
@gopiprathi1327
5 жыл бұрын
Alt+; we can use this intesad of go to special
@quddusabdul5769
4 жыл бұрын
@@RR-ey6hc if not worked out yet then yes you are right... First, select the whole range of the filtered list and then press Alt+; ("Alt and ;" together no need to press the +)
@MaazKhan-dw5ll
Жыл бұрын
What if I take some data from this filter sheet and apply on second sheet where filter is already applied, then only few is paste, Do you have any idea
@sudhirsamueltoppo7576
3 жыл бұрын
Thanks alot, really helpful...please give such more tricks...
@TheMoonLitGirl
4 жыл бұрын
please tell the same things for pasting for eg we want to paste in filtered data, how to paste?
@dannygrio
3 жыл бұрын
Thank you very much. This was the simplest video about this.
@roshanmandal4874
3 жыл бұрын
Thanks for your help it’s really helpful for me
@mehardanish4374
3 жыл бұрын
If i need to paste something in same cell, i mean changing some information only to filtered cells so how to copy paste
@ViralVideoToday
2 жыл бұрын
What if do you want to paste it on the same row as per the 1st sheet?
@Fulfillment2024
3 жыл бұрын
You save my life!! Thank you so much...🙏🙏🙏🙏🙏🙏
@arkabratakundu862
5 жыл бұрын
Thanks a lot!! Was searching the solution for years, now clearly understood the process.
@NurtureTechAcademy
5 жыл бұрын
Thanks a lot
@Diva9000x
5 жыл бұрын
Thank you so much for this information. I almost had it figured out. You cleared up the one thing I was doing wrong.
@NurtureTechAcademy
5 жыл бұрын
We are happy to help you. Regards Nurture Tech Academy www.nurturetechacademy.in
@AnthonyHarris-fe6zo
3 жыл бұрын
Excellent video and explanation. Thank you!
@deanm1681
3 жыл бұрын
Thank you so much for your lesson. It is exactly what I am doing at work. Dean AUstralia. PS your English is excellent
@villayatsukheja8315
5 жыл бұрын
Sir it works , but my Q is how can we make this option visible data as default action
@boubacaramaiga4408
Жыл бұрын
Great tutorial, many thanks.
@fsfamous5657
3 жыл бұрын
hi, How to copy from filter data and paste even in filtered sheet.
@VeereshDammur
2 жыл бұрын
what if you have to paste in the filtered rows of the new worksheet? how do we do that?
@manimaran7518
3 жыл бұрын
Thanks for detailed explanation..
@ritikakamboj9920
4 жыл бұрын
thanks a lot sir. Searching for it and here I got the easy solution to This.
@NurtureTechAcademy
4 жыл бұрын
Glad it helped
@rohitshepherd8141
4 жыл бұрын
I am from India very nice video countiue
@ubaidqasim1252
4 жыл бұрын
Great Sir Specially Way of Teaching and voice amazing
@NurtureTechAcademy
4 жыл бұрын
Thanks Ubaid :)
@coollife4471
Жыл бұрын
Thanks a lot, explained very well Pakistan
@kaikalls5058
2 жыл бұрын
How to add these data to other data which has filter applied... I tried it but it does not work on other excel which has filer applied
@Vxyz.official
3 жыл бұрын
great video - exactly the solution I was looking for
@Bansivlogss
Жыл бұрын
Thanks its being help full quickly
@bkrahulprasadsingh
3 жыл бұрын
This is help ful thankyou so much
@bidhan0001
3 жыл бұрын
what is the short cut key for this?
@UShruPra
2 жыл бұрын
Thank you so much for this video😊😊
@supriyaj7032
3 жыл бұрын
Yess it worked properly...Thank you so much 🙏🏻
@ashish18oct
5 жыл бұрын
When I copy ... It's show msg ...(Cannot change part of a merged cell). . .
@piyushjain4349
2 жыл бұрын
What if second sheet is also having filter and we need to paste there
@uzirali7826
3 жыл бұрын
Thank you so much,,I have been scarching such a thing.
@aumeereza3416
4 жыл бұрын
Thanks a lot, your suggestions have just solved my problem.
@NurtureTechAcademy
4 жыл бұрын
You are most welcome
@iqbal797
2 жыл бұрын
Great information sir ☺️
@SVR_Properties
2 ай бұрын
Nice Explanation
@shivakhatik3698
2 жыл бұрын
THANKS FOR TEACHING
@dailyreadquran4887
4 жыл бұрын
اسالام علیکم سر آپ کیسے ہیں
@vijineshv.l7403
3 жыл бұрын
Am getting a error message command cannot be used on multilple section
@RahulKumar-nx9cy
2 жыл бұрын
Thanks sir...very simple
@shwetaagarwal8224
4 жыл бұрын
Thank you so much I was actually struggling with this issue Thanks👍👍
@rajcomputertiloi3080
5 ай бұрын
Thanku so much sir very good video
@AjayMaurya-yd9zm
4 жыл бұрын
Thank u i was facing same difficult .
@masterboxxx
Жыл бұрын
great tips , thanks
@mohammadahsanqureshi5509
3 жыл бұрын
Wow Super Very Nice sir
@RISERBILL
Жыл бұрын
Great work 👍
@nagrajrao1376
2 жыл бұрын
It helped me in time saving 👍
@excelemployeeleavetracker1274
3 жыл бұрын
Very good video...thank you!
@hemantabandara1122
3 жыл бұрын
Thanks. You saved my day
@jaswanthvadali4065
3 жыл бұрын
It is very useful tq ....
@PARVAIZ95
2 жыл бұрын
Excellent sir
@gkcnf7575
4 жыл бұрын
Please tell about, how to convert filtered cell formula into value without removing formula
@polohaslove3110
3 жыл бұрын
thank you very much my friend
@jsiva8577
3 жыл бұрын
Awsome and Thank u so much 👍👌
@ankurbatabyal
4 жыл бұрын
Your video works great but doesnt paste in another filtered sheet. How do I paste it in another filtered sheet?
@nathabhaidivraniya9859
3 жыл бұрын
Video admin pls reply the ans of the qtn asked by ankur batabyal
@timetothunder4393
3 жыл бұрын
Thank you so much for this solve!
@sharathb1103
3 жыл бұрын
Great video, but it would have been nicer if the video could have been less than 2 mins
@minaezzat6261
Жыл бұрын
Great .. Thank you
@Moh23Moh
5 жыл бұрын
I have a problem pasting data in filtered area , Excel pasts some of the copied cells Do you have a solution?
Пікірлер: 202