Forum Discussion

Copper Contributor

Oct 13, 2017

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 ...

BI & Data Analytics

Need Help

JKPieterse

Silver Contributor

Oct 16, 2017

You could use the FORMULATEXT function in adjacent cells.

Pam Stipanuk
Copper Contributor
Oct 16, 2017

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.
- JKPieterse
  Silver Contributor
  Oct 16, 2017
  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.
  - JKPieterse
    Silver Contributor
    Oct 16, 2017
    I see that request is already there:
    https://excel.uservoice.com/forums/274580-excel-online/suggestions/6828345-show-formulas#comments