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.