Excel - How to display formulas in spreadsheet?

April 2018






Issue


I want to display all formulas in my Excel spreadsheet, but I don't know how to activate this feature. Any solutions?

Solution


To view the formulas in Excel:
  • Click on Tools, Options, display, and Check "Formula".
Published by aakai1056. Latest update on December 26, 2011 at 11:01 AM by aakai1056.
This document, titled "Excel - How to display formulas in spreadsheet?," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (https://ccm.net/).
Excel - Transfer data between several sheets
Excel - Summarize the content of multiple columns