how to delete 'Show Formulas"

%3CLINGO-SUB%20id%3D%22lingo-sub-1862394%22%20slang%3D%22en-US%22%3Ehow%20to%20delete%20'Show%20Formulas%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1862394%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20my%20extensive%20spreadsheet%20I%20have%20many!%20formula%3B%20on%20one%20I%20received%20an%20error%20message%20so%20I%20clicked%20on%20it%20and%20had%20several%20options%3B%20one%20was%26nbsp%3B%20'SHOW%20FORMULAS%22%2C%20thinking%20it%20would%20be%20for%20only%20that%20one%20cell%2C%20but%20it%20now%20shows%20for%20every%20cell%20with%20a%20formula%20and%20my%20spreadsheet%20is%20now%2020x%20longer%3B%20I%20have%20tried%20everything%20to%20revert%20back%20to%20the%20formula%20result%20showing%20without%20the%20actual%20formula.%20HELP!%20Thanks!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1862394%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1862461%22%20slang%3D%22en-US%22%3ERe%3A%20how%20to%20delete%20'Show%20Formulas%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1862461%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F860539%22%20target%3D%22_blank%22%3E%40RGY97702%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPress%20Ctrl%2B%60%20or%20activate%20the%20Formulas%20tab%20of%20the%20ribbon%20and%20click%20to%20unhighlight%20the%20'Show%20Formulas'%20button%20in%20the%20'Formula%20Auditing'%20group.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S0009.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F231981i41F30B5D063EAF2C%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22S0009.png%22%20alt%3D%22S0009.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%E2%80%83%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1865350%22%20slang%3D%22en-US%22%3ERe%3A%20how%20to%20delete%20'Show%20Formulas%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1865350%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

In my extensive spreadsheet I have many! formula; on one I received an error message so I clicked on it and had several options; one was  'SHOW FORMULAS", thinking it would be for only that one cell, but it now shows for every cell with a formula and my spreadsheet is now 20x longer; I have tried everything to revert back to the formula result showing without the actual formula. HELP! Thanks!!

2 Replies

@RGY97702 

Press Ctrl+` or activate the Formulas tab of the ribbon and click to unhighlight the 'Show Formulas' button in the 'Formula Auditing' group.

 

S0009.png

@Hans Vogelaar 

 

Thanks for your help