The x in an Excel cell almost always means the cell contains a formula that Excel cannot calculate or display correctly. The most common cause is a #NAME? error, which appears when Excel doesn’t recognize text in a formula — for example, a misspelled function name, a missing colon in a range, or a quoted string that isn’t actually text. But an “x” can also be a literal character you typed, a multiplication symbol, or a checkmark. This article explains each possibility and gives you the exact steps to resolve it.
What the “x” Actually Represents
When you see a plain lowercase “x” in a cell, it is usually one of three things:
- A typed character — you or someone else simply typed the letter x into the cell. This is data, not an error.
- A multiplication sign — in some contexts, people use “x” to mean “times” (e.g., 2×3), but Excel treats it as text, not a calculation. If you type
=2x3, Excel shows a #NAME? error because it reads “x” as a name. - An error indicator — if the cell shows a small green triangle in the corner, hovering over it reveals “The formula in this cell refers to a range that is adjacent to additional numbers.” That’s a warning, not an error, and the “x” might be part of a formula that’s not displaying correctly.
If the cell shows #NAME? and you see an “x” in the formula bar, the problem is almost certainly a text entry where Excel expected a function or a defined name.
Why Does Excel Show #NAME? Instead of a Value?
The #NAME? error appears when Excel cannot identify the text in a formula. Common triggers include:
- Misspelling a function name, e.g.,
=SUMA(A1:A10)instead of=SUM(A1:A10). - Forgetting to enclose text in double quotes, e.g.,
=IF(A1>5, yes, no)— Excel sees yes as an undefined name. - Omitting the colon in a range, e.g.,
=SUM(A1 A10). - Using a defined name that no longer exists.
- Typing a multiplication sign as a letter, e.g.,
=2x3.
To fix it, click the cell, look at the formula bar, and correct the spelling or add quotes. For example, change =2x3 to =2*3 (which returns 6). If you meant to show the letter x, type it without an equals sign.
How to Distinguish a Literal “x” from an Error
Here’s a quick test: select the cell and look at the formula bar (the long box above the grid).
- If the formula bar shows
=2x3, it’s a formula error. - If it shows just
x, it’s text. - If it shows
=A1*x, then “x” is being used as a defined name, which is invalid unless you’ve defined a name called “x” (unlikely).
Also check the cell alignment: text is left-aligned by default, numbers are right-aligned. An “x” that is left-aligned is text; if it’s centered, it might be a checkmark from a symbol font.
Common Scenarios and Exact Fixes
Here are the situations where you’ll see an “x” and what to do:
- You meant to multiply: Replace
=2x3with=2*3. The asterisk is the multiplication operator in Excel. - You meant to type a checkmark: Use the Symbol dialog (Insert > Symbols > Symbol) and choose a checkmark character, or type a capital P in Wingdings font. That shows as a checkmark, not an x.
- You meant to mark a cell as “no”: Just type x as text. No formula needed.
- The cell shows #NAME? with an x in the formula: Correct the formula. For example, if you have
=VLOOKUP(A1, x, 2, FALSE)and “x” is not a defined range, change it to the actual range like$A$1:$B$10. - You see a green triangle with an x: That’s an error checking indicator. Click the cell, click the yellow diamond icon, and choose the appropriate action (e.g., “Ignore Error” if the x is intentional).
How to Prevent the #NAME? Error in the Future
You can avoid most “x”-related errors with these habits:
- Always use
*for multiplication, never x or ·. - Enclose all text in double quotes in formulas, e.g.,
=IF(A1>5,"yes","no"). - Use the Function Wizard (the fx button) to insert functions correctly.
- Check for missing colons in ranges — a space instead of a colon creates an intersection operator, which can also cause errors.
- If you use defined names, verify they exist under Formulas > Name Manager.
What If the “x” Is a Cross-Out or Strikethrough?
Sometimes users format a cell with strikethrough (Ctrl+5 on Windows, Cmd+Shift+X on Mac) to indicate a cancelled item. That’s not an error — it’s just formatting. To remove it, select the cell, press Ctrl+5 (Windows) or Cmd+Shift+X (Mac) again, or go to Home > Font > Strikethrough.
If you see a red x icon in the cell, that’s a data validation error. Excel shows a red circle with an x when a cell violates a validation rule (e.g., you entered a number when the rule allowed only text). To fix it, either change the input or adjust the rule under Data > Data Validation.
Frequently Asked Questions
Why does my formula show #NAME? when I type =SUM(A1:A10)?
That happens if you typed the function name incorrectly, like =SUMA or =SOM. Excel only recognizes exact function names. Check the spelling and try again. If you’re using a non-English version, the function might have a localized name (e.g., SUMME in German), but in English Excel it’s SUM.
How do I type a multiplication sign in Excel?
Use the asterisk key (*) on your keyboard. For example, type =5*3 to get 15. If you want to display a multiplication symbol as text, you can insert it from Insert > Symbol, but it won’t calculate.
Can I use “x” as a variable in a formula?
No, not directly. Excel doesn’t allow single letters as variables unless you define them as names. You can define a name “x” via Formulas > Define Name, but it’s simpler to use cell references like A1. Using an undefined “x” in a formula causes a #NAME? error.
Why does my cell show an x but the formula bar is empty?
That means the x is a literal text entry, not a formula. If you want to remove it, select the cell and press Delete. If you want to keep it but avoid the green triangle, you can ignore the error or set error checking to not flag text entries.
What does a small red x in the corner of a cell mean?
That’s a data validation error indicator. It appears when you enter a value that doesn’t meet the validation criteria set for that cell (e.g., the rule requires a number between 1 and 10, but you typed 20). Click the cell, choose “Retry” to enter a valid value, or “Cancel” to revert.
Is there a shortcut to find all cells with #NAME? errors?
Yes. Press Ctrl+G (Windows) or Cmd+G (Mac) to open the Go To dialog, click “Special,” select “Formulas,” then uncheck all boxes except “Errors,” and click OK. Excel will select all error cells, including #NAME?. Then you can cycle through them with Tab and fix each one.
Related
- Excel Utility for E-Invoice: What It Does
- Excel Undo Encrypt with Password? How to Remove It
- Excel Truck Group Jobs: Pay, Hiring & Reviews
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Excel Error Bars in Cells: What You Can Do InsteadNo: Excel does not have a native feature that places statistical error bars inside an individual worksheet cell.…
- Excel MATCH Not Working With Numbers? Causes and FixesExcel MATCH usually fails to find a number because the lookup value and the values in the search…
- Excel Conditional Formatting: Apply Rules and Fix IssuesTo apply conditional formatting in Excel for Microsoft 365 on Windows, select the cells, then choose Home >…
- Excel MATCH Function Not Working With Numbers? FixesIf Excel’s MATCH function cannot find a number, first check whether the lookup value and the numbers in…
- Wrap Text in Excel: How It Works and How to Fix ItYes. In Excel for Microsoft 365 on Windows, select the cell or cells, then choose Home > Alignment…
- Excel Shows Formula Not Result? Fix It FastIf your Excel cell shows the formula text (like =A1+B1) instead of the calculated value, the most common…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.