Change the default paste method??

[woodythdog]

Hi

I routinely need to paste values from one sheet to another I would like to be able to use the CTRL-V shortcut but each time I paste I need to open the paste options tab to tell excel to only change the value not the formatting

Is there any way to make "paste value" the default paste method.

I am using excel 2003

Thanks

[VBA Noob]

Hi,

You could add a button.

Go to Tools > Customise > Commands Tab > edit > paste special and drag it to you toolbar

VBA Noob