Oct 13 2017
01:55 PM
- last edited on
Jul 12 2019
10:53 AM
by
TechCommunityAP
Oct 13 2017
01:55 PM
- last edited on
Jul 12 2019
10:53 AM
by
TechCommunityAP
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.
Oct 16 2017 06:27 AM
Oct 16 2017 08:14 AM
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.
Oct 16 2017 11:53 AM - edited Oct 16 2017 11:54 AM
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.
Oct 16 2017 11:56 AM
Dec 22 2018 11:50 PM - edited Dec 22 2018 11:55 PM
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