Paste Value.

[Leo Leong]

Hi,

When we perform pasting in Excel, it pastes everything from the original
to the paste area. However, most of the time, I only need to paste the
value, and I don't want to go to Edit -> Paste Special... -> Value
repeatedly. How can I change the setting to paste value by default?
Thanks.

Leo

 

[Andy Brown]

"Leo Leong",

I don't want to go to Edit -> Paste Special... -> Value
repeatedly.

Understandably. Right-click the menu bar, choose Customize. On the Commands
tab, select the Edit category and drag the Paste Values button to one of
your toolbars.

Rgds,
Andy