How to Copy Filtered Data Without Hidden Rows In Microsoft Excel

👉 FREE Excel Course. ENROLL NOW learn-with-lok...
In this video series you will learn the common problem when we copy filtered data
Works with Excel 2003, 2007, 2010, 2013, 2016 for Windows.
For Practice Files: learn-with-lok...
For Corporate training Queries - [e-mail]
Website: www.nurturetec...
Facebook: / nurturetechacademy

[@NurtureTechAcademy]

Learn Excel from my in-depth course: learn-with-lokesh-lalwani.thinkific.com/courses/Excel-Masterclass 🔥🔥

[@ichamatitales9459]

Thank you

[@LiteDuniya]

ösûm video sir

[@mohtashimu]

For visible cells selection Alt + ; For copy Ctrl + C For paste Ctrl + V

[@impooja_pm]

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]

Thank you, Pooja for your valuable comment.

[@marksatterfield3100]

Thank you! Thank you! Thank you! I have been banging my head trying to figure out how to do this! Bless you Sir!

[@775shahrukh]

beautiful style of teaching...more excel plz

[@rd44457]

Crystal Clear. Perfect explanation. Couldn't be better. THANKS! ✨

[@NurtureTechAcademy]

Glad it was helpful!

[@yurikomelgarejo2151]

Aahhh THANK YOU SO MUCH for this video!! Literally EXACTLY what I was hoping to find on KZbin!!

[@dileshwardas7027]

Thank you very much because after watching this video I could copy past with filtered data .. Really impressed .

[@gopiprathi1327]

Alt+; we can use this intesad of go to special

[@quddusabdul5769]

@@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

[@User-zw6vf]

Sir U made my day. I m grateful for solution. One more thing , Explain way is so impressive n short speech

[@marli1315]

Thank you so much for this lesson. I helped me save so much time in my job.

[@esmspv198]

Wow I tried this and done successfully. Thank you sir. and I liked and subscribed.

[@simonkamau32]

Excellent explanation! Thank you, I needed to learn that 🙂

[@zenith19891]

I can't tell you how thankful I am right now. You are the best 💓

[@AbdulHameed-iq4hs]

Excellent video. I was struggling. But now your video made me easy. Thank you very much. Go ahead.

[@bansivibes8991]

Thanks its being help full quickly

[@GlobalMindsInternational-ou9tz]

Thanks a lot. What a great solution in a simple way. Thanks again

[@bkrahulprasadsingh]

This is help ful thankyou so much

[@farisal-amer7635]

Excellent video and very well explained. Thank you sir.

[@shivakhatik3698]

THANKS FOR TEACHING

[@dannygrio]

Thank you very much. This was the simplest video about this.

[@coollife4471]

Thanks a lot, explained very well Pakistan

[@RahulKumar-nx9cy]

Thanks sir...very simple

[@Vxyz.official]

great video - exactly the solution I was looking for

[@polohaslove3110]

thank you very much my friend

[@sudhirsamueltoppo7576]

Thanks alot, really helpful...please give such more tricks...

[@rajcomputertiloi3080]

Thanku so much sir very good video

[@Fulfillment2024]

You save my life!! Thank you so much...🙏🙏🙏🙏🙏🙏

[@lhabtshering3962]

so simple and understandable . Sir can u please sho us how to count the selected item in excel after filter

[@roshanmandal4874]

Thanks for your help it’s really helpful for me

[@masterboxxx]

great tips , thanks

[@SVR_Properties]

Nice Explanation

[@mohammadahsanqureshi5509]

Wow Super Very Nice sir

[@UShruPra]

Thank you so much for this video😊😊

[@Diva9000x]

Thank you so much for this information. I almost had it figured out. You cleared up the one thing I was doing wrong.

[@NurtureTechAcademy]

We are happy to help you. Regards Nurture Tech Academy www.nurturetechacademy.in

[@manimaran7518]

Thanks for detailed explanation..

[@arkabratakundu862]

Thanks a lot!! Was searching the solution for years, now clearly understood the process.

[@NurtureTechAcademy]

Thanks a lot

[@anpk84]

Thank you very much

