LinkBack URL
About LinkBacksI 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 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
>-----Original Message-----
>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?
>.
>
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.
"Star AJ" wrote:
> 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 know this thread is pretty old, but as it still links via web search I thought I would add this word of caution:
If you use a macro you CANNOT UNDO!
So if you find you have accidentally paste in the wrong place you would have to go back to your last saved version.
In case you are not interested in UNDO, you can assign this code to a button
Sub PasteValue() Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False End Sub
Click on the star if you think I helped you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks