Microsoft KB Archive/215934

= XL2000: Cannot Enter Text into Cells in Protected Worksheet =

Article ID: 215934

Article Last Modified on 9/27/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q215934



SYMPTOMS
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.



CAUSE
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.



WORKAROUND
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.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



MORE INFORMATION
To group worksheets in an Excel workbook, press and hold down the CTRL key while you click the sheet tabs.

Additional query words: XL2000

Keywords: kbbug kbpending KB215934

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.