Fix Excel Cells That Insert References Instead of Text
Question details
Troubleshoot Excel cells that appear blank, reject text, numbers, or formulas, or insert cell references during entry.

- Product
- Microsoft Excel for Microsoft 365
- Device & OS
- not provided
- Scenario
- The user wants to enter text, numbers, and formulas normally in an Excel workbook.
- Observed behavior
- Cells may appear blank or reject entries, and cell references may be inserted while the user is typing.
Try entering text and a number in a new blank workbook to see whether the behavior occurs in one file or across Excel. Note whether the issue starts after clicking another cell while editing a formula.
Check Cell Entry Mode and Worksheet Protection
Use these checks when the problem occurs in a particular cell or workbook.
Press Esc to cancel an unfinished entry, then click the cell and type your text or number again. Press Enter to finish.
If you are editing a formula, clicking another cell normally inserts its reference. Type the formula in the cell or formula bar and press Enter when finished.
To display an entry such as =example as text rather than a formula, type an apostrophe first: '=example.
Open Review and look for Unprotect Sheet. If the sheet is protected, select Unprotect Sheet and enter the password if prompted, or ask the workbook owner for access.
Select the cell and check the formula bar for existing content. If content is present but not visible, open Home > Number Format and check whether a custom format is hiding it.

Update Excel and Test Add-Ins in Safe Mode
Use this approach if the issue occurs across workbooks or may be caused by an add-in.
Repair Microsoft 365 or Use Excel for the Web
Try an Online Repair when the issue affects every workbook, or use the web version as a temporary workaround.
Edit Spreadsheets with WPS Office
WPS Office is a free, lightweight alternative for working with spreadsheets in a familiar interface. Open compatible Excel files in WPS Spreadsheet to continue editing without fixing the Excel application itself.

Frequently Asked Questions
Why does Excel insert a cell reference when I click another cell?
When you are entering or editing a formula, clicking a cell normally adds its reference to the formula. Press Enter to finish the formula or Esc to cancel it before selecting another cell.
How can I tell whether an add-in is causing the problem?
On Windows, close Excel, press Windows+R, enter excel /safe, and test cell entry. If it works in Safe Mode, use File > Options > Add-ins to disable add-ins and test them one at a time.
What should I check if a cell looks blank but contains data?
Select the cell and inspect the formula bar. If content appears there, check Home > Number Format for a custom format that may be hiding the value.
Can worksheet protection prevent me from entering data?
Yes. A protected sheet can prevent changes to locked cells. Check Review > Unprotect Sheet, and ask the workbook owner for the password if one is required.
Can I edit the workbook while troubleshooting desktop Excel?
You can try opening the workbook from OneDrive in Excel for the web. Test your entries there while you investigate the desktop application.




