Fix Excel Showing a Cell Reference Instead of Linked Text
Question details
The user needs to display the text result of a cell-linking formula instead of the formula or cell reference itself.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A formula such as =A1 is entered to link to another text cell, but the destination cell shows the formula rather than the text stored in A1.
- Observed behavior
- Excel displays the formula or cell reference instead of evaluating it and showing the linked text.
Check whether the worksheet is displaying formulas throughout the sheet or only in the affected cell. Also confirm that the destination cell contains a formula such as =A1 and that the source cell contains text.
Turn off Show Formulas and reset the destination cell format
Use this solution when Excel displays formulas across the worksheet or when the linked cell was previously formatted as Text.
Excel can display formulas instead of results when Show Formulas is enabled. A destination cell formatted as Text can also treat =A1 as plain text instead of evaluating it. Resetting the format and re-entering the formula resolves the second condition.
Open the Formulas tab on the Excel ribbon and click Show Formulas to turn it off. You can also press Ctrl+` to toggle formula display.
Select the destination cell, open the Home tab, expand the Number Format menu, and choose General.
With the destination cell selected, press F2 and then press Enter. Excel will re-evaluate a formula such as =A1 and display the text from cell A1.
Check the formula and source cell directly
Use this check when only one link is affected after Show Formulas has been disabled.
Display Linked Text Correctly with WPS Spreadsheets
WPS Office provides a free, lightweight spreadsheet alternative with a familiar interface for entering formulas, changing cells to General format, and toggling formula display. It supports Microsoft Excel files, making migration straightforward while preserving common spreadsheet workflows.
Frequently Asked Questions
Why does Excel show =A1 instead of the text in cell A1?
Excel may have Show Formulas enabled, or the destination cell may be formatted as Text. Turn off Show Formulas from the Formulas tab, set the cell format to General from Home > Number Format, then press F2 and Enter.
How can I quickly turn off formula display in Excel?
Press Ctrl+` to toggle Show Formulas. You can also open the Formulas tab and click Show Formulas in the Formula Auditing section.
Why does changing the cell format to General not immediately fix the formula?
Changing the format does not always re-evaluate text that was already entered. After selecting General, press F2 and then Enter, or retype the formula and press Enter.
Will a formula like =A1 display text from another cell?
Yes. If A1 contains text and the destination cell is formatted correctly, =A1 returns the text stored in A1. The formula itself remains visible in the formula bar when the destination cell is selected.
