Paste Value.

  • Thread starter Thread starter Leo Leong
  • Start date Start date
L

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
 
"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
 
Back
Top