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? T...
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
