XL2000: Redo Toolbar Button Does Not Repeat Formatting

View products that this article applies to.

This article was previously published under Q211906

Expand all | Collapse all

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.

Back to the top

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.

Back to the top

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.

Back to the top

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.

Back to the top