Forum Discussion

Pam Stipanuk's avatar
Pam Stipanuk
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 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.

    • Pam Stipanuk's avatar
      Pam Stipanuk
      Copper Contributor


      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.

  • Freehold_Fred's avatar
    Freehold_Fred
    Copper 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

Resources