How to copy and paste filtered data using FILL option in

#Excel
#CopyPasteinFilteredCell
bit.ly/2yQ8jcH - Click the link to know more
If you copy a range of cells that has hidden or filtered rows, Excel includes the hidden or filtered cells when you paste it comes somewhere else. If that’s not what you want, here’s how to paste the visible cells only using FILL option
Please subscribe for more informative videos
#Exceltipsandtricks
#microsoftexcel #exceltips #exceltricks #exceltutorial #filloptioninexcel #filtereddata #copy paste #techygyan #datafilterinexcel

[@1Teebrii]

I can't explain how excited I am that this worked! Been searching for this solution for literally years. Fantastic! Thank you

[@TechyGyan]

HI Christina, Happy to know.

[@TechyGyan]

if you don't mind, Please subscribe to my channel for more videos ☺️
ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg1

[@user-jc6te1vm8v]

but this won't work if you need to paste filtered cells to another sheet filtered table...

[@mhj9339]

Unfilter then paste special

[@anandkolanu7]

@@user-jc6te1vm8v

[@philthew1555]

Finally someone who understands the problem AND knows how to fix it

[@TechyGyan]

Thank you!

[@TechyGyan]

If you don't mind, please subscribe to my channel.
ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg?sub_confirmations=11

[@SathiSupport]

Very very useful and unique video in youtube

[@TechyGyan]

So nice of you

[@TechyGyan]

Please subscribe to my channel for more videos
ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg1

[@faltubakwas15]

This is the stuff I would pay for. Thank you so much it made my life so easy

[@TechyGyan]

Glad it helped!

[@chiragsharma460]

THANK YOU VERY MUCH SIR, I seen many VDO about filter cells copy & paste related. But You are only one & the best . Thank you very much again sir. I tried last 10 month to resolve this issue ... thank you very much sir

[@TechyGyan]

Happy to hear!.

[@TechyGyan]

If you don't mind, please subscribe to my channel.
ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg?sub_confirmations=11

[@dennthecorrector6478]

THANK YOU SO MUCH!
I'VE SEARCHED SO MANY CLIPS, BUT ONLY YOUR ONE IS TRULY HELPFUL!

[@TechyGyan]

Glad I could help!

[@TechyGyan]

If you don't mind, please subscribe to my channel.
ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg?sub_confirmations=11

[@justentertainment7390]

Very Helpful 👍👍

[@MasterMindManifestation]

Thanks so much! So simple and yet it has saved me so much time! Brilliant!

[@TechyGyan]

Glad it helped!

[@TrangNguyen-qq1id]

thank you so much 🤩, after a year of searching as well, finally someone can give the proper solution! To make it easy for everyone, Press Ctrl and select the range you want to copy => Select the range you want to Paste => Fill options

[@pretty5710]

Thank you so much @TechyGyan Guru for making this video and resolving my issue.

[@TechyGyan]

😊

[@TechyGyan]

Please subscribe if you don’t mind
ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg?sub_confirmations=11

[@pretty5710]

@@TechyGyan Done

[@jekaterinasimpkin4416]

Perfect! It's the easiest way, thank you.

[@TechyGyan]

Your Welcome!

[@TechyGyan]

If you don't mind, please subscribe to my channel.
ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg?sub_confirmations=11

[@liamknott6665]

I love you sir. Iv been stuck on this for so long, thank you!

[@TechyGyan]

Glad I could help!

[@TechyGyan]

If you don't mind, please subscribe to my channel.
ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg?sub_confirmations=11

[@rajakvful]

Thank u so so much..no words..saved a huge time.....lots of love

[@TechyGyan]

Most welcome 😊

[@TechyGyan]

If you don't mind, please subscribe to my channel.
ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg?sub_confirmations=11

[@rajakvful]

@@TechyGyan done

[@DnyaneshwarArunShelar]

Thank you Brothers.....very helpful information

