在这篇文章中,我们将向您展示修复 #NAME?Microsoft Excel中的错误。在讨论纠正#NAME?
错误的教程之前,让我们了解一下为什么Excel会出现这个错误。
为什么我会看到#NAME?Excel中的错误?
以下是您看到#NAME(NAME)的可能原因?Excel中的错误消息:
- 当您输入错误的公式名称或字符串或公式中有一些拼写错误时,它会返回 # NAME ? 单元格中的错误消息。
- 它表明您使用的语法有问题,需要更正。
- 如果您使用的公式引用了未定义的名称,您将收到此错误消息。
- 如果范围引用中缺少冒号,它将返回 # NAME ? 错误。
- 你会看到一个#NAME?如果您正在使用某些需要加载项的功能并且加载项被禁用,则会出现错误消息。
现在,如何解决#NAME?Excel中的错误?与Excel中的其他一些错误不同,例如#DIV/0! error,无法使用任何错误处理函数(如IFERROR )修复此错误。在这里,我们将列出一些解决方案来修复和纠正 # NAME ? 错误。
如何删除#NAME?Excel 中的错误
以下是更正或修复#NAME的方法?Excel工作簿中的错误:
- 使用(Use)公式建议或函数向导(Function Wizard)来避免语法错误。
- 手动检查函数中的任何拼写错误并更正。
- 检查公式中使用的名称是否在Name Manager中定义。
- 确保文本值周围有引号。
- 启用所用功能所需的插件。
现在让我们详细讨论这些方法!
1]使用(Use)公式建议或函数向导(Function Wizard)来避免语法错误
(Microsoft Excel)一旦您开始在函数栏中键入函数,Microsoft Excel就会显示匹配公式的列表。
确保(Make)您使用建议中的公式,而不是手动输入所有公式。如果您手动输入公式,则会增加输入错误的机会,从而显示 # NAME ? 错误。
您还可以使用函数向导( Function Wizard)来避免任何语法错误。F
或者,只需选择单元格并转到“公式(Formulas)”选项卡,然后单击“插入函数(Insert Function)”选项。将打开一个插入函数(Insert Function)向导,您可以在其中选择需要输入单元格的公式。
2 ]手动(] Manually)检查功能中的错字并更正
如果有一些小的错别字,您可以手动更正它们。只需查看您使用的函数并检查它以查看公式字符串中是否存在拼写错误。
如果是这样,只需更正它,它将消除#Name?错误。如果出现此错误的其他原因,请使用本文中的另一种方法进行修复。
3]检查(Check)公式中使用的名称是否在名称管理器中定义(Name Manager)
如果您没有定义在公式中有引用的名称,它会返回 # Name ? 错误。因此,使用Excel中的(Excel)名称(Name) 管理器(Manager)检查和定义名称。您可以按照以下步骤进行操作:
在 Excel 中,转到“公式( Formulas)”选项卡,然后单击“定义名称( Defined Name)”下拉按钮。然后,选择名称管理器(Name Manager)选项。
在名称管理器(Manager)窗口中,查看您使用的名称是否已定义。如果没有,请单击新建(New)按钮。
现在,输入名称并单击“确定”按钮。
使用您刚刚定义的名称重新输入(Reenter)公式,您将看不到 # NAME ? 现在出错。
4]确保文本值周围有引号
如果您在公式中使用文本引用,则必须将它们括在引号中。否则,你会得到一个#NAME?单元格中的错误消息。
解决方案是仔细查看公式字符串并检查是否正确添加了引号。如果没有,只需在文本引用周围加上引号。这将修复错误。
5]启用(Enable)使用的功能所需的加载项
一些自定义Excel函数需要加载项才能工作。例如,EUROCONVERT函数需要Euro Currency Tools插件才能工作。此外,各种统计和工程宏功能需要启用Analysis ToolPak插件。因此,只需启用所需的加载项,它就不会返回#Name?错误。
以下是在Excel中启用加载项的步骤:
- 转到文件(File)菜单并单击 选项(Options)。
- 导航到“加载项(Add-ins)”选项卡,然后单击“管理 Excel 加载项(Manage Excel Add-ins)”选项旁边的“开始”( Go)按钮。
- 在加载项(Add-ins)对话框窗口中,启用相关复选框以打开所需的加载项。
- 点击OK按钮,看看 #Name是否(Name)?错误已修复。
就是这样!希望这篇文章可以帮助您修复#NAME?Microsoft Excel中的错误。
现在阅读:(Now read:) 如何修复 Excel 中的运行时错误 1004(How to Fix Runtime Error 1004 in Excel)
How to remove #NAME? Error in Excel?
In this post, we are going to show yоu a tutorial to fix #NAME? error in Microsoft Excel. Before talking about the tutorial to correct #NAME?
error, let us understand why does this error occurs in Excel.
Why do I see #NAME? error in Excel?
Here are the possible reasons due to which you see a #NAME? error message in Excel:
- When you have entered a wrong formula name or string or there is some typo in the formula, it returns #NAME? error message in the cells.
- It indicates that something is wrong with the syntax you have used and that needs to be corrected.
- If you have used a formula that refers to a name that is not defined, you will get this error message.
- In case there is a colon missing in the range reference, it will return #NAME? error.
- You will see a #NAME? error message if you are using some function that needs an add-in, and the add-in is disabled.
Now, how to resolve #NAME? error in Excel? Unlike some other errors in Excel, e.g., #DIV/0! error, this error can’t be fixed using any error handling function like IFERROR. Here, we are going to list some solutions to fix and correct #NAME? error.
How to remove #NAME? Error in Excel
Here are the methods to correct or fix the #NAME? error in your Excel workbooks:
- Use formula suggestions or Function Wizard to avoid syntax errors.
- Manually check for any typo in the function and correct it.
- Check if the name used in the formula is defined in Name Manager.
- Ensure that the text values have quotation marks around them.
- Enable the add-in required by the used function.
Let have a detailed discussion on these methods now!
1] Use formula suggestions or Function Wizard to avoid syntax errors
Microsoft Excel displays a list of matching formulas as soon as you start typing the function in the function bar.
Make sure you use a formula from the suggestions rather than typing it all manually. If you type a formula manually, it increases the chances of typing errors and thus showing a #NAME? error.
You can also use the Function Wizard to avoid any syntactic errors. F
or that, simply select the cell and go to the Formulas tab and click on the Insert Function option. An Insert Function wizard will open up where you can select the formula you need to enter to the cell.
2] Manually check for the typo in the function and correct it
If there are some minor typos, you can correct them manually. Just have a look at the function you have used and inspect it to see if there is a spelling error in the formula string.
If so, simply correct it and it will eliminate #Name? error. In case there is some different cause for this error, use another method from this article to fix it up.
3] Check if the name used in the formula is defined in Name Manager
In case you haven’t defined a name that has a reference in your formula, it returns #Name? error. So, check and define a name using the Name Manager in Excel. You can follow the below steps to do so:
In Excel, go to the Formulas tab and click on the Defined Name drop-down button. And then, select the Name Manager option.
In the Name Manager window, see if the name you have used is defined or not. If not, click on the New button.
Now, enter the name and click the OK button.
Reenter the formula with the name you just defined and you won’t see the #NAME? error now.
4] Ensure that the text values have quotation marks around them
If you are using text references in the formula, you must enclose them in quotation marks. Else, you will get a #NAME? error message in the cells.
The solution is that look closely at the formula string and check if the quotation marks are added properly. If not, simply put the quotation marks around the text references. This will fix the error.
5] Enable the add-in required by the used function
Some custom Excel functions need add-ins to work. For example, the EUROCONVERT function needs Euro Currency Tools add-in to work. Also, various statistical and engineering macro functions require Analysis ToolPak add-in to be enabled. So, simply enable the required add-in and it won’t return #Name? error.
Here are the steps to enable the add-in in Excel:
- Go to the File menu and click on Options.
- Navigate to the Add-ins tab and click on the Go button present beside the Manage Excel Add-ins option.
- In the Add-ins dialog window, enable the relevant checkboxes to turn on the required add-in.
- Tap on the OK button and see if the #Name? error is fixed.
That’s it! Hope this article helps you fix #NAME? error in Microsoft Excel.
Now read: How to Fix Runtime Error 1004 in Excel