Lose copied Value when un-filter is done

%3CLINGO-SUB%20id%3D%22lingo-sub-1101554%22%20slang%3D%22en-US%22%3ELose%20copied%20Value%20when%20un-filter%20is%20done%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1101554%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%26nbsp%3BI%20copy%20a%20cell%20content%26nbsp%3Band%20after%20I%20filter%20or%20un-filter%20the%20sheet%20I%20lose%20the%20copied%20value.%20What%20can%20I%20do%20to%20not%20lose%20the%20copied%20value%3F%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1101554%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1102350%22%20slang%3D%22en-US%22%3ERe%3A%20Lose%20copied%20Value%20when%20un-filter%20is%20done%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1102350%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F53929%22%20target%3D%22_blank%22%3E%40Natalia%20Nunes%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUnfortunately%2C%20you%20description%20is%20not%20clear%20enough%20for%20me%20to%20assist%20you.%20Can%20you%20share%20a%20sample%20of%20your%20issue%2C%20along%20with%20a%20more%20thorough%20description%20of%20what%20you%20are%20trying%20to%20accomplish%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1102391%22%20slang%3D%22en-US%22%3ERe%3A%20Lose%20copied%20Value%20when%20un-filter%20is%20done%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1102391%22%20slang%3D%22en-US%22%3EHi%2C%3CBR%20%2F%3EPlease%20find%20below%20more%20details%3A%3CBR%20%2F%3E%3CBR%20%2F%3EI%20do%20CTRL%2BC%20in%20one%20cell%20in%20File%20A%20as%20I%20want%20to%20filter%20it%20in%20File%20B%2C%20but%20when%20I%20go%20to%20fIle%20B%20I%20verify%20that%20this%20is%20a%20filter%20applied%20in%20a%20certain%20column%20and%20I%20need%20to%20in-filter.%20By%20doing%20this%20I%20lose%20the%20copied%20cell%20and%20I%20need%20to%20go%20back%20to%20File%20A%20do%20the%20CTRL%2BC%20again%20and%20return%20to%20File%20B%20to%20filter%20that%20copied%20value.%3CBR%20%2F%3E%3CBR%20%2F%3EThis%20happens%20to%20me%20a%20lot%20of%20times%20and%20I%20would%20like%20to%20now%20that%20if%20there%20is%20a%20way%20to%20avoid%20to%20lose%20the%20copied%20cell%20when%20I%20do%20the%20in-filter.%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%2C%3CBR%20%2F%3E%3CBR%20%2F%3ENatalia%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2565366%22%20slang%3D%22en-US%22%3ERe%3A%20Lose%20copied%20Value%20when%20un-filter%20is%20done%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2565366%22%20slang%3D%22en-US%22%3EI%20have%20this%20same%20issue%20and%20have%20not%20been%20able%20to%20find%20a%20solution%20(other%20than%20to%20copy%2Fpaste%20over%20again).%3C%2FLINGO-BODY%3E
New Contributor

Hi,

 

When I copy a cell content and after I filter or un-filter the sheet I lose the copied value. What can I do to not lose the copied value?

Thanks

3 Replies

Hello @Natalia Nunes,

 

Unfortunately, you description is not clear enough for me to assist you. Can you share a sample of your issue, along with a more thorough description of what you are trying to accomplish?

Hi,
Please find below more details:

I do CTRL+C in one cell in File A as I want to filter it in File B, but when I go to fIle B I verify that this is a filter applied in a certain column and I need to in-filter. By doing this I lose the copied cell and I need to go back to File A do the CTRL+C again and return to File B to filter that copied value.

This happens to me a lot of times and I would like to now that if there is a way to avoid to lose the copied cell when I do the in-filter.

Thanks,

Natalia
I have this same issue and have not been able to find a solution (other than to copy/paste over again).