If it's the "button" image (icon) you want, r-click the Toolbar area,
Customize, Commands, Rearrange commands, set Menu Bar to "Edit", Select
"Repeat Format Cells", click Modify Selection, pick "Copy Button Image"

You may now "Paste" it on another button that is on the Toolbar by
closing Rearrange commands and Rclicking on the other Button and picking
"Paste Button image".


Heidi wrote:

Thank you for taking the time to verify that I didn't miss something obvious.

I think I might begin a new thread with this specific challenge rather than
piggyback onto the Paste Special question posed in the original posting.

Do you think this is the appropriate forum for this question?

If not, where do you think I should post it?

Thanks again,

Heidi

"Gord Dibben" wrote:


Thanks for the correction Heidi.

I had obviously not picked up on the (actually, not so subtle) difference.

I don't think there is a Repeat icon. I can not find one in any category.

Gord



On Thu, 18 Jan 2007 12:11:02 -0800, Heidi
wrote:


Unfortunately, there is a subtle (but important) difference between Repeat
(Ctrl+Y) and Redo.

Example:

Mark a cell and apply a format. Notice that Redo button is remains dormant.
Select Edit from the menu. Notice that Repeat (Ctrl+Y) operation is
available with the format operation activated (Repeat Format Cells).

Do your have any other suggestions?

Thanks in advance,

Heidi



"Gord Dibben" wrote:

CTRL + Y is "Redo" in the list in the "Edit" category.
Drag it up to your Toolbar.

I could not locate the Repeat (Ctrl+Y) command in the 'Edit' section.

Excel's Help does not explain how this command can be added to Excel's
Toolbar.

Do you have any suggestions?



"Gary L Brown" wrote:

PUT 'PASTE' ICONS ON THE TOOLBAR...
The 'Customize' window is still open.
Select the 'Commands' tab.
Select the 'Edit' category in the 'Categories:' listbox.
On the 'Commands:' side of the Customize window, you'll see a listbox that
has Undo / Redo / Cut / Copy / Paste / Paste Special... / etc.
--