Excel x in Cell: What It Means & How to Fix It

Errors & fixes · Updated November 22, 2026

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 =2x3 with =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

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.