Forum Discussion
Pam Stipanuk
Oct 13, 2017Copper Contributor
show/display formulas in Excel 365 online
How do I get formulas on a sheet to display? I am a teacher - I need to "see" the formulas that students have used in order to grade the assignment. In Office 2013, we would use the Fn + ~ key and ...
Freehold_Fred
Dec 23, 2018Copper Contributor
Excel 365/Online Tip:
Ctrl+~ does not work as expected
Alternative is to do a replace
Look for =
Replace with '=
Explanation:
The leading ' (single quote or apostrophe) will transform formulas into text.
To revert back, just do an undo.
Unfortunately there will not be any row (1,2,3, etc.) and column headings (A,B,C, etc.) option.
Steps:
1) Find & Select
2) Replace
3) Find what: =
4) Replace with: '=
5) Replace All
Enjoy ☺!
Freehold Fred