Forum Discussion
A very simple Excel problem?
Press the key combination [Ctrl] + [Shift] + [`] (in Excel 2016)
or [Ctrl] + [#] (in Excel 2013).
Now the formulas are displayed in the cells instead of the results.
If your cells refer to other cells, they will be highlighted in color.
or...
display Excel formulas with a button
Open Excel and your edited document.
Click on the "Formulas" tab in the menu bar at the top.
In the Formula Monitor panel, select the Show Formulas button.
Now your formulas are displayed. If there are references to other cells within your formulas, these other cells are highlighted in color.
If you want to see the results in the cells again, press the "Show Formulas" button again.
Hope I could help you with these information
I know I don't know anything (Socrates)
Thanks for your response NikolinoDE . The key options had no effect, but using the 'Show Formulas' button does constitute a workaround. It will be an extra step but at least will minimize the chance of errors that comes with having to retype the entire cell contents from scratch.
I will add that I am running an early version of Excel. One of the documents I'm working with was created back in 1999 and is running in Compatibility mode on an MS Office package that I installed in 2021. I doubt that it matters but I recently took an upgrade to Windows 11.
I would really like to have the original functionality back that seemingly disappeared with no known action by me, i.e. select the cell and have it automatically display the formula.
Again, thanks for your time and workaround solution!
