Showing Formulas in Microsoft Office Excel Instead of Their Results

Sometimes in an Excel worksheet you want to display formulas instead of their results. Here’s how:

1. Click the Office button, and then click Excel Options at the bottom of the menu.

2. Click Advanced, click Display options for this worksheet, click Show formulas in cells instead of their calculated results, and then click OK.