Fix Excel Showing a Worksheet Reference Instead of a Cell Value
Question details
The user needs an Excel worksheet reference to display the referenced cell value instead of the formula.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A cell refers to another worksheet with a formula such as =Title!B31.
- Observed behavior
- Excel displays the worksheet reference as text instead of the referenced value.
Select the affected cell and check whether its number format is Text on the Home tab. Also note whether other formula cells display formulas instead of results.
Change the cell format and re-enter the reference
Use this when the affected cell was formatted as Text before the formula was entered.
Click the cell displaying a reference such as =Title!B31.
On the Home tab, open the Number Format list and select General.
Click the formula bar, confirm the reference begins with =, and press Enter. Changing the format alone does not convert the existing text into a formula.

Turn off Show Formulas in Excel
Use this if multiple formula cells display their formulas instead of calculated values.
Check the worksheet reference syntax
Use this to ensure Excel can interpret the reference as a formula.
Work with worksheet references in WPS Spreadsheet
WPS Office is a free, lightweight alternative for working with spreadsheets. Its familiar interface and Excel format compatibility make it easy to move existing workbooks into WPS Spreadsheet.

Frequently Asked Questions
Why does Excel show =Title!B31 instead of the value?
The cell may have been formatted as Text when the formula was entered, or Show Formulas may be enabled. Set the cell to General on the Home tab, re-enter the formula, and check Formulas > Show Formulas.
Why did changing the cell format to General not fix the formula?
Changing the format does not automatically convert an existing text entry into a formula. After selecting General, click the formula bar and press Enter to re-enter the reference.
How do I reference a worksheet whose name has spaces?
Enclose the worksheet name in single quotation marks, followed by an exclamation mark and the cell reference. For example, enter ='Project Title'!B31.
How can I create a reference by clicking another worksheet?
In the destination cell, type =, click the source worksheet tab, select the source cell, and press Enter. Excel inserts the worksheet reference for you.




