如果您经常使用Microsoft Excel,您可能会遇到无法在Excel工作表中键入任何内容的错误。幸运的是,这是一个非常常见的问题(以及其他Excel 响应问题)(Excel responsiveness issues),并且有多种方法可以解决该问题。
如果您想知道“为什么我不能在Excel中输入内容?” 我们有六种修复方法可供尝试。

1. 启用编辑
如果您打开了不是您创建的电子表格(即由其他人发送给您或从网络下载的电子表格),您可能会发现它受到保护。您会知道,当您打开文件时,您会发现无法在单元格中输入任何文本。那么如何解决这个问题呢?
- 打开受保护的电子表格时,您会在电子表格顶部看到一个黄色弹出窗口,其中显示:“受保护的视图请小心 - 来自互联网的文件可能包含病毒。除非您需要编辑,否则留在受保护的视图(Protected View)中会更安全。”
- 旁边有一个灰色按钮,标记为“启用编辑”。

- 要将文本输入到受保护的电子表格中,只需单击“启用编辑”(Editing)。
- 然后您应该发现您可以输入文本并保存更改后的工作表。
2.取消保护您的工作表或工作簿
您尝试输入的工作表或工作簿可能受到保护。如果是这种情况,Excel不会让您在工作表中键入任何数据,并且会显示一条消息让您知道。取消对工作表或工作簿的保护很容易,以便您可以输入数据,但如果工作表或工作簿受密码保护,您将需要创建它的人的密码。

- 单击“审阅”选项卡。
- 如果您尝试输入的工作表或工作簿受到保护,您应该会看到“取消保护工作表”(Sheet)或“取消保护工作簿”(Unprotect Workbook)选项。
- 要将文本输入到受保护的工作表或工作簿中,只需选择取消保护工作表(Unprotect Sheet)或取消保护工作簿(Unprotect Workbook)。
- 如果文档受密码保护,您将看到一个弹出窗口,提示您输入密码。输入它,然后单击“确定”。
- 您现在应该能够在工作表或工作簿中输入文本并保存更改。

3. 禁用数字锁定
这听起来似乎很明显,但您是否尝试使用键盘右侧单独的数字小键盘在Excel工作表或工作簿中键入数字?如果出现这种情况并且您无法输入任何数字,则可能是NumLock已打开。

以下是禁用它的方法。
- 查找键盘上的NumLock键。(NumLock)某些按键上有一个LED,该 LED 会亮起以表明NumLock已打开。
- 按(Press)NumLock键可关闭(或打开) NumLock。
注意:许多现代键盘没有单独的数字小键盘,因此没有NumLock键。
4. 明确的数据验证规则
数据(Data)验证规则可以限制用户可以输入的值 - 例如,您可以提供指定值的范围,例如从 0 到 100 的整数。如果您尝试输入任何其他值,这将导致错误消息。

这里有两个选项:您可以遵守数据验证限制,或者如果您不确定需要什么输入值,请联系工作表创建者。或者您可以删除数据验证限制。以下是如何做到这一点。
- 选择应用了数据验证限制的单元格。
- 单击(Click)“数据”(Data)选项卡,然后选择“数据工具”(Data Tools)下的“数据验证”(Data Validation)。
- 选择全部清除,然后单击确定。
- 您现在应该能够在单元格中输入任何值。

5.禁用加载项
如果您最近在Excel(Excel)中安装了新的加载项,这可能是您无法在Excel中输入内容的原因。通过在安全模式下启动Excel,您可以确定是否是加载项导致了此问题。如果Excel 没有响应,(Excel is not responding)以安全模式启动Excel也是一个很好的解决方案。
如何以安全模式启动 Excel
以下是如何在安全模式下启动Excel。
- 关闭当前的Excel文档 - 确保首先保存所有更改。
- 按 Windows 键 + R。
- 在“运行”(Run)框中,在“打开”字段中
键入Excel/safe
- 单击“确定”。
- Excel 将以安全模式启动。
- 尝试在表格中输入内容以查看问题是否已解决。

仍然无法在Excel中输入内容?现在您知道是某个加载项导致了问题,唯一的问题是,您如何知道哪个加载项是罪魁祸首?
禁用加载项
首先,您需要确定哪个加载项有问题,然后将其删除。以下是如何做到这一点。
- 打开 Excel 并转到“文件”选项卡。
- 在选项下,选择加载项。
- 在底部“管理”(Manage)旁边,从下拉菜单中
选择“COM 加载项” 。(COM Add-Ins)
- 按开始。
- 应出现已安装加载项的列表。
- 选中一个加载项的复选框,不选中其他加载项。
- 选择确定。

- 重新启动 Excel。
- 尝试在工作表中输入内容。如果您能够打字,您就知道这个加载项不是有问题的。
- 重复(Repeat)步骤 1 到 9 以确定是哪个加载项导致了问题。
- 找出有问题的加载项后,重复步骤 1 到 5 以显示已安装加载项的列表,但这次选中有问题的加载项的复选框,然后单击“删除”将其卸载(Remove)。
- 重新启动 Excel(Restart Excel)并尝试输入 — 希望您现在在输入文本时不会遇到任何问题。
6.调整编辑选项
如果公式应用于单元格,您通常可以双击该单元格或按 F2 键来查看公式并对其进行编辑。如果按 F2 或双击单元格但无法编辑公式或在单元格中键入内容,则需要调整编辑选项。以下是如何做到这一点。
- 转到“文件”(File)选项卡并选择“选项”。
- 在“Excel 选项”(Options)对话框中,选择“高级”(Advanced)。
- 在“编辑选项”(Editing Options)下,确保选中“允许直接(Allow Editing Directly)在单元(Cells)格中编辑”框。
- 单击“确定”。
- 您现在应该能够在任何单元格中键入内容来编辑公式。

如您所见,如果您无法在Excel(Excel)中输入内容,则可能有多种原因导致出现此问题。幸运的是,如果您遇到此问题,还可以尝试许多快速简便的修复方法,因此您应该可以立即重新启动并运行。
Can’t Type in Microsoft Excel? 6 Fixes to Try
If you use Microsoft Excel frequently, you might have run into the error where you can’t type anything into an Excel sheet. Luckily, this is a pretty common problem—alongside other Excel responsiveness issues—and there are several ways to solve the issue.
If you’re wondering, “Why can’t I type in Excel?” We’ve got six fixes to try.

1. Enable Editing
If you’ve opened a spreadsheet that you didn’t create — i.e., one that has been sent to you by somebody else or downloaded from the web — you may find it’s protected. You’ll know as when you open the file, you’ll find you’re unable to enter any text into cells. So how do you fix this issue?
- When opening a protected spreadsheet, you’ll see a yellow pop-up at the top of the spreadsheet that says, “PROTECTED VIEW Be careful — files from the internet can contain viruses. Unless you need to edit, it’s safer to stay in Protected View.”
- Next to this, there’s a gray button marked “Enable Editing.”

- To enter text into a protected spreadsheet, just click Enable Editing.
- You should then find you’re able to type in text and save the sheet with your changes.
2. Unprotect Your Sheet or Workbook
It might be that the sheet or workbook you’re trying to type in is protected. If this is the case, Excel won’t let you type any data into the sheet and will display a message letting you know. It’s easy to unprotect a sheet or workbook so you can enter data, although if the sheet or workbook is password protected, you’ll need the password from whoever created it.

- Click the Review tab.
- If the sheet or workbook you’re trying to type in is protected, you should see options to Unprotect Sheet or Unprotect Workbook.
- To enter text into a protected sheet or workbook, just select Unprotect Sheet or Unprotect Workbook.
- If the document is password protected, you’ll see a pop-up prompting you for the password. Enter it, then click OK.
- You should now be able to enter text into the sheet or workbook and save your changes.

3. Disable NumLock
It might sound obvious, but are you trying to type numbers into an Excel sheet or workbook using the separate numeric keypad on the right side of your keyboard? If this is the case and you can’t enter any numbers, it might be that NumLock is on.

Here’s how to disable it.
- Look for the NumLock key on your keyboard. Some keys will have an LED that illuminates to show NumLock is on.
- Press the NumLock key to turn NumLock off (or on).
Note: Many modern keyboards don’t have a separate numeric keypad, therefore won’t have a NumLock key.
4. Clear Data Validation Rules
Data validation rules can restrict what values users can input — for example, you can provide a range of specified values, such as whole numbers from 0 to 100. If you try to type in any other value, this will result in an error message.

There are two options here: Either you can stick to the data validation restrictions or contact the sheet creator if you’re not sure what input value is required. Or you can remove the data validation restrictions. Here’s how to do that.
- Select the cells where the data validation restrictions are applied.
- Click the Data tab, then choose Data Validation under Data Tools.
- Select Clear All, then click OK.
- You should now be able to enter any value into cells.

5. Disable Add-Ins
If you’ve recently installed new add-ins in Excel, this could be the reason you can’t type in Excel. By launching Excel in safe mode, you can figure out if an add-in is causing this problem. Launching Excel in safe mode is also a good solution if Excel is not responding.
How to launch Excel in Safe Mode
Here’s how to launch Excel in safe mode.
- Close your current Excel document — make sure to save any changes first.
- Press the Windows Key + R.
- In the Run box, type Excel/safe into the Open field.
- Click OK.
- Excel will launch in safe mode.
- Try typing into the sheet to see if the issue is fixed.

Still can’t type in Excel? Now you know that an add-in is causing the problem, the only question is, how do you know which add-in is the culprit?
Disabling add-ins
First, you’ll need to identify which add-in is the problem, then remove it. Here’s how to do that.
- Open Excel and go to the File tab.
- Under Options, select Add-Ins.
- At the bottom next to Manage choose COM Add-Ins from the drop-down menu.
- Press Go.
- A list of installed add-ins should appear.
- Check the box for one add-in and leave the others unchecked.
- Select OK.

- Restart Excel.
- Try typing into your sheet. If you’re able to type, you know this add-in wasn’t the problematic one.
- Repeat steps 1 through 9 to identify which add-in is causing the problem.
- Once you’ve figured out which add-in is at fault, repeat steps 1 through 5 to bring up the list of installed add-ins, but this time check the box for the offending add-in, then click Remove to uninstall it.
- Restart Excel and try typing — hopefully, you now shouldn’t have any issues entering text.
6. Adjust Editing Options
If a formula is applied to a cell, you can usually double-click that cell or press the F2 key to view the formula — and edit it. If you press F2 or double-click a cell and are unable to edit the formula or type in the cell, you need to adjust your editing options. Here’s how to do that.
- Go to the File tab and select Options.
- In the Excel Options dialog box, select Advanced.
- Under Editing Options, ensure the Allow Editing Directly in Cells box is checked.
- Click OK.
- You should now be able to type into any cell to edit formulae.

As you can see, there are a number of things that could be causing the issue if you can’t type in Excel. Luckily, there are also a number of quick and easy fixes to try if you’re experiencing this problem, so you should be up and running again in no time.