[@jaswanthvadali4065]

It is very useful tq ....

[@amratbhaipadhiar9511]

Sir,Very good Skil,I was in sirch of this idea.

[@supriyaj7032]

Yess it worked properly...Thank you so much 🙏🏻

[@PARVAIZ95]

Excellent sir

[@Bharat_Madireddi]

very useful to me.

[@ritikakamboj9920]

thanks a lot sir. Searching for it and here I got the easy solution to This.

[@NurtureTechAcademy]

Glad it helped

[@sheikabdullahmohamed1465]

Great thanks

[@chiranjitsamanta9953]

Lots of thanks

[@minaezzat6261]

Great .. Thank you

[@Killamano034]

Thanks man. This will make my work much easier now🙂. I have subscribed to your channel by the way

[@uzirali7826]

Thank you so much,,I have been scarching such a thing.

[@AnthonyHarris-fe6zo]

Excellent video and explanation. Thank you!

[@samerbabikir8946]

Many thanks

[@azman73681]

Very good. Tqvm

[@user-ct2kr4zn2y]

GOOD INFORMATION

[@boubacaramaiga4408]

Great tutorial, many thanks.

[@RISERBILL]

Great work 👍

[@bharatthiyam4843]

Thanks a lot🎉

[@aumeereza3416]

Thanks a lot, your suggestions have just solved my problem.

[@NurtureTechAcademy]

You are most welcome

[@shwetaagarwal8224]

Thank you so much I was actually struggling with this issue Thanks👍👍

[@988222483]

Thanks a ton!

[@Sajin2484]

Tnx.really helpful

[@michalroesler]

Yes. Very good.

[@atanughoshal6]

Thank you Sir

[@deanm1681]

Thank you so much for your lesson. It is exactly what I am doing at work. Dean AUstralia. PS your English is excellent

[@sherwinmarkdevdas]

Very helpfull

[@AjayMaurya-yd9zm]

Thank u i was facing same difficult .

[@rohitshepherd8141]

I am from India very nice video countiue

[@ubaidqasim1252]

Great Sir Specially Way of Teaching and voice amazing

[@NurtureTechAcademy]

Thanks Ubaid :)

[@sairohini3272]

Thank you guru...

[@hemantabandara1122]

Thanks. You saved my day

[@hiteshjindal7772]

Thanks

[@bmohsecretarybhfws705]

Thank you sir..

[@arunjosh6011]

Thank you

[@timetothunder4393]

Thank you so much for this solve!

[@madodomzimadikizela5116]

You are a superstar

[@imperialinternationalschoo8124]

Grateful thanks ...

[@sureshnagwan7805]

Good video 👍

[@alberrhoshi405]

Thank you very much 😭😭😭

[@nagrajrao1376]

It helped me in time saving 👍

[@bijaytanty8434]

Thanks Sir

[@iqbal797]

Great information sir ☺️

[@jaisivbhole7773]

Good going❤

[@koyazhini1278]

Superb

[@excelemployeeleavetracker1274]

Very good video...thank you!

[@vivekjaiswal6580]

Thanks bro

[@priyanayak3715]

so helpful. Thanks a lot.

[@srijarock7185]

Thank u it's really helpful

[@bhabanimalla5431]

Thank you.. solved the problem

[@NurtureTechAcademy]

Please Like & Subscribe.

[@terryw5656]

Worked Great!! Thanks so much!!

[@NurtureTechAcademy]

Thanks Terry :)

[@rajukatti6808]

Thnku

[@geographicalkd5673]

thanks sir for this informative video

[@NurtureTechAcademy]

Most welcome

[@MAHIDRH]

Super trick

[@jsiva8577]

Awsome and Thank u so much 👍👌

[@gopalkrishna7092]

Thank u

[@poojaparmaar1111]

Thnku sir today i faced this problm

[@vivianlai8994]

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.

[@mariaentraber8573]

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.

[@yemensport1997]

Deep thanks from #Yemen

[@TWA698]

Thank you so much sir

[@AAMIRFAN1]

Bohat zaroorat thi es ki

[@alibusaleh789]

It’s an amazing solution.. thank you