How to Remove formula form selected different cells in a workbook.

%3CLINGO-SUB%20id%3D%22lingo-sub-2008917%22%20slang%3D%22en-US%22%3EHow%20to%20Remove%20formula%20form%20selected%20different%20cells%20in%20a%20workbook.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2008917%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EHow%20to%20Remove%20formulas%20and%20keep%20the%20results%20from%20different%20cells%20at%20once.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2008917%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2008934%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20Remove%20formula%20form%20selected%20different%20cells%20in%20a%20workbook.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2008934%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F909246%22%20target%3D%22_blank%22%3E%40HariCPIL%3C%2FA%3E%26nbsp%3BPerhaps%20you%20mean%20%3CSTRONG%3ECopy%3C%2FSTRONG%3E%26nbsp%3Ba%20range%20and%20%3CSTRONG%3EPaste%20as%20values%26nbsp%3B%3C%2FSTRONG%3Eon%20top%20of%20itself.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi,

How to Remove formulas and keep the results from different cells at once.

 

1 Reply

@HariCPIL Perhaps you mean Copy a range and Paste as values on top of itself.