[@anujvyas4826]

Great very helpful 👍

[@TechyGyan]

Thank you

[@Hidyhahaha]

Want to say a big THANK YOU, save a lot of time and really useful!!!

[@TechyGyan]

Than you

[@TechyGyan]

If you don't mind, please subscribe to my channel.
ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg?sub_confirmations=11

[@sathyapriyak6162]

If it is a formula want to paste as value in filtered.. any possibility for that??

[@resellingtrendz9845]

Hi how can i paste data in filtered columns from other sheet or other files , pls share short cut , its very important to my work , now i am using v look up for getting data in filtered columns. TIA

[@zmakhshari]

Big Thank you man. Helped me a lot!

[@TechyGyan]

If you don't mind, please subscribe to my channel.
ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg?sub_confirmations=11

[@fernandamembrive5139]

Thanks for sharing this.

[@TechyGyan]

Your welcome

[@TechyGyan]

If you don't mind, please subscribe to my channel.
ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg?sub_confirmations=11

[@naajihah3036]

YOU ARE THE MOST AMAZING ONE!!!!!!!!!!!!!!!!!!!!!!!!!!

[@TechyGyan]

Thanks

[@MehediHasan098]

Excellent
Awesome
You are genius

[@TechyGyan]

Thank you so much 😀

[@TechyGyan]

ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg1

[@curioustreelife]

Brother you are a life saver 💖💖

[@TechyGyan]

If you don't mind, please subscribe to my channel.
ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg?sub_confirmations=11

[@suryakantsingh1348]

Amazing yar ...I was suffring this everyday ..But you solved it...love you man ...

[@TechyGyan]

Thank you

[@TechyGyan]

If you don't mind, please subscribe to my channel.
ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg?sub_confirmations=11

[@Islamic-Naats-n-Video-Channel]

Thank You Boss You are A Life Saver ❤❤❤❤❤❤

[@quynhcaongoc983]

Thank you very much for this very useful video

[@TechyGyan]

If you don't mind, please subscribe to my channel.
ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg1

[@juan-pablobotero4609]

Very helpful. Thanks for sharing your knowledge.

[@TechyGyan]

Glad it was helpful!

[@TechyGyan]

ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg1

[@hamidhadi3200]

Thanks Sir for the video you provide, one comment this Technic is just working in one sheet. if we need to copy the date from other sheet or workbook how we do it?
if you have any solution for this please comment that this will be your kindness.

[@rohitsarangal4285]

I also gana ask same question have u find solution of it Sir?

[@yvonnwilderx3362]

Has anyone found a solution to this problem yet?

[@owosenikehinde5600]

ruclips.net/video/6MdtSwcrfCo/видео.html here's a solution

[@lexvanheel]

Thanks,. This is what I was looking for!

[@TechyGyan]

Glad I could help!

[@TechyGyan]

ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg1

[@Sunil1992Kurangale]

Thank You sir. It's helpful.. 👍

[@TechyGyan]

If you don't mind, please subscribe to my channel.
ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg?sub_confirmations=11

[@TheVchrung]

super and simple method... nice !!

[@AnbarasuAnnamalai]

Thank you very much for introducing the simple method to copy filtered data.

[@bhuvaneshwarineeli7982]

Can you explain how this works in different excel sheets

[@vaibhavpisal852]

Yes please , i have to use vlookup everytime If anyone knows any shortcut then please let us know

[@harshaldukare758]

Thanks it is very helpful

[@TechyGyan]

Most welcome 😊

[@TechyGyan]

If you don't mind, please subscribe to my channel.
ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg?sub_confirmations=11
REPLY

[@AL-xm4cu]

This is really really great! Only this option works! I have been searching for this solution for a couple of days, but all the other answers are not working for me.

[@samkab677]

Does it work if column B has formula ?

[@jhaashishkumar750]

Very Helpful

[@TechyGyan]

Glad to hear that

[@TechyGyan]

ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg1

[@flamingkitten2574]

This is fantastic. Many thanks. Is there any way doing the same when I want to paste (not on the same sheet but) on sperate sheet/ or book?

[@TechyGyan]

Thank you, I will check and update you

[@TechyGyan]

If you don't mind, please subscribe to my channel.
ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg?sub_confirmations=11

[@ramanajami4038]

Useful very nice

[@TechyGyan]

Glad to hear

[@TechyGyan]

If you don't mind, please subscribe to my channel.
ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg?sub_confirmations=11

[@yogeshparmar9577]

Very useful 🎉🎉 make more videos like this

[@TechyGyan]

Thank you for your comment

[@TechyGyan]

Please subscribe to my channel for new videos

[@TechyGyan]

ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg?sub_confirmations=11

[@bluesunshineo]

Exactly what I was looking for. Thank you so much!

[@TechyGyan]

Glad I could help!

[@TechyGyan]

If you don't mind, please subscribe to my channel.
ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg?sub_confirmations=11

[@adityam4061]

One of the best solutions for an excel naive like me, thanks mate.

[@TechyGyan]

You're welcome!

[@TechyGyan]

if you don't mind, Please subscribe to my channel for more videos ☺️
ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg1

[@nitikamanhas3034]

Thank you so much. Very Very helpful!!!!!!!!!!!!!!!!!

[@devendrarajput4563]

If we have to do this in other sheets then how can we do it ?

[@moneydata4134]

i want raise pr but before that i have check 2 inventory if available only balance need to pr in excel

[@nldinujoseph]

short & sweet. Right to the point, well done and thanks for sharing this solution!!!

[@TechyGyan]

Than you

[@TechyGyan]

If you don't mind, please subscribe to my channel.
ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg?sub_confirmations=11

[@anusuyasrianush8502]

Thanks man ☺️..Finally found this.. literally searched this for months..saved my time💯👏..thanks a lot

[@TechyGyan]

Happy to hear this

[@TechyGyan]

If you don't mind, please subscribe to my channel.
ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg?sub_confirmations=11

[@jecelsumabat545]

very helpful and very easy. Thank you so much for sharing, it really works.

[@TechyGyan]

If you don't mind, please subscribe to my channel.
ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg?sub_confirmations=11

[@jimw.5654]

Hi,
Not working, when I click Fill nothing is pasted. I am missing a step somewhere.
Let me know.
Thanks!

[@jimw.5654]

I figured it out, was working with mouse pad and not selecting both columns. Pretty simple, thanks for sharing works great.

[@TechyGyan]

Happy to hear.

[@TechyGyan]

ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg1

[@swethap9880]

Thanks a lot. Finally found answer for my doubt

[@fatimatalib6341]

thank you very much! saved a lot of time

[@TechyGyan]

Glad it helped!

[@TechyGyan]

if you don't mind, Please subscribe to my channel for more videos ☺️
ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg1

[@jbillford6791]

THANK YOU SO MUCH!! I have taken a new job and this video saved me a lot of time!

[@sreeharikr3526]

really usefull,presentation was excellent, came to the matter without any exaggeration...

[@TechyGyan]

Please subscribe to my channel for more videos
ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg1

[@sushmita4402]

Thank you for making my work easyyy❤

[@TechyGyan]

You are welcome!

[@TechyGyan]

If you don't mind, please subscribe to my channel.
ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg?sub_confirmations=11

[@ericliu79]

For years, Finally I got it

[@VS-ib1ed]

You are a genius. Thank you very much.

[@SagarMorajkar]

Thank you its help me to make a rock star in my office.

[@TechyGyan]

Good to hear

[@canalilucato]

Amazing tip, thanks for sharing.

[@superveda2010]

Outstanding

[@TechyGyan]

Your Welcome

[@TechyGyan]

ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg1

[@adamkamotophiri9692]

All the other methods never worked. Thanks buddy

[@TechyGyan]

Happy to hear!

[@TechyGyan]

If you don't mind, please subscribe to my channel.
ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg?sub_confirmations=11

[@venkatasagar492]

This is helpful. Thank you!

[@TechyGyan]

Glad it was helpful!

[@TechyGyan]

If you don't mind, please subscribe to my channel.
ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg?sub_confirmations=11

[@venkatasagar492]

@@TechyGyan Subbed!!

[@kasim6586]

thank you. very useful
subscribed..

[@TechyGyan]

Thanks for the sub!

[@vincenttsebewu1009]

Thank you sooo much. You just saved me a lot of time

[@alialfaraj7315]

You are a Legend.
Thank you

[@TechyGyan]

Thank you!

[@TechyGyan]

ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg1

[@thegeester777]

Good solution.. But how do you copy from another workbook to a filtered list?

[@TechyGyan]

if you don't mind, Please subscribe to my channel for more videos ☺️
ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg1

[@thegeester777]

Didn't answer the question

[@affiliatefinancialempire]

I am grateful to you. 💖

[@TechyGyan]

if you don't mind, Please subscribe to my channel for more videos ☺️
ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg1

[@ferdyslog]

Wow!!!! This what I need!

[@TechyGyan]

Happy to hear

[@TechyGyan]

if you don't mind, Please subscribe to my channel for more videos ☺️
ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg1

[@tompamintuan5767]

Very useful. help solve 2hours problem! love it!

[@gudipatisaideep5030]

Working but that cell have formulas paste also formulas not a value..any solution this

[@Stockkafunda1]

Small video but very useful thanks

[@TechyGyan]

So nice of you

[@TechyGyan]

if you don't mind, Please subscribe to my channel for more videos ☺️
ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg1

[@sushantachoudhury7021]

Thanks Man, I have seen many other techniques for this but this is very simple.

[@TechyGyan]

Glad it helped

[@TechyGyan]

Please subscribe to my channel for more videos
ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg1

[@markkyy_bmh]

Thank you man. Helped me a lot! ❤️

[@TechyGyan]

Glad it helped!

[@TechyGyan]

ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg1

[@swarnachoppella388]

Thank you so much:)

[@TechyGyan]

No problem 😊

[@sivarajc8998]

Great 👍

[@TechyGyan]

Thank you! Cheers!

[@TechyGyan]

If you don't mind, please subscribe to my channel.
ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg?sub_confirmations=11

[@TechyGyan]

If you don't mind, please subscribe to my channel.
ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg?sub_confirmations=11

[@Faridahjames]

saved my life!!!

[@TechyGyan]

Happy to hear

[@TechyGyan]

If you don't mind, please subscribe to my channel.
ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg?sub_confirmations=11

[@Vanshul-Rushal]

Thank you brother so much

[@TechyGyan]

Welcome

[@TechyGyan]

If you don't mind, please subscribe to my channel.
ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg?sub_confirmations=11

[@Amynka4578]

Awesome!! Cheers

[@TechyGyan]

Thank you! Cheers!

[@TechyGyan]

if you don't mind, Please subscribe to my channel for more videos ☺️
ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg1

[@juliusalistado8404]

Hi. Same scenario but the data in Column B is in formula and you want to copy it to column D as values? how would you do it?

[@TechyGyan]

My friend, in-order to copy and paste a multiple cell containing formula, do the following steps.
1. Select the filtered cell containing the formula (value)
2. The press and hold ALT, then press ; (semi-colon). i.e. ALT (HOLD) + ;
3. Right click and select Copy or CTRL + C
4. Now select the filtered cell where you need to paste
5. Then again press and hold ALT, then press ; (semi-colon). i.e. ALT (HOLD) + ;
6. Then right click and paste or CTRL + V
Hope it works, let me know!

[@juliusalistado8404]

It doesn't work. It says "this action won't work on multiple selections".

[@TechyGyan]

Ya, correct, I thought it worked. But now it prompts the same message. I will check and get back to you, when i get a solution.

[@sahilajha4179]

I can just shout a big Thank you, man..

[@TechyGyan]

:-)

[@TechyGyan]

ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg1

[@Troyboi18]

Very helpful, worked perfectly. Thank you for taking your time to post this.

[@TechyGyan]

You're welcome!

[@TechyGyan]

Please subscribe to my channel for more videos
ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg1

[@nandinireddy5989]

wow thank you so much yar i have been facing this issue..it helped a lot

[@TechyGyan]

If you don't mind, please subscribe to my channel.
ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg1

[@shoppersdream]

Thanks! Nice! How do I do if I have a drop-down with twenty options and I have selected seven options from the drop-down and now I want the drop-down with only selected seven options on the next worksheet? I don't want all twenty options in my drop-down. Thanks

[@TechyGyan]

Hi, Fill option works only on same worksheet. You can’t operate a fill option in different worksheets or books.

[@shoppersdream]

@@TechyGyan Thanks

[@TechyGyan]

If you don't mind, please subscribe to my channel.
ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg?sub_confirmations=11

[@yuriantopratamaputra4142]

Damn, its works.
thanks for sharing.

[@myyoutube_edu3618]

I think the more simple is to paste with press control to the column target. So it minjmize your mouse movement

[@lizzie8462]

Thank you so much for this quick video. Is there any way to do a paste values only option?

[@TechyGyan]

Thank you. Did you tried the go to special option in Find and select. After copying, go to this option and select visible cells only and check for numbers

[@shalvasultanishvili]

Thank you for your video. Exactly what I was looking for.

[@canirmalchoudhary8173]

Also for thus to work filter must be applied on column before the column from which you want to paste values

[@navinop8007]

Working like charm

[@TechyGyan]

Please subscribe to my channel for more videos
ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg1

[@qasim939]

Super Trick

[@TechyGyan]

Thank you!

[@TechyGyan]

If you don't mind, please subscribe to my channel.
ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg?sub_confirmations=11

[@jewelislam1245]

Is there any shortcut for it?

[@shabchique7149]

Thanks for this, it's very useful! Do you know how to use the auto fill to copy from one cell to many cells below it, and there are many hidden rows that I don't want to copy to. thank you

[@kalyanimuvvala6618]

What if the copied cell contains any formula and to be pasted only values???

[@barryh7387]

Brilliant tip thanks

[@TechyGyan]

Happy to help

[@TechyGyan]

Please subscribe to my channel for more videos
ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg1

[@himanshubatra7410]

Question : If the Data of Column B is derived from some formula, means data of column is also a result of some formula written in col B then how does it work? because I am still having the issue.

[@TechyGyan]

Hi Himanshu, this fill option don’t work with formula. In order to work you need to replace the formula with values.

[@Vikramsingh-or4cw]

thks but how to do same with only formula. like i want to paste only formula to right in filter row

[@jouuueee]

Thank you.

[@TechyGyan]

If you don't mind, please subscribe to my channel.
ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg1

[@hashimkhhashim5066]

Thank you so much bro

[@TechyGyan]

No problem

[@TechyGyan]

ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg1

[@prakashrnair]

Thanks a lot! This finally helped me

[@TechyGyan]

Glad it helped!

[@TechyGyan]

Please subscribe to my channel for more videos
ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg1

[@kiranm6749]

Thanks a lot I used use alt +; but it's not working no.. But ur trick work... Thank you so much

[@TechyGyan]

Thank you, friend

[@TechyGyan]

Please subscribe to my channel for more videos
ruclips.net/channel/UC-1RCPqmlp3xBGIOjgJm5pg1

[@boyvinnix6118]

How if the object copy is not the same sheet or I'll copy from the random Sell?