Keyboard shortcut for "copy paste special values?"

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?
 
J

Jason Morin

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
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paste Special Values 2
Keyboard Shortcut for "Paste Values"? 6
I can't copy and paste equations 0
Keyboard Shortcut for Paste/Special/Values? 3
Keyboard Shortcuts for Paste Special Values and Formats 2
REMOVING WORKBOOK'S ALL FORMULAS 3
Paste Special Formula Multiply feature doesn't work anymore 2
Paste Special in Excel 2003 6

Top