Any option to View Formulas and formats

Copper Contributor

In Excel any option to view , whateve used  formulas , hyperlinks , conditional formatting and so on ??

1 Reply


I put your question through a translator:


Yes, there are ways to view used formulas, hyperlinks, and conditional formatting in Excel:

  1. Formulas: To switch between viewing the results and viewing the formulas that return the results, pr...1.

  2. Hyperlinks: There isn’t a built-in feature to view all hyperlinks. However, you can use Excel’s Find feature (Ctrl+F) and search for “http://” or “https://”, which might be a part of most hyperlinks.

  3. Conditional Formatting: