MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Why is my worksheet displaying formulas instead of values?

Posted by Paul on June 15, 2001 7:48 AM

For some reason one of the spreadsheets I work on is displaying formulas instead of values. Is there an option to return to the normal view (with the results of the formulas in each cell)?



Posted by Aladin Akyurek on June 15, 2001 7:52 AM

Check out "Formula" on the View tab of Edit|Preferences (Mac) or Tools|options (Windows).


Posted by Russell on June 15, 2001 8:41 AM

Also, you can hit Ctrl+` (that's the accent key - it's upper-left with the ~ also on it) to toggle back and forth between formulas and results.