Article ID: 176250
Article Last Modified on 8/19/2003
APPLIES TO
- Microsoft Excel 97 Standard Edition
- Microsoft Excel 98 for Macintosh
This article was previously published under Q176250
SYMPTOMS
If you click the Lock Cell tool on the Standard toolbar in Microsoft
Excel, the following problems may occur:
- If you click the Undo tool or the Redo tool on the Standard toolbar,
the list of actions that you can undo or redo may contain one or more
blank items.
- If you click the Edit menu, the Undo and Redo commands are not followed
by the name of an action (for example, "Undo Clear" or "Redo Insert
AutoShape").
CAUSE
These problems occur because Microsoft Excel places a null entry in the
Undo and Redo lists when you click the Lock Cell tool. As a result, the
Edit menu and the Undo and Redo tools do not display an action name for
the Lock Cell tool.
WORKAROUND
Even though the Edit menu and the Undo and Redo tools do not list the
actions, you can undo or redo the action performed by the Lock Cell tool.
To do this, click Undo or Redo on the Edit menu, or click the Undo or Redo
tool, and then click the blank actions that you want to undo or redo.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article.
Additional query words: XL97 XL
Keywords: kbui kbprb KB176250