Forum Discussion
how to delete 'Show Formulas"
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
Press Ctrl+` or activate the Formulas tab of the ribbon and click to unhighlight the 'Show Formulas' button in the 'Formula Auditing' group.
