I don't think I've ever posted a review for anything in my life. This add-in just saved me about 12 hours worth of work. Thank you!
@stephenpavlik4545
3 жыл бұрын
Thank you so much for this! You saved me a whole day of individually copying thousands and thousands of data row by row
@contextures
3 жыл бұрын
You're welcome, Stephen, and thanks for letting me know that it helped you save time!
@MySpreadsheetLab
9 жыл бұрын
A common data challenge and some great ideas on how to solve it. Thanks Deb. I've known many people that were pasting into another filtered list not realizing the damage that they were doing to their data.
@contextures
9 жыл бұрын
Thanks Kevin!
@r.a.8618
5 жыл бұрын
Useless. What I want to know is a method to do the copy and paste without having to do any sorting or adding of columns.
@Invento_Boost
2 жыл бұрын
Finally, I sorted and pasted my data into the right place after trying a lot of functions but just a simple letter and sorting from this video did the job. Thanks
@contextures
2 жыл бұрын
You're welcome, Muhammad, and thanks for your comment! I'm glad the video helped you with pasting your data
@filipgodsu2410
Жыл бұрын
This lady just saved me hours of work and sweating ❤ thanks so much!
@contextures
Жыл бұрын
You're welcome, Filip, and thanks for letting me know it saved you time!
@rajanipormalla2225
3 жыл бұрын
That is genius.Thank you for sharing us this logic. Have seen many videos but this is by far the simplest and effective 👌. Great respect. You have earned a subscriber.
@contextures
3 жыл бұрын
Thank you, Rajani, and I appreciate hearing that the video helped you. And thanks for subscribing too! -Debra
@AbdulRasheed-yb2sc
8 жыл бұрын
i am asking many people for this from last 1 year , i didn't but finally, thank you very much.
@MsGnor
8 жыл бұрын
Thanks for your video. I recently started with a client who uses Excel 2013. First time I've had problems manipulating data in a filtered list. I lost hours of work on Friday. Now I understand why. Never happened before. I'm horrified at how much extra effort I now need make in order to do something that previously was super easy. WTF.
@GregJoshuaW
11 ай бұрын
I've been using Excel since the 90s. I have NEVER been bit by this before until last week. I honestly don't understand how that is possible. I'm incredibly irritated that this BUG has never been addressed.
@MsValiev
2 жыл бұрын
Just Awesome! Thank you! I wish I've watched this 6 hours ago, which I now consider wasted...
@contextures
2 жыл бұрын
You're welcome, and thanks for letting me know that you finally found what you needed!
@fredericklebel9431
2 жыл бұрын
Thank you very much for this video! I see it has been posted a couple of years ago. Is this still the only workaround in 2022? I’m having this problem also and it is the best I found to date!
@contextures
2 жыл бұрын
You're welcome, Frédérick, and thanks for your question. There haven't been any changes to this problem in Excel, so we have to keep using the workaround.
@fredericklebel9431
2 жыл бұрын
@@contextures ok thank you very much for your answer! I’ll use it for sure. you just saved me! Lol 😂
@jaison187
4 жыл бұрын
This is really helpful and Awesome, because every people has faced this issue during working. I watched many videos related to this topic but I could not find exactly . Thank you so much!
@whizmale
9 жыл бұрын
This was driving me batty. Thank you for the great idea. I was also told that to eschew the pivot table and do a custom sort on the plain data. Then the paste will work. Keep up the good work!
@hoggrobinson
8 жыл бұрын
You Could also paste using find/Select-Goto Special-Visible cells only and paste
@MF-xr9ei
8 ай бұрын
You are the GOAT for this
@contextures
8 ай бұрын
Aww, thank you! I'm glad the video helped you with that filtered list problem
@Naveenbilla07
3 жыл бұрын
Really this shortcut was very helpful for my work.👍👍👍👍Tq team🙏🙏🙏🙏
@contextures
3 жыл бұрын
You're welcome, Naveen, and thanks for letting me know that the shortcut helped you!
@nigelwiseman8644
Жыл бұрын
Solved my problem. Thanks.
@contextures
Жыл бұрын
You're welcome, Nigel, and thanks for your comment!
@AbdulRasheed-yb2sc
8 жыл бұрын
it is better to insert a new column at the beginning for serial numbers and then start filter and copy paste, some times we forget or confused where we are filtered data.(thanks Kevin once again)
@esan120au
Жыл бұрын
02:15 thanks for the nice tip, a real game changer!
@contextures
Жыл бұрын
You're welcome, Ehsan, and thanks for your comment!
@tarsisioipod
8 жыл бұрын
I love you!!! You just saved me at least 2 hours on 4 reports. I`m hugely thankful.
@mttpsg00
3 жыл бұрын
thanks for the good tip! this is an excel BUG !! because results are not as expected. it should at least notice about this way of completing.
@newnemesis666
3 күн бұрын
Thank you very much 👍
@contextures
2 күн бұрын
You're welcome, and thanks for your comment!
@VictorRocketBoy
5 жыл бұрын
OMG, Great use of logic, you are a genius, this trick ... RESPECT
@jouuueee
3 жыл бұрын
This was a good solution for a really dumb problem. I do appreciate it. However in my case I was able to eliminate the temporary column. First I filtered then I changed the color of the cells I needed to copy two. Then cleared my filter sorted by the color and was able to copy and paste. I can't believe that Excel doesn't have a simple function that allows you to copy a value without leaving the reference and formula in the cell. Visually it's right but technically it's wrong. Coping data that is parsed should be a straightforward as copy value and sell to an equal value in another cell. As advanced as XL is it's really surprising that they don't have two or three ways to do this. There is a way to copy the visible cells but no way to paste into visible cells. Sounds like whoever was working on this code took the day off.
@contextures
3 жыл бұрын
You're right, Tarso, and this should be much easier! I like your colour sorting solution though, as a simple workaround.
@juliusbiliran
2 жыл бұрын
I couldn't agree more! This comment just made my day!
@excelisfun
10 жыл бұрын
Great video!
@contextures
10 жыл бұрын
Thanks!
@rajeshshah6758
3 жыл бұрын
Thanks for the video. You saved me a lot of time
@azamuddeenshauqi6355
3 жыл бұрын
Thank you so much. This method saves a lot of hours doing my report. 1 subscriber for you.
@contextures
3 жыл бұрын
Thanks for subscribing!
@nopizzanow
10 жыл бұрын
Thanks for sharing a trick to copy in filtered cell, But I would like to know a direct method. I remember that one of my friend was doing it directly.
@manojillangasooriya3590
3 жыл бұрын
I'm looking for exactly @ 4.39. Thank you.
@contextures
3 жыл бұрын
You're welcome, Manoj, and thanks for letting me know which part of the video helped you!
@RAJESH-zf8so
5 жыл бұрын
how to paste copied data to visible cells which is in different sheet
@jaiganesh6402
5 жыл бұрын
Thank you.. You saved my day..!!
@petesimone2763
2 жыл бұрын
Great Video TY
@contextures
2 жыл бұрын
You're welcome, Pete, and thanks for your comment!
@deepudevan3105
4 жыл бұрын
Thank You, saved me lot of time.
@grahambotha4447
7 жыл бұрын
Thank you, this solution is brilliant! :)
@kudavbabani3767
3 жыл бұрын
Thank you mam for this help👍
@contextures
3 жыл бұрын
You're welcome, Kudav, and thanks for your comment!
@Nahuel.E.R.
Жыл бұрын
What about If I would need the specific order resulted of filtering by a certain column by aparition plus the order of that "x" value has introduced?. So, in this case, you have a complex escenario where you need to make a lot of extra things to solve something that Excel should...
@md.arifhossain4837
2 жыл бұрын
You just earned a subscribe from me. Thanks a lot.
@contextures
2 жыл бұрын
Thank you - I appreciate it! --Debra
@contextures
10 жыл бұрын
leari tee Thanks! Glad you liked the Excel tip.
@aurelienfrancois
2 жыл бұрын
we are in 2022 and MS still hasn't solved this basic stuff
@contextures
2 жыл бұрын
You're right!
@NomanIftikhar-ft4qo
Жыл бұрын
I am facing a problem. I am not able to paste all filtered data. When i highlight the filtered data, there are dotted-line block shown, and I am able to paste only the first block, not the rest of them. How to solve this issue?
@jereramirez7433
8 жыл бұрын
Thanks for the great tip!
@johannafedorovsky7262
7 жыл бұрын
Very useful! Thanks!
@ashkarali8923
Жыл бұрын
Thank you
@contextures
Жыл бұрын
You're welcome, Ashkar, and thanks for your comment!
@tonybaby6770
3 жыл бұрын
Oh madam nice idea.
@curtisclement5467
3 жыл бұрын
What if you're trying to copy values (in a column) from one filtered table to a filtered table in another Excel workbook? I've managed to put the 'select visible cells only' button in my quick access toolbar but when I go to paste my values in the target filtered list it either: A) Fills in the hidden rows in between (with duplicate values) as well as the visible cells or B) If I try to select only the visible cells in the target location then it comes up with an error.
@greenygamey2378
2 жыл бұрын
Mam I'm facing one issue in excel in one column. i copied that column paste in outlook . Excel showing not responding .kindly suggest me an solution
@mohammedjawad3918
7 жыл бұрын
Thanks for the great tip! That's a very helpful tip.
@contextures
7 жыл бұрын
You're welcome! Thanks for letting me know that you liked the Excel tip
@waseemkhalid2506
3 жыл бұрын
Excellent video
@khansabaalam4553
2 жыл бұрын
Thank you so much!!!!
@contextures
2 жыл бұрын
You're welcome, KhanSaba, and thanks for your comment!
@chayanuna
9 жыл бұрын
Very useful "X", thank you !!
@sureshg6700
6 жыл бұрын
I made facing same problem however haver I have very huge data with multiple columns, please suggest me how can I copy paste on filtered columns
@TheMisspattyb
3 жыл бұрын
Thank you! a lifesaver!
@tayyabpathan3393
2 жыл бұрын
thanks
@contextures
2 жыл бұрын
You're welcome!
@coole724
Ай бұрын
AMAZING
@contextures
Ай бұрын
Thank you!
@CampGravatt123
9 ай бұрын
omg you just saved me so much time bestie, bless i love #womeninstem
@contextures
9 ай бұрын
Thanks for letting me know -- I appreciate hearing that!
@9840708603
6 жыл бұрын
Select the desired data press F5 dialog box opens go to special and click “Visible cells only” Press copy and then paste to the desired area.
@canalilucato
5 жыл бұрын
Amazing tip, it works in both ways. Thanks.
@chalkie247
8 жыл бұрын
Hi! This video is REALLY helpful......however.......the data i'm copying is alpha and when I fill using your method, it changes to numerical! Any ideas how to stop this?
@girishmakwana8169
4 жыл бұрын
Hello, I have copy filter data from some other file & paste in to another viable cell in different file how it's possible
@cumensu
8 жыл бұрын
My problem is even more strange. I am trying to copy filtered information to two different columns b/c I have split my data into two different samples. I filter, then copy, then remove my filter and paste. When I select paste p or the paste fx (for formulas) it gives me the information for the cells that should have been hidden. When I select values though, it gives me the exact cells that I was interested in! I have NO clue what to do. In addition, when the hidden cells are pasted, the number of values that it pastes is equal to my interested variables sample. So if I want to copy the data for x and x has 72 entries, it winds up copying the data for y up to 72 entries although y has 300 entries :-(.
@kristophermanansala4434
4 жыл бұрын
Please help me I wanna paste my selected column to a filtered column. For example: i Have a column that has different kinds of names and i want it to be paste beside my filtered column so that each side corresponds to the name and if I unfiltered it, I want it to fit to their specific cells. Another example: i have a yellow marked cells and if i filtered out all the yellow cells, i want the names to be paste beside that filtered yellow mark so each yellow mark fits to their specific names. It is not appearing completly every time I paste it beside the filtered section.The names wont come out completly or it appears half of the names i copied and if i unfiltered it the names are completly scattered inside the column and the names wont match to the cells or column that i wanted it to be. Please help me it will save me a lot of time and work. I'm copying and pasting it manually for more than a thousand cells everyday and it is really time consuming and it is hurting my hands so bad. Thanks in advance i hope you guys can help me! Sorry for my english I really cant explain it well.
@Muddyfox47
3 жыл бұрын
is there a better way of doing this in 2021 ?
@riversong7577
6 жыл бұрын
thankyouuuu!!! this is really helpful!
@contextures
6 жыл бұрын
You're welcome, River Song, and thanks for letting me know that it helped you
@aymankotb
6 жыл бұрын
please can i copy data from merge area to another column ex i have some things shared in same date and it is but in marge area in front of this things and i want this date in front of this things for every on front it is
@ashish18oct
5 жыл бұрын
When I copy ... It's show msg ...(Cannot change part of a merged cell). . .
@mahmoudragab8596
8 жыл бұрын
This is very helpful , but i face another problem in pasting data in filtered sheet if that data is copied from another workbook and not at same rows of pasting cells.....how can i deal with that ?
@DS_012
5 жыл бұрын
Have you got any solution to this issue? I am facing same issue of copying to another workbook. If yes, please reply asap.
@GregJoshuaW
11 ай бұрын
Microsoft: HOW IS THIS NOT A BUG.
@BWSP
9 жыл бұрын
Thank you so much!
@bapu2542
5 жыл бұрын
thanks you so muchhh...dear
@yosefeidensohn7366
3 жыл бұрын
nice video! curious why you didn't suggest using the formula =B6 in cell E6 and pasting downwards.
@mttpsg00
3 жыл бұрын
i think that "x" is more obvious not to be a part of the table, so after doing the trick you immediately see the column to be deleted.
@yummy-sunflower
6 жыл бұрын
Thank you!!
@manoharanduraisamy284
5 жыл бұрын
Thanks Madam
@ashishmehra380
9 жыл бұрын
You can use ALT + ; instead of applying logic shown in this video
@leos280
4 жыл бұрын
Hi can ypu please elaborate on this option. I knew it but forgot it. It will be a great help
@jgps96
5 жыл бұрын
Good trick
@ladodelapared
8 жыл бұрын
The video is great, but how can I do the opposite, i.e. copying from a non filtered row to a filtered, visible row of cells? I have been looking EVERYWHERE and nothing. Anyone?
@9840708603
6 жыл бұрын
Select the desired data press F5 dialog box opens go to special and click “Visible cells only” Press copy and then paste to the desired area.
@Akhtarkhan-si2bo
6 жыл бұрын
This works, when data is on same sheet, I am wondering, if data is on other sheet, which is unfiltered and want to paste on filtered columns/cells of other sheet?
@DS_012
5 жыл бұрын
@@Akhtarkhan-si2bo Have you got any solution. I am having same issue. Reply asap please.
@khajatajuddin2233
9 жыл бұрын
thanks a lot!!
@aurkmez
9 жыл бұрын
Lifesaver!
@hairesdenada9004
4 жыл бұрын
whuttttttttttttttt!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! you helped me a lottt
@raymawm
5 жыл бұрын
smart choice!
@Nahuel.E.R.
Жыл бұрын
So, this is not the solution, this is a work around for an issue for certain simple cases. The solution is that Microsoft make a good product...
@sarthaksolomon
9 жыл бұрын
good logic but what if you don't want to sort the data or you are not supposed to sort the data then what??
@raymawm
5 жыл бұрын
u can click thr 2nd time of sort bottom and turn back to normal (raw order) >.
@Chandler890
3 жыл бұрын
this is not the way to go
@Defnotdoge
5 жыл бұрын
The Title is not completely accurate and I suggest changing the Title to be Workaround Hack for Problems Pasting in Excel Filtered List. Or at least explain that this is a workaround in the beginning
@FelipeSagan
5 жыл бұрын
81 dislikes from people who sell this solution or the lazy ones
@YahyaMarei
4 жыл бұрын
3:42
@honestnewsnet
3 жыл бұрын
Insanity
@webbsurfer
Жыл бұрын
It was looking promising until the last sorting step. Instead of sorting all the columns like in the video, my Excel only sorted the 'x' column. What could be the reason?
@contextures
Жыл бұрын
Make sure you have only one cell selected in the X column, when sorting. Then Excel should sort the entire table, and not just one column
@miguelribeiro3206
2 жыл бұрын
I like my method better, this can be done by: Home>>Find & Select >> Go To Special...>>Visible Cells Only
Пікірлер: 132