Keyboard shortcut for "copy paste special values?"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I copy and paste-special values repeatedly. Is there a keyboard shortcut so
that I don't have to point and click the mouse to "Edit" "Paste Special"
"Values" each time?
 
I have the button attached to one of my toolbars.

Go to View > Toolbars > Customize and click on the
Command tab. In "Categories" click "Edit" and scroll down
on the right to find "Paste Values". Drag it to one of
your toolbars.

HTH
Jason
Atlanta, GA
 
It might be a little more cumbersome but if you're like me
and don't like to use the mouse you could do Alt>e>s>v>enter.

My only other thought would be to record a macro to "paste
special" and set it to you're own shortcut like ctrl+, or something.
 
Back
Top