Mike V's Nano

Q: Paste Special

I use Paste Values a lot. I have been doing Edit > Paste Values.

 

Is there anyway to add Paste Values onto the right click menu?

 

Does a keyboard shortcut exist?

 

Does Numbers have a way to get a Paste Special dialog similar to that found in Excel?

 

Thanks

 

Mike

MacBook Air, Mac OS X (10.7)

Posted on Sep 2, 2011 7:11 PM

Close

Q: Paste Special

  • All replies
  • Helpful answers

  • by Barry,

    Barry Barry Sep 2, 2011 11:02 PM in response to Mike V's Nano
    Level 7 (32,697 points)
    iWork
    Sep 2, 2011 11:02 PM in response to Mike V's Nano

    Hi Mike,

     

    Pre-loaded Keyboard shortcuts are listed in a Help menu item called (surprise!) "Keyboard Shortcuts."

    You'll also find the keyboard shortcut for any menu item that has one noted beside that menu item in the menu containing the item:

    Picture 6.png

    As you can see, there is no pre-loaded KB Shortcut for Paste Values.

     

    But Mac OS X allows user specified KB shortcuts to be created for any (top level) menu item.

     

    For details of the procedure, see the Mac Help articles:

    Creating global keyboard shortcuts

    and

    Creating keyboard shortcuts for applications

     

    A logical keypress set for this is likely ctrl-option-command-V.

    This builds on the existing set:

     

    command-V = Paste

    option-command-V = Paste and match format

     

     

    Regards,

    Barry

  • by Mike V's Nano,

    Mike V's Nano Mike V's Nano Sep 3, 2011 6:53 AM in response to Barry
    Level 1 (13 points)
    Mac OS X
    Sep 3, 2011 6:53 AM in response to Barry

    Dumb  question. I can find the application help by using help. How do I get to the  Mac Help articles?

     

    Thanks

     

    Mike

  • by vjdjr,

    vjdjr vjdjr Sep 3, 2011 6:59 AM in response to Mike V's Nano
    Level 2 (192 points)
    Sep 3, 2011 6:59 AM in response to Mike V's Nano

    First click onto a blank part of your desktop screen.  The Application name will most likely change to Finder.  Then click help.

     

    Vince

  • by Barry,

    Barry Barry Sep 3, 2011 9:43 AM in response to Mike V's Nano
    Level 7 (32,697 points)
    iWork
    Sep 3, 2011 9:43 AM in response to Mike V's Nano

    Two routes to Mac Help:

     

    1. Go, as Vince suggests, to the Finder, then click the Help menu, choose Mac Help.

    2. In any application, go to the Help menu, choose (application) Help to launch the help Viewer.
      In the Help viewer, click and hold the Home button. Mac Help will be the first item on the menu that opens.

     

    Regards,

    Barry

  • by Peggy,

    Peggy Peggy Sep 3, 2011 9:48 AM in response to Barry
    Level 8 (38,937 points)
    Applications
    Sep 3, 2011 9:48 AM in response to Barry

    Since I don't really like keyboard combinations using more than three keys, I set Control-V for paste values in System Preferences > Keyboard > Application Shortcuts for Numbers. I also changed Paste & Match Style to Command-2 for both Pages & Numbers.

     

    Peggy_sig.png

  • by Mike V's Nano,

    Mike V's Nano Mike V's Nano Sep 3, 2011 2:42 PM in response to Barry
    Level 1 (13 points)
    Mac OS X
    Sep 3, 2011 2:42 PM in response to Barry

    Barry,

     

    The Macbook Air does not have a Home key. I would have to try to press command <- while clicking. I can do it, but it would be a little awkward feeling.   When I try it in Safari Help nothing happens.

     

    Mike

  • by Mike V's Nano,

    Mike V's Nano Mike V's Nano Sep 3, 2011 2:53 PM in response to Peggy
    Level 1 (13 points)
    Mac OS X
    Sep 3, 2011 2:53 PM in response to Peggy

    Peggy,

     

    I am with you. Two key operations can be a litle funky for me, three keys ...

     

    Thank you for the suggestion.

     

    Mike

  • by Peggy,

    Peggy Peggy Sep 3, 2011 6:08 PM in response to Mike V's Nano
    Level 8 (38,937 points)
    Applications
    Sep 3, 2011 6:08 PM in response to Mike V's Nano

    Three keys I can do. And I sure am missing the one I used most, ⌘ ⇧ S. The other I use a lot, ⌘ ⇧ D, sends e-mail in Mail.

     

    Peggy_sig.png

  • by UhUhLeUh,Solvedanswer

    UhUhLeUh UhUhLeUh Sep 25, 2016 2:53 PM in response to Mike V's Nano
    Level 1 (15 points)
    Sep 25, 2016 2:53 PM in response to Mike V's Nano

    Two steps:

    1. ⌘+Ctrl+V
    2. ⌘+V

     

    More interesting shortcuts like this listed at:

    https://samples-breakingintowallstreet-com.s3.amazonaws.com/BIWS-Excel-Shortcuts -Mac.pdf

     

    If you really want a single key combination (I personally use Ctrl+Option+⌘+space), it is a little more complicated. Follow the instructions at:

    http://www.noproblemmac.com/blog/2014/10/13/creating-keystroke-shortcuts-in-micr osoft-excel-for-mac-2011/

     

    Hope this helps.

  • by Barry,

    Barry Barry Sep 25, 2016 3:50 PM in response to UhUhLeUh
    Level 7 (32,697 points)
    iWork
    Sep 25, 2016 3:50 PM in response to UhUhLeUh

    "Two steps:

    1. ⌘+Ctrl+V
    2. ⌘+V"

     

    According to the first linked page, this two-step shortcut is applicable to Microsoft Excel, not to Numbers.

    In Excel, Paste Values is in the Paste Special submenu of the Edit menu. In Numbers, Paste Values is in the top level of the Edit menu.

     

    Few items on submenus have keystroke shortcuts in OS X applications, and none of these I've found are shortcuts requiring two steps.

     

    The second linked page is specific to MS Excel for Mac 2011 in it's demonstration of the problem, where the choice of "Values" is made in a dialogue box rather than in a submenu (adding two clicks to the mouse and menu process compared to the same procedure in Numbers).

     

    Although what is shown on the page is similar to the 'standard' procedure for creating these shortcuts for use on other applications on the Mac, the user may find the instructions in Mac Help more suitable for use in applications other than Excel.

     

    Mac Help can be reached via the Help menu in Finder, or in two three steps from the Help menu in any Apple application (such as Numbers).

    1. Click the help menu and choose (numbers) help.
    2. Click Show Topics
    3. Click More help for your Mac (bottom left corner of Help window).

     

    In Mac help, a search for either of these two articles will bring up link for both:

    Creating global keyboard shortcuts

    Creating keyboard shortcuts for applications

     

    Regards,

    Barry