This can be useful when investigating why a certain formula isn’t working correctly or when grading your students’ worksheets to ensure they are using formulas correctly. Display formulas using the ...

To display the formulas in the sheet instead of the results in Excel, you can go through the steps above. First, open the Excel Options panel and go to the Advanced tab.