Forum Discussion
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 the formulas for the entire sheet would show up. We can't figure out how to see them in Excel 365 Online which is the only program compatible with Chromebooks.
Thanks.
- You could use the FORMULATEXT function in adjacent cells.
Thank you. Weĺl try that. We were hoping for a quick óne button'way to see the entire page of all formulas used at once, but maybe that ability doesnt exist any longer. Thanks for replying with the idea.It is functionality that on-line Excel does not have I'm afraid. Not yet as MSFT updates on-line Excel quite frequently. If you think this is an important feature, ask for it at https://excel.uservoice.com/forums/274580-excel-online and try to get as many votes as you can.
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
