Blank Item in Undo/Redo List After Clicking Lock Cell Tool (176250)


The information in this article applies to:

  • Microsoft Excel 97 for Windows
  • Microsoft Excel 98 Macintosh Edition
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.

MORE INFORMATION

In the versions of Microsoft Excel listed at the beginning of this article, you can display the Lock Cell tool by following these steps:

  1. On the Tools menu, click Customize. Click the Commands tab.
  2. In the Categories list, click Format. Scroll to the bottom of the Commands list.
  3. Drag the Lock Cell tool from the Commands list and to an existing toolbar.
  4. Click Close.
If you click the Lock Cell tool, and then click the Undo tool on the Standard toolbar, the list of actions you can undo contains a blank item at the top of the list. If you click the blank item, Microsoft Excel undoes the action performed by the Lock Cell tool. If you then click the Redo tool, the list of actions you can redo also contains a blank item at the top of the list.
Modification Type:MinorLast Reviewed:8/19/2003
Keywords:kbprb kbui KB176250
©2003 Microsoft Corporation. All rights reserved.