Nov 06 2020 12:08 PM
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!!
Nov 06 2020 12:16 PM
Press Ctrl+` or activate the Formulas tab of the ribbon and click to unhighlight the 'Show Formulas' button in the 'Formula Auditing' group.