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

[@marksatterfield3100]

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

[@rd44457]

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

[@NurtureTechAcademy]

Glad it was helpful!

[@775shahrukh]

beautiful style of teaching...more excel plz

[@marli1315]

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

[@mohtashimu]

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

[@User-zw6vf]

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

[@esmspv198]

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

[@dileshwardas7027]

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

[@yurikomelgarejo2151]

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

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

[@farisal-amer7635]

Excellent video and very well explained. Thank you sir.

[@amratbhaipadhiar9511]

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

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

[@GlobalMindsInternational-ou9tz]

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

[@AbdulHameed-iq4hs]

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

[@lhabtshering3962]

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

[@boubacaramaiga4408]

Great tutorial, many thanks.

[@sudhirsamueltoppo7576]

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

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

[@bkrahulprasadsingh]

This is help ful thankyou so much

[@dannygrio]

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

[@shivakhatik3698]

THANKS FOR TEACHING

[@iqbal797]

Great information sir ☺️

[@manimaran7518]

Thanks for detailed explanation..

[@SVR_Properties]

Nice Explanation

[@coollife4471]

Thanks a lot, explained very well Pakistan

[@roshanmandal4874]

Thanks for your help it’s really helpful for me

[@Bansivlogss]

Thanks its being help full quickly

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

[@RahulKumar-nx9cy]

Thanks sir...very simple

[@RISERBILL]

Great work 👍

[@masterboxxx]

great tips , thanks

[@Fulfillment2024]

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

[@rohitshepherd8141]

I am from India very nice video countiue

[@mohammadahsanqureshi5509]

Wow Super Very Nice sir

[@PARVAIZ95]

Excellent sir

[@Killamano034]

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

[@AnthonyHarris-fe6zo]

Excellent video and explanation. Thank you!

[@Vxyz.official]

great video - exactly the solution I was looking for

[@jaswanthvadali4065]

It is very useful tq ....

[@rajcomputertiloi3080]

Thanku so much sir very good video

[@polohaslove3110]

thank you very much my friend

[@arkabratakundu862]

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

[@NurtureTechAcademy]

Thanks a lot

[@uzirali7826]

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

[@INSURANCESIDDHIVINAYAKA]

GOOD INFORMATION

[@minaezzat6261]

Great .. Thank you

[@chiranjitsamanta9953]

Lots of thanks

[@hemantabandara1122]

Thanks. You saved my day

[@excelemployeeleavetracker1274]

Very good video...thank you!

[@supriyaj7032]

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

[@AjayMaurya-yd9zm]

Thank u i was facing same difficult .

[@Bharat_Madireddi]

very useful to me.

[@nagrajrao1376]

It helped me in time saving 👍

[@anpk84]

Thank you very much

[@ritikakamboj9920]

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

[@NurtureTechAcademy]

Glad it helped

[@jsiva8577]

Awsome and Thank u so much 👍👌

[@azman73681]

Very good. Tqvm

[@madodomzimadikizela5116]

You are a superstar

[@bharatthiyam4843]

Thanks a lot🎉

[@jaisivbhole7773]

Good going❤

[@988222483]

Thanks a ton!

[@timetothunder4393]

Thank you so much for this solve!

[@priyanayak3715]

so helpful. Thanks a lot.

[@sheikabdullahmohamed1465]

Great thanks

[@sureshnagwan7805]

Good video 👍

[@deanm1681]

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

[@shwetaagarwal8224]

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

[@ubaidqasim1252]

Great Sir Specially Way of Teaching and voice amazing

[@NurtureTechAcademy]

Thanks Ubaid :)

[@TheMoonLitGirl]

please tell the same things for pasting
for eg we want to paste in filtered data, how to paste?

[@yemensport1997]

Deep thanks from #Yemen

[@aumeereza3416]

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

[@NurtureTechAcademy]

You are most welcome

[@Sajin2484]

Tnx.really helpful

[@samerbabikir8946]

Many thanks

[@srijarock7185]

Thank u it's really helpful

[@fsfamous5657]

hi, How to copy from filter data and paste even in filtered sheet.

[@terryw5656]

Worked Great!! Thanks so much!!

[@NurtureTechAcademy]

Thanks Terry :)

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

[@yaminichouhancs]

Thank you sir

[@AAMIRFAN1]

Bohat zaroorat thi es ki

[@sherwinmarkdevdas]

Very helpfull

[@alibusaleh789]

It’s an amazing solution.. thank you

[@imperialinternationalschoo8124]

Grateful thanks ...

[@mehardanish4374]

If i need to paste something in same cell, i mean changing some information only to filtered cells so how to copy paste

[@livinginsacramentocalifornia]

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.

[@dailyreadquran4887]

اسالام علیکم سر آپ کیسے ہیں

[@sairohini3272]

Thank you guru...

[@VeereshDammur]

what if you have to paste in the filtered rows of the new worksheet? how do we do that?

[@geographicalkd5673]

thanks sir for this informative video

[@NurtureTechAcademy]

Most welcome

[@rishabhkaushal8206]

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.

[@michalroesler]

Yes. Very good.

[@David-ku7mt]

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]

hey i know its very late but have u found a solution for it?

[@David-ku7mt]

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

[@bmohsecretarybhfws705]

Thank you sir..

[@bhabanimalla5431]

Thank you.. solved the problem

[@NurtureTechAcademy]

Please Like & Subscribe.

[@koyazhini1278]

Superb

[@bidhan0001]

what is the short cut key for this?

[@alberrhoshi405]

Thank you very much 😭😭😭

[@ViralVideoToday]

What if do you want to paste it on the same row as per the 1st sheet?