XL2000: Redo Toolbar Button Does Not Repeat Formatting (211906)



The information in this article applies to:

  • Microsoft Excel 2000

This article was previously published under Q211906

SYMPTOMS

In Microsoft Excel, 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 versions of Microsoft Excel earlier than Excel 97.

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 Microsoft Excel Help on the Help menu, type repeat the last action in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

Modification Type:MajorLast Reviewed:9/27/2003
Keywords:kbprb kbui KB211906