How to Show all Formulas in Excel

When working with Excel, you can show formula only in a cell, or you can show all formulas in a worksheet with the steps below:

Step 1: Click any cell in the worksheet;

Step 2: Click the "Formula" tab from the Ribbon;

Step 3: Click "Show Formulas" in the Formula Auditing section;

Step 4: You will see all the formulas.

Leave a Reply