Home

show/display formulas in Excel 365 online

%3CLINGO-SUB%20id%3D%22lingo-sub-116516%22%20slang%3D%22en-US%22%3Eshow%2Fdisplay%20formulas%20in%20Excel%20365%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-116516%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20I%20get%20formulas%20on%20a%20sheet%20to%20display%3F%26nbsp%3B%20I%20am%20a%20teacher%20-%20I%20need%20to%20%22see%22%20the%20formulas%20that%20students%20have%20used%20in%20order%20to%20grade%20the%20assignment.%26nbsp%3B%20In%20Office%202013%2C%20we%20would%20use%20the%20Fn%20%2B%20~%20key%20and%20the%20formulas%20for%20the%20entire%20sheet%20would%20show%20up.%26nbsp%3B%20We%20can't%20figure%20out%20how%20to%20see%20them%20in%20Excel%20365%20Online%20which%20is%20the%20only%20program%20compatible%20with%20Chromebooks.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-116516%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analytics%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-306040%22%20slang%3D%22en-US%22%3ERe%3A%20show%2Fdisplay%20formulas%20in%20Excel%20365%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-306040%22%20slang%3D%22en-US%22%3E%3CP%3EExcel%20365%2FOnline%20Tip%3A%3C%2FP%3E%3CP%3ECtrl%2B~%20does%20not%20work%20as%20expected%3C%2FP%3E%3CP%3EAlternative%20is%20to%20do%20a%20replace%3C%2FP%3E%3CP%3ELook%20for%20%3D%3C%2FP%3E%3CP%3EReplace%20with%20'%3D%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExplanation%3A%3C%2FP%3E%3CP%3EThe%20leading%20'%20(single%20quote%20or%20apostrophe)%20will%20transform%20formulas%20into%20text.%3C%2FP%3E%3CP%3ETo%20revert%20back%2C%20just%20do%20an%20undo.%3C%2FP%3E%3CP%3EUnfortunately%20there%20will%20not%20be%20any%20row%20(1%2C2%2C3%2C%20etc.)%20and%20column%20headings%20(A%2CB%2CC%2C%20etc.)%20option.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESteps%3A%3C%2FP%3E%3CP%3E1)%20Find%20%26amp%3B%20Select%3C%2FP%3E%3CP%3E2)%20Replace%3C%2FP%3E%3CP%3E3)%20Find%20what%3A%20%3D%3C%2FP%3E%3CP%3E4)%20Replace%20with%3A%20'%3D%3C%2FP%3E%3CP%3E5)%20Replace%20All%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEnjoy%20%E2%98%BA!%3C%2FP%3E%3CP%3EFreehold%20Fred%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-116959%22%20slang%3D%22en-US%22%3ERe%3A%20show%2Fdisplay%20formulas%20in%20Excel%20365%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-116959%22%20slang%3D%22en-US%22%3EI%20see%20that%20request%20is%20already%20there%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F274580-excel-online%2Fsuggestions%2F6828345-show-formulas%23comments%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexcel.uservoice.com%2Fforums%2F274580-excel-online%2Fsuggestions%2F6828345-show-formulas%23comments%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-116957%22%20slang%3D%22en-US%22%3ERe%3A%20show%2Fdisplay%20formulas%20in%20Excel%20365%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-116957%22%20slang%3D%22en-US%22%3E%3CP%3EIt%20is%20functionality%20that%20on-line%20Excel%20does%20not%20have%20I'm%20afraid.%20Not%20yet%20as%20MSFT%20updates%20on-line%20Excel%20quite%20frequently.%20If%20you%20think%20this%20is%20an%20important%20feature%2C%20ask%20for%20it%20at%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F274580-excel-online%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexcel.uservoice.com%2Fforums%2F274580-excel-online%3C%2FA%3Eand%20try%20to%20get%20as%20many%20votes%20as%20you%20can.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-116879%22%20slang%3D%22en-US%22%3ERe%3A%20show%2Fdisplay%20formulas%20in%20Excel%20365%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-116879%22%20slang%3D%22en-US%22%3E%3CP%3E%3CBR%20%2F%3EThank%20you.%20%26nbsp%3BWe%C4%BAl%20try%20that.%20%26nbsp%3BWe%20were%20hoping%20for%20a%20quick%20%C3%B3ne%20button'way%20to%20see%20the%20entire%20page%20of%20all%20formulas%20used%20at%20once%2C%20but%20maybe%20that%20ability%20doesnt%20exist%20any%20longer.%20%26nbsp%3BThanks%20for%20replying%20with%20the%20idea.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-116851%22%20slang%3D%22en-US%22%3ERe%3A%20show%2Fdisplay%20formulas%20in%20Excel%20365%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-116851%22%20slang%3D%22en-US%22%3EYou%20could%20use%20the%20FORMULATEXT%20function%20in%20adjacent%20cells.%3C%2FLINGO-BODY%3E
Pam Stipanuk
New Contributor

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.

5 Replies
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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies