Excel 2007 Customize Buttons

[NJActuary]

I've recently started using Excel 2007. In trying to customize my Quick Access Toolbar by adding the "Paste Values" button, I discovered that the standard "Paste Values" button (which had a clipboard with a "12" on it in Excel 2003) doesn't exist in Excel 2007. I can add a button to the QAT by right clicking the paste-values command on the ribbon, but it's a generic button, so I can't distinguish between the Paste Values button and any other button that doesn't have its own icon.

1) Am I right that the Paste Values button doesn't exist in Excel 2007?
2) Is there a way to customize these buttons so they can be distinguished?

 

[Derek Brown]

You need to right mouse-click the QAT and select Customize the Quick Access Toolbar.
In the 'Choose commands from' box select 'All Commands".
Scroll down and select 'Paste Values' - then click 'Add' and then OK.

 

[NJActuary]

Thanks, but I think you misunderstood the question. I know how to get Paste Values onto the QAT, but the button is a generic button that looks identical to the button that I get if I add, say, Paste Formulas or AutoFit Row Height to the QAT. In short order, I will have a number of indistinguishable buttons on the QAT, which makes it a whole lot less useful.

The question is whether it's possible to customize the buttons. Judging from the lack of an answer so far, I'm guessing the answer is No?

 

[VoG]

This may help http://www.rondebruin.nl/imageqat.htm

 

[BigC]

And Microsoft think that this makes the 2007 application better than the previous version???

 

[Johnny C]

Holy ****... why on earth didn't they add an edit icon image option? It can't have been that difficult, maybe 2010 will have it in (though i doubt it)

 

[kualjo]

Why did Microsoft find it necessary to put everyone through all of that just to edit a button image? It was easy in 2003, then they got rid of it?! No program should regress in the way that this one has.