Excel: Show formula line - how it works
We show you how to display the formula line in Excel in our instructions for Excel 2007 and 2010.
Show formula line in Excel - Excel 2007
- Open Excel 2007 and click the Office button at the top left.
- Select "Excel Options" and scroll to "Display" in the "Advanced" tab.
- Activate the "Show processing line" box here.
Show formula line in Excel - Excel 2010
- In Excel 2010, click File, and then click Options.
- Select the "Advanced" tab and go down a few sections to "Display".
- Here you activate the checkbox "Show processing line" and confirm with "OK".
Also read our tips against a misaligned keyboard.