how to delete 'Show Formulas"

Copper 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