ID: Q160767
The information in this article applies to:
When you double-click a cell to edit text in the cell, the formula bar expands to display the text, the cursor disappears, and the cell you are editing is hidden by the text in the formula bar.
This problem occurs when you double-click a cell that contains a large amount of text. The text and the pointer is hidden behind the expanded formula bar. Note that the cell contents appear in the formula bar, which expands display all the text in the cell.
To work around this problem, use either of the following methods.
Method 1: If you are using a pointer device such as a mouse or a trackball,
click the formula bar to display the insertion point.
To do this, click Formula Bar on the View menu. This command
toggles the formula bar off.
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.
In Microsoft Excel 97, the maximum number of characters that you can type in a single cell is 32,767. In earlier versions of Microsoft Excel, the limit is 255.
The formula bar can display the entire contents of a single cell by expanding downward into the worksheet. The greater the number of characters in the cell, the larger the formula bar must expand to display the cell contents. Note that the formula bar can overlap and hide portions of the worksheet if there are a lot of characters in the cell.
For more information about editing cell contents, click the Index tab in Microsoft Excel Help, type the following text
cells, entering data in
Additional query words: XL97 8.00 in cell editing
Keywords : kbualink97 kbdta xlui xlformula
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbbug
Solution Type : kbpendingLast Reviewed: November 1, 1998