XL97: Redo Toolbar Button Does Not Repeat Formatting (165240)



The information in this article applies to:

  • Microsoft Excel 97 for Windows

This article was previously published under Q165240

SYMPTOMS

In Microsoft Excel 97, you cannot use the Redo command on the Standard toolbar to repeat the last formatting change that you made in a cell on a worksheet.

CAUSE

The Redo command on the toolbar becomes available only after you use the Undo command.

This behavior is different from the Repeat command on the Standard toolbar in earlier versions of Microsoft Excel.

WORKAROUND

To repeat formatting that you applied to a cell, use either of the following methods:
  • On the Edit menu, click Repeat Format Cells. -or-

  • Press CTRL+Y.

REFERENCES

For more information about repeating actions, click the Index tab in Microsoft Excel Help, type the following text

repeating actions

and then double-click the selected text to go to the "Repeat the last action" topic.

Modification Type:MajorLast Reviewed:3/18/2002
Keywords:kbui KB165240