I cannot begin to thank you enough for this. I had THOUSANDS of filtered cells I needed to copy and paste for work. This would have taken me FOREVER! Your instructions and video were very clear and easy to follow. i appreciate you r skills!
I have been searching the answer to this question for so long. all the rest videos are showing how to paste in a new sheet. I am so frustrated, until I finally find this video, which gives us a great trick on how to paste in a filtered column. This is great! This is so helpful! Thank you very much for your knowledge and thank you so much for sharing!!!!
Hello. I just downloaded the trail version of Paste Buddy....and I copied a sequential column of 255 visible cells located on one tab of my workbook --- and then I pasted this sequential data into another tab within my same workbook, into 255 filtered, but visible blank cells using the Paste Buddy Add-in....and it appeared that my Excel Program locked-up and crashed, but after about 30 seconds, my required data appeared in the 255 filtered, but visible cells! Wow! What a relief! Great Job with this handy Excel add-in!
Thanks alot. I have used the first trick of Ctrl and Enter to populate the visible cells then removed the filter and copied the whole column with formulas and pasted only values all over the same column and it worked fine!
If you have an issue "pasting" in a visible range from another sheet when you have hidden rows, this is the easiest solution I've found: See if you can remove the filter and instead, sort your data in a way that you see the cells you want to see on the top of the page; then also sort your source sheet similar to the first sheet. Now you don't need to paste in the visible range. You just paste in the sorted area where needed.
Hi Jon - I'm on a Mac and i'm trying to copy a column that's using a filter and pasting the information into another workbook. The new workbook has the same rows but with a filter that's hiding some rows of data. It doesn't seem to work on a mac.
Great video! Is there a way to do this without downloading the macro? Not sure if I'm allowed to download anything at work, unfortunately. Also, any tips for autofill with hidden rows? For example I filter what I need to have and want to put in 999 into the first viewable cell. Dragging down to autofill that same number 999 into the below viewable cells. When I unfiltered and unhide the table, the numbers are pasted into the previous hidden cells. Thanks again.
Hi, not sure if you still need the answer or not. I have just tested your question. it works as below: 1. filter as you want. 2. select the cells that you want to enter 999, make it visible only selecting with the alt+; 3. enter now with your keyboard 999 or anything you want . 4. now, press ctr+enter you get all the selected visible cells with 999
Does that work on a diff sheet? Instead of copy and paste on the same sheet, I want to copy only visible cells and paste to only visible cells on another sheet.
Try to copy& paste the data from the other xls to seperate sheet of your excel file where wanna operate ... now copy the data in sheet and paste in the required cells.
this video is 9years old already and until now 2024 Excel did not add a function to do this. unbelievable. Google Sheets can do this without any add in or script whatsoever. Thanks for this video!
Dear Sir, this video is of great help, while pressing CTRL+Enter key you got the same values(not formula) in the pasting cells( ie Chicago got copied from C2,C12 & C14 to F2,F12&F14 cells) Is there any shortcut which can paste same formula present in C2,C12 & C14 toF2,F12&F14 (wrt above video) cells? kindly help on same
Hey Jon. Thank you very much for this procedure. I was really getting confused. But, I resolved my concern by helping on some areas of this video. Thank You.. :)
But when I tried to remove content from source column then our target column get 0 value. Can you guide me how to keep target value as it is? Here target column and source column filtered. I want to do in filtered column.
Instead of purchasing paste buddy, you could use the cell reference ctrl + enter solution shown first, then copy the entire column where your paste destination is, and then use a special paste to paste the values over the cell references. Kind of confusing because you are copying and pasting over the same column, making sure to paste values.
Great question Chris! YES, you can paste over the range you want to copy. And you can choose "Values" from the Paste Type drop-down menu to just paste the values. For those that aren't familiar with the term "hard code filtered formula data", this means that Chris wants to take a range of cells that contains hidden rows, and replace the formulas in the cells with the result of the formula (values). This would be the same as copying and pasting values, and the Paste Visible add-in allows you to do this on a range that contains hidden rows or columns. Thanks Chris!
2021, I need to copy data ( updated report ) from one sheet to the main sheet while having the filter on in both the sheets. Is there a way I can do in this age without installing any addon. Ms office 2016
Hi Jon, I appreciate your support, thank you. I have an other question: How do we Copy visible values only. Lets say I have formatted the cell just to see two decimal places. When I use it in CONCATENATE function it pulls the whole number. I just want it to be collected with two decimals. Thank you..
Does the add-in not work for excel for Mac? I downloaded it and tried to install it but I get a "microsoft visual basic" error - and when I search the Add-in on the store it does not show up. Pls help - this would make my job so much easier! Thanks :)
I tried the formula option, but it doesn't work in a Table. It automatically added the formula to all the cells in the column. Do you know if there's a way to work around that with Tables?
HI Jon, Great Video, i have a small doubt. when we do Ctrl+ Enter to paste. it pastes with formula. can we just paste values is there any shortcut for it or any formulas. Please help
+afreaz Hi Afrez, you can use the Paste Special > Values to paste the values. Paste Values can be accessed from the Paste menu, right-click menu, and many other locations. The keyboard shortcut is Alt+E,S,V, Enter. I hope that helps. Thanks!
is there any way to paste to the filtered cells(where some cells are hidden), i tried a lot but when i paste, it peast to the hidden cells also. what should i do ?? please replay..
i am also working on a data in which i have to separate last names manually because all of the formulas i have tried gives the result to get last name from the cell but also that last name word remains in the original cell from where it is separated i have tried all formulas and coding also to ad new function to excel with the help of chat gpt but no solution can you help me
I cannot begin to thank you enough for this. I had THOUSANDS of filtered cells I needed to copy and paste for work. This would have taken me FOREVER! Your instructions and video were very clear and easy to follow. i appreciate you r skills!
I have been searching the answer to this question for so long. all the rest videos are showing how to paste in a new sheet. I am so frustrated, until I finally find this video, which gives us a great trick on how to paste in a filtered column. This is great! This is so helpful! Thank you very much for your knowledge and thank you so much for sharing!!!!
Glad it was helpful, Fiona! 😀
2023 and I’m still looking for this. Thank you 🙏
Paste buddy is a life saver. I had data running into 1800 values which I needed to copy into filtered cells. Thank you.
I will try it tmr. I have been working for 5yrs but every time I struggle with this issue. Hope paste buddy can save my time.
What are we accountant going to do without guys like you who makes our job super fast!
Brilliant - absolultely brilliant! I have been trying to get this for ages and no other video to date has helped, thank you so much for sharing this
Thank you for your feedback, Alistair! 😀
I was looking exactly for this in the last 5 hours. Thanks a lot.
If visible cell trick not working try this trick its 100% working ruclips.net/video/3yyoXWh6JbU/видео.html
Hello. I just downloaded the trail version of Paste Buddy....and I copied a sequential column of 255 visible cells located on one tab of my workbook --- and then I pasted this sequential data into another tab within my same workbook, into 255 filtered, but visible blank cells using the Paste Buddy Add-in....and it appeared that my Excel Program locked-up and crashed, but after about 30 seconds, my required data appeared in the 255 filtered, but visible cells! Wow! What a relief! Great Job with this handy Excel add-in!
You are on my christmas card list i have been trying to do this for ages thanks
finally, i found this video who trully needed the most. ty sir
Dude - You are THE MAN! Thanks for sharing this.
Of all the videos I looked for for this issue, this was is simply the best !! Thanks so much :)
Thanks alot. I have used the first trick of Ctrl and Enter to populate the visible cells then removed the filter and copied the whole column with formulas and pasted only values all over the same column and it worked fine!
If visible cell trick not working try this trick its 100% working ruclips.net/video/3yyoXWh6JbU/видео.html
your video is so helpful for people
BHAI BHAI .....EK NUMBER.... SOLVED MY PROBLEM
Thanks for Paste buddy, you are a life saver
It saved me a lot of time. Thank you 🙏
Glad it helped, V P! 😀
If you have an issue "pasting" in a visible range from another sheet when you have hidden rows, this is the easiest solution I've found:
See if you can remove the filter and instead, sort your data in a way that you see the cells you want to see on the top of the page; then also sort your source sheet similar to the first sheet.
Now you don't need to paste in the visible range. You just paste in the sorted area where needed.
Try this trick its really helps u and thanks me later
ruclips.net/video/3yyoXWh6JbU/видео.html
Thank you so much. You are the saviour.
Fantastic. You made my job easy.
Thank you so much for sharing. This makes my life much easier
YOU ARE A LIFESAVER!! THANKS SO MUCH
Thank you so so much sir ! You made my life easy. More power to you :)
Happy to help! 😀
Thank you so much - this has totally made my life easy!
Thanks a lot very helpful 👍
Thank you so much !! Your trick helped me save countless hours of work
If visible cell trick not working try this trick its 100% working ruclips.net/video/3yyoXWh6JbU/видео.html
wow this has really really helped! thanks for the excel tool mate. Keep up the great work
good tips, thank you so much =))
great 👍 and thanks for your help.
Hi Jon - I'm on a Mac and i'm trying to copy a column that's using a filter and pasting the information into another workbook. The new workbook has the same rows but with a filter that's hiding some rows of data. It doesn't seem to work on a mac.
Awesome tricks that save time. Thanks for the tips.
Thomas Garcia Thanks Thomas!
Very helpful and insightful. Thank you Jon 😊
great! demo version perfectly worked! thank you. guess i ll pay this to have forever.
Only feedback here, that d've been a bit faster though.. It takes long time on pasting..
Great video! Is there a way to do this without downloading the macro? Not sure if I'm allowed to download anything at work, unfortunately.
Also, any tips for autofill with hidden rows? For example I filter what I need to have and want to put in 999 into the first viewable cell. Dragging down to autofill that same number 999 into the below viewable cells. When I unfiltered and unhide the table, the numbers are pasted into the previous hidden cells.
Thanks again.
Hi, not sure if you still need the answer or not. I have just tested your question. it works as below:
1. filter as you want.
2. select the cells that you want to enter 999, make it visible only selecting with the alt+;
3. enter now with your keyboard 999 or anything you want .
4. now, press ctr+enter
you get all the selected visible cells with 999
Does that work on a diff sheet? Instead of copy and paste on the same sheet, I want to copy only visible cells and paste to only visible cells on another sheet.
Try to copy& paste the data from the other xls to seperate sheet of your excel file where wanna operate ... now copy the data in sheet and paste in the required cells.
Try this tutorial
ruclips.net/video/3yyoXWh6JbU/видео.html
Thank you SO MUCH
Exactly solved my problem !!
Good solution. I think Paste, Special, Skip blanks would be another effective solution too. You have to select the right number of destination cells.
still a helpful video on 2020! Thank you!
Thank you so much!
Very helpful indeed.
Hi, I am on a work computer so I cannot download add ins. Any other solution you can provide as opposed to pasting one by one?
Super Jon thanks a million!
Dear,
Your video is cool.
But I dont know how to take paste visible item?
Could you please help to instruct me?
Thank you
Thank you VERY much, it saved me lots of trouble!
Very nice and useful video
THANK YOU SO MUCH
GREAT SIR!!!
this video is 9years old already and until now 2024 Excel did not add a function to do this. unbelievable. Google Sheets can do this without any add in or script whatsoever. Thanks for this video!
Thankyou so much sir
Thanks a lot.
Jon, 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.
2Deeelite4 nice question. I will definitely try to find out answer of your question. Please me give some time.
I need this as well, have you found anything to help?
Exactly. This is a key MISSING function in excel.
I need this feature, too - how do I do this??
Did you find anything on this? I need to do the same and haven't been able to find anything online
You saved my lifeeeeee
Lifesaver, thanks man!
Great video Jon. Very useful.
Thanks Christopher!
Finally, great solution thanks
Dear Sir,
this video is of great help, while pressing CTRL+Enter key you got the same values(not formula) in the pasting cells( ie Chicago got copied from C2,C12 & C14 to F2,F12&F14 cells) Is there any shortcut which can paste same formula present in C2,C12 & C14 toF2,F12&F14 (wrt above video) cells? kindly help on same
I was looking for this. Very helpful. Thank you
Very nice.. Thank you! :-)
it works, how do I pay and install the full version? Thanks
Hey Jon. Thank you very much for this procedure. I was really getting confused. But, I resolved my concern by helping on some areas of this video. Thank You.. :)
If visible cell trick not working try this trick its 100% working ruclips.net/video/3yyoXWh6JbU/видео.html
Thanks a lot bro
Thanks Gan.. Working !!
But when I tried to remove content from source column then our target column get 0 value. Can you guide me how to keep target value as it is? Here target column and source column filtered. I want to do in filtered column.
Awesome.....fabulous tips. keep up the good work.
is there anyway I can paste in filtered cells without download anything
Nopeeee... It's a easy and convenient way what he suggested... It worked for me.. saved my time... Try it
I love you for this
Instead of purchasing paste buddy, you could use the cell reference ctrl + enter solution shown first, then copy the entire column where your paste destination is, and then use a special paste to paste the values over the cell references. Kind of confusing because you are copying and pasting over the same column, making sure to paste values.
Can you paste on top of what you are copying? I often want to hard code filtered formula data on the fly. Very cool feature add!
Great question Chris! YES, you can paste over the range you want to copy. And you can choose "Values" from the Paste Type drop-down menu to just paste the values. For those that aren't familiar with the term "hard code filtered formula data", this means that Chris wants to take a range of cells that contains hidden rows, and replace the formulas in the cells with the result of the formula (values). This would be the same as copying and pasting values, and the Paste Visible add-in allows you to do this on a range that contains hidden rows or columns. Thanks Chris!
THANK U VERY MUCH SIR.
Super, Thank you very much...
Thumbs up for the Atl + ; shortcut
Does this work also on MAC?
2021, I need to copy data ( updated report ) from one sheet to the main sheet while having the filter on in both the sheets. Is there a way I can do in this age without installing any addon. Ms office 2016
Can I just purchase paste buddy separately? I don't need the whole suite.
Hi Jon, I appreciate your support, thank you.
I have an other question: How do we Copy visible values only. Lets say I have formatted the cell just to see two decimal places. When I use it in CONCATENATE function it pulls the whole number. I just want it to be collected with two decimals.
Thank you..
you can format the destination cells in a way that they reflect decimal value.
@@snjpverma That makes sense, thank you bro
But you know that is not a number anymore I presume a text, so that would not function. I will check it anyway
Question, do u know if u can pasta new data overtop a formula within excel
Meaning if cell 1/row 1 is blank copy paste cell2/ row2 if not do nothing
Try this tutorial and thanks me later
ruclips.net/video/3yyoXWh6JbU/видео.html
Wow nice 👍
Fantastic!
Does the add-in not work for excel for Mac? I downloaded it and tried to install it but I get a "microsoft visual basic" error - and when I search the Add-in on the store it does not show up. Pls help - this would make my job so much easier! Thanks :)
Thanksssssss alotttt man
thank you
I tried the formula option, but it doesn't work in a Table. It automatically added the formula to all the cells in the column. Do you know if there's a way to work around that with Tables?
Yes! In this tutorial have way to doing the same please watch and thanks me later
ruclips.net/video/3yyoXWh6JbU/видео.html
HI Jon,
Great Video, i have a small doubt. when we do Ctrl+ Enter to paste. it pastes with formula. can we just paste values is there any shortcut for it or any formulas. Please help
+afreaz Hi Afrez, you can use the Paste Special > Values to paste the values. Paste Values can be accessed from the Paste menu, right-click menu, and many other locations. The keyboard shortcut is Alt+E,S,V, Enter. I hope that helps. Thanks!
Thanks Jon It safe my life , Super!
Excellent... Sir
Genius! Thx!!
is there any way to paste to the filtered cells(where some cells are hidden), i tried a lot but when i paste, it peast to the hidden cells also. what should i do ?? please replay..
IF YOU WANT TO PASTE ONLY VISIBLE CELLS, SO SELECT FIRST THEN PRESS ALT+; THEN PASTE IN ANOTHER SHEET.
faaaantastic! Thank you!
thank you so much
Thanks
Thanks a lot.. this really works
Great video !!
Thanks Mike!
Sir, I have a doubt, I have to paste value in same cell, whom I am coping, cant we do without download XL CAMPUS????
Hey John, what would the keyboard shortcut be on a mac for the equivalent of ctrl + enter?
Thanks
Thomas Gibson Command + enter ?
i am also working on a data in which i have to separate last names manually because all of the formulas i have tried gives the result to get last name from the cell but also that last name word remains in the original cell from where it is separated i have tried all formulas and coding also to ad new function to excel with the help of chat gpt but no solution can you help me
How can we copy filtered data from one sheet to another sheet?
Great Master, Thank you Very Much, I love you
Yaseen Mohammed Thanks Yaseen!
Awesome!!! Useful and thankyou!!!
I tried to copy cells from a different workbook sheet and it didn't work. It works only why you copy from the same sheet.