SOLVED

How to paste into visible cells in excel only in table?

%3CLINGO-SUB%20id%3D%22lingo-sub-3361906%22%20slang%3D%22en-US%22%3EHow%20to%20paste%20into%20visible%20cells%20in%20excel%20only%20in%20table%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3361906%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EI%20am%20trying%20to%20copy%20and%20paste%20a%20column%20of%20numbers%2C%20but%20when%20I%20paste%20it%20into%20filtered%20table%2C%20excel%20also%20pastes%20it%20into%20the%20hidden%20cells%20as%20well.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20would%20you%20advise%20I%20fix%20this%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20the%20table%20that%20I%20want%20to%20copy%20from%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22AmyYang_0-1652321280285.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F371012iB87AE06781FA1451%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22AmyYang_0-1652321280285.png%22%20alt%3D%22AmyYang_0-1652321280285.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CBR%20%2F%3E%3CBR%20%2F%3EThen%20I%20want%20to%20paste%20it%20into%20this%20other%20table%20which%20I%20filtered%20for%20the%20target%20countries%2C%20but%20excel%20pastes%20it%20into%20the%20hidden%20cells%20as%20well.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22AmyYang_1-1652321314369.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F371013iDF5DF2E73B1B9E45%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22AmyYang_1-1652321314369.png%22%20alt%3D%22AmyYang_1-1652321314369.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EThank%20you%2C%3C%2FP%3E%3CP%3EAmy%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3361906%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3362067%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20paste%20into%20visible%20cells%20in%20excel%20only%20in%20table%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3362067%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1260738%22%20target%3D%22_blank%22%3E%40AmyYang%3C%2FA%3E%26nbsp%3BIndeed%2C%20that's%20not%20possible.%20Hidden%20rows%20are%20just%20that.%20Hidden%20but%20still%20part%20of%20the%20range%20you%20copy%20into.%20Better%20to%20use%20a%20lookup%20function%20to%20%22link%22%20the%20two%20tables.%20Then%20you%20don't%20have%20to%20worry%20about%20the%20sort%20order%20either.%20INDEX%2FMATCH%20or%20XLOOKUP%20would%20work%20well%20in%20your%20case.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3362090%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20paste%20into%20visible%20cells%20in%20excel%20only%20in%20table%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3362090%22%20slang%3D%22en-US%22%3EHi%20Riny%2C%3CBR%20%2F%3E%3CBR%20%2F%3EUnderstood%2C%20thanks%20kindly%20for%20your%20reply!%3CBR%20%2F%3E%3CBR%20%2F%3ERegards%2C%3CBR%20%2F%3EAmy%3C%2FLINGO-BODY%3E
Contributor

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:

AmyYang_0-1652321280285.png



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.

AmyYang_1-1652321314369.png


Thank you,

Amy 

 

2 Replies
best response confirmed by AmyYang (Contributor)
Solution

@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