In Microsoft Excel, if you attempt to type text in a cell, the text disappears when you press ENTER, but when you type a number, the number is entered as expected.
↑ Back to the top
This behavior can occur if all of the following conditions are true:
- Two or more sheets in your workbook are grouped.
-and- - The sheets in your workbook that are grouped are also protected.
-and- - Individual cells in the sheets are unprotected.
-and- - The unprotected cells are set to wrap text.
↑ Back to the top
To work around this issue, first ungroup the worksheets, and then type text in the cells that you want. After you type the text in the cells, you can group the worksheets and the text remains in the cells.
↑ Back to the top
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
↑ Back to the top
To group worksheets in an Excel workbook, press and hold down the CTRL key while you click the sheet tabs.
↑ Back to the top