Results 1 to 4 of 4

Is there a keyboard shortcut for paste special values?

This is a discussion on Is there a keyboard shortcut for paste special values? within the Excel Questions forums, part of the Question Forums category; Looking for a keyboard shortcut for Paste Special - Values. I use this all the time....

  1. #1
    New Member
    Join Date
    Apr 2003
    Posts
    1

    Default Is there a keyboard shortcut for paste special values?

    Looking for a keyboard shortcut for Paste Special - Values. I use this all the time.

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Keaau, Hawaii
    Posts
    240

    Default

    I put this in a module and ust CTRL Q to activate it.
    This one just pastes the values with out the formatting or any formulas that may have been in the origin cell.

    'Hope it helps. CODE FOLLOWS::

    Public Sub PstSpcl()
    ' Keyboard Shortcut: Ctrl+q
    On Error GoTo ErrorHandler

    Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
    False, Transpose:=False

    Exit Sub
    ErrorHandler:
    MsgBox (Err.Description)
    Resume Next
    End Sub


    'CODE ENDS


    Yours in EXCELent Frustration

    KniteMare
    Of course I can, and it will take only 900 hours of programming time to do it."
    <MARQUEE></marquee>

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Toronto, Canada
    Posts
    248

    Default

    If you're just looking for a qucik way to paste values once they are copied to the clipboard, simply customize your toolbar and drag the "paste values" icon up onto the active toolbar.

    Hope this helps.

  4. #4
    Board Regular Chris Macro's Avatar
    Join Date
    Nov 2011
    Location
    Ohio
    Posts
    1,269

    Default Re: Is there a keyboard shortcut for paste special values?

    There was a cool add-in released by ExcelCampus called PasteBuddy. It let's you create a custom shortcut key for any pasting combination (and allows you to undo too!). Similar to what Nevillestoke was recommending, I personally have Paste Values in the first position of my QAT bar and can use the shortcut key Alt+1 to initiate it.
    My Beginner's Intro to VBA: Here
    My Excel/VBA Tutorial Blog: TheSpreadsheetGuru

    If I was able to help you, you can support my Excel Blog by giving me a Like on Facebook

    Using Office 2007 (Windows 7) & Office 2013 (Windows 8)

    Twitter | Facebook| Google+ | YouTube

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com