Easier than selecting Edit, Paste Special, Values, or using a Macro. Add the icon to your toolbar once, and it will always be available for a single-click execution. I find it is also useful for pasting values without over-writing pre-existing formatting.
Right-click anywhere on your Excel toolbar.
Select "Customize..." at the bottom of the pop-up.
Select the "Commands" tab.
Select "Edit" from the Categories list on the right.
Scroll down the Commands list on the right until you see the "Paste Values" icon.
Drag-and-drop the icon from the "Customize" window to your Excel toolbar. The location within the toolbar is your choice, but right next to the standard "Paste" icon is a logical place.
© 2007 O'Reilly Media, Inc.
| Customer Service:
| Book issues:
All trademarks and registered trademarks appearing on oreilly.com are the property of their respective owners.