How to Show Formulas in a Cell

When editing a formula, you need to double click the cell to see the formula first. When double-clicking a cell with a formula, you can see the formula, but the cell will show results once you move the mouse cursor out. Please see below to show formula instead of the results in a cell. If you want to show formulas in all cells, please check the post How to Show all Formulas.

Step 1: Double click the cell in the worksheet that contains a formula(e.g., B3);

Step 2: Enter a punctuation mark (') in front of the formula;

Step 3: Press Enter key from the keyboard to move the cursor out.

Leave a Reply