Normally when you type enough characters in cell A1, they display over the cell(s) to the right (B1, C1, etc.). I had a workbook where this was the case, then suddenly I noticed that the text in A1 only displayed in A1 and no longer displayed over the cells to the right. Cells B1, C1, etc. were completely empty/deleted/cleared. I could find no cell formatting like wrap text or otherwise that would cause this.
通常，当您在单元格A1中输入足够的字符时，它们会显示在右边的单元格(B1、C1等)上。我有一个工作簿，就是这样，然后我突然注意到A1中的文本只显示在A1中，而不再显示在右边的单元格上。单元B1、C1等完全清空/删除/清除。我找不到像包装文本这样的单元格格式，否则会导致这种情况。
Is there a setting, global or otherwise, that would cause or allow this behavior?
是否有一个设置，全局或其他，导致或允许这种行为?
Merge cells sort of makes the text appear as desired, but it doesn't make sense that this is the best fix. The cells were never merged before, and don't need to be merged in a new workbook for the "normal" behavior to be seen.
合并单元格使文本看起来像期望的那样，但它没有意义，这是最好的修复。以前从未合并过单元格，并且不需要合并到新的工作簿中，以查看“正常”行为。
6 个解决方案
#1
14
I found the culprit setting: Show Formulas (Formulas ribbon tab, Formula Auditing). The shortcut for this command is Ctrl+`. My backward single quote is right above my tab key, so I bet when I was Ctrl+tabbing between multiple spreadsheets I accidentally enabled Show Formulas. I was in the data-entry area of my workbook, so it took me a while to notice formulas were displayed instead of results.
我找到了罪魁祸首的设置:显示公式(Formula ribbon选项卡，公式审核)。这个命令的快捷方式是Ctrl+ '。我的单引号就在tab键的上方，所以我打赌当我在多个电子表格之间按Ctrl+制表时，我不小心启用了Show formula。我在工作簿的数据输入区，所以我花了一段时间才注意到公式而不是结果。
#2
8
mark affected cell(s), press ctrl-1, second tab and you will find a checkbox for text wrap.
标记受影响的单元格，按ctrl-1，第二个选项卡，您将找到一个用于文本包装的复选框。
#3
3
You likely have a space or some other invisible character in the cell to the right of A1(B1 C1 etc) highlight all of the cells to the right of A1 and press delete.
你可能在A1的右边有一个空格或其他一些不可见的字符(B1 C1等)突出A1右边的所有单元格并按delete。
#4
1
Maybe you activated the "line break" option in the format of cell A1 and fixed its height.
也许您激活了单元A1格式的“断行”选项，并修正了它的高度。
#5
0
I had the same issue but managed to fix. I'm using Excel from the Microsoft Office Professional Plus 2010. I went to "options" and in the "Advanced" tab under "Display options for this workbook" and unchecked "show formula in cells instead of their calculated results". Then the text started showing up in the adjacent cells. For other versions of Excel as well this might work but you just need to find out where this option is. Hope this helps. - Nelson
我遇到了同样的问题，但我设法解决了。我使用的Excel软件来自微软Office专业人员+ 2010。我转到“选项”和“高级”选项卡下的“本工作簿显示选项”和未选中的“在单元格中显示公式，而不是计算结果”。然后，文本开始出现在邻近的细胞中。对于其他版本的Excel也可以这样做，但是您只需要找到这个选项在哪里。希望这个有帮助。- - - - - -尼尔森
#6
0
An old question but still around.
一个老问题，但仍然存在。
Just had the same thing in office 2013. In Column A,125 I added a comment which appeared as left justified. I wanted it right justified to match the text above so, I re-justified all of column A. I noticed (much) later that comments that had stretched across A, B, C, D & D 225 were truncated, with only the last part of the text visible. I did not want the text to wrap in the cell, but to overflow as before. After much scratching about, the entry into the left column has to be Left justified, not right. As there are no columns to the left of A, only the last bit appears. Too simple really!
2013年的总统大选也是如此。在第125栏中，我添加了一条左对齐的注释。我希望正确地匹配上面的文本，因此，我重新定义了所有的列A。我注意到(很多)之后，在A、B、C、D和D 225上的注释被截断了，只有文本的最后一部分可见。我不希望文本在单元格中包装，而是像以前一样溢出。在进行了很多修改之后，进入左列的条目必须是左对齐的，而不是右对齐。因为在A的左边没有列，所以只出现了最后一个位。真的太简单了!
#1
14
I found the culprit setting: Show Formulas (Formulas ribbon tab, Formula Auditing). The shortcut for this command is Ctrl+`. My backward single quote is right above my tab key, so I bet when I was Ctrl+tabbing between multiple spreadsheets I accidentally enabled Show Formulas. I was in the data-entry area of my workbook, so it took me a while to notice formulas were displayed instead of results.
我找到了罪魁祸首的设置:显示公式(Formula ribbon选项卡，公式审核)。这个命令的快捷方式是Ctrl+ '。我的单引号就在tab键的上方，所以我打赌当我在多个电子表格之间按Ctrl+制表时，我不小心启用了Show formula。我在工作簿的数据输入区，所以我花了一段时间才注意到公式而不是结果。
#2
8
mark affected cell(s), press ctrl-1, second tab and you will find a checkbox for text wrap.
标记受影响的单元格，按ctrl-1，第二个选项卡，您将找到一个用于文本包装的复选框。
#3
3
You likely have a space or some other invisible character in the cell to the right of A1(B1 C1 etc) highlight all of the cells to the right of A1 and press delete.
你可能在A1的右边有一个空格或其他一些不可见的字符(B1 C1等)突出A1右边的所有单元格并按delete。
#4
1
Maybe you activated the "line break" option in the format of cell A1 and fixed its height.
也许您激活了单元A1格式的“断行”选项，并修正了它的高度。
#5
0
I had the same issue but managed to fix. I'm using Excel from the Microsoft Office Professional Plus 2010. I went to "options" and in the "Advanced" tab under "Display options for this workbook" and unchecked "show formula in cells instead of their calculated results". Then the text started showing up in the adjacent cells. For other versions of Excel as well this might work but you just need to find out where this option is. Hope this helps. - Nelson
我遇到了同样的问题，但我设法解决了。我使用的Excel软件来自微软Office专业人员+ 2010。我转到“选项”和“高级”选项卡下的“本工作簿显示选项”和未选中的“在单元格中显示公式，而不是计算结果”。然后，文本开始出现在邻近的细胞中。对于其他版本的Excel也可以这样做，但是您只需要找到这个选项在哪里。希望这个有帮助。- - - - - -尼尔森
#6
0
An old question but still around.
一个老问题，但仍然存在。
Just had the same thing in office 2013. In Column A,125 I added a comment which appeared as left justified. I wanted it right justified to match the text above so, I re-justified all of column A. I noticed (much) later that comments that had stretched across A, B, C, D & D 225 were truncated, with only the last part of the text visible. I did not want the text to wrap in the cell, but to overflow as before. After much scratching about, the entry into the left column has to be Left justified, not right. As there are no columns to the left of A, only the last bit appears. Too simple really!
2013年的总统大选也是如此。在第125栏中，我添加了一条左对齐的注释。我希望正确地匹配上面的文本，因此，我重新定义了所有的列A。我注意到(很多)之后，在A、B、C、D和D 225上的注释被截断了，只有文本的最后一部分可见。我不希望文本在单元格中包装，而是像以前一样溢出。在进行了很多修改之后，进入左列的条目必须是左对齐的，而不是右对齐。因为在A的左边没有列，所以只出现了最后一个位。真的太简单了!