Office Settings & Configuration

Fix Excel Cells That Insert References Instead of Text

Camila MilosovichCamila Milosovich Nov 14, 2026 868 views

Question details

Troubleshoot Excel cells that appear blank, reject text, numbers, or formulas, or insert cell references during entry.

Fix Excel Cells That Insert References Instead of Text
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.
Before you start

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.

Solution 1Recommended

Check Cell Entry Mode and Worksheet Protection

Use these checks when the problem occurs in a particular cell or workbook.

1
Exit the current entry

Press Esc to cancel an unfinished entry, then click the cell and type your text or number again. Press Enter to finish.

2
Check formula entry

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.

3
Enter text that begins with an equals sign

To display an entry such as =example as text rather than a formula, type an apostrophe first: '=example.

4
Check worksheet protection

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.

5
Inspect a blank-looking cell

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.

Check Cell Entry Mode and Worksheet Protection
Free Microsoft Office alternative

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.

Enter text, numbers, and formulas in WPS SpreadsheetCompatible with Microsoft Excel formats, including XLSX and XLSFamiliar spreadsheet interface for an easier transitionFree and lightweight office suite
microsoft office alternative - wps office

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.