Forum Discussion
Solved
How to paste into visible cells in excel only in table?
Hello,
I am trying to copy and paste a column of numbers, but when I paste it into filtered table, excel also pastes it into the hidden cells as well.
How would you advise I fix this?
This is the table that I want to copy from:
Then I want to paste it into this other table which I filtered for the target countries, but excel pastes it into the hidden cells as well.
Thank you,
Amy
AmyYang Indeed, that's not possible. Hidden rows are just that. Hidden but still part of the range you copy into. Better to use a lookup function to "link" the two tables. Then you don't have to worry about the sort order either. INDEX/MATCH or XLOOKUP would work well in your case.
AmyYang Indeed, that's not possible. Hidden rows are just that. Hidden but still part of the range you copy into. Better to use a lookup function to "link" the two tables. Then you don't have to worry about the sort order either. INDEX/MATCH or XLOOKUP would work well in your case.
- Hi Riny,
Understood, thanks kindly for your reply!
Regards,
Amy
