Paste Special

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:

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

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

Vince

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

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.

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.

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.

"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

Mike V's Nano wrote:

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

Numbers has no 'Paste Special' dialog. However, the equivalent of 'Paste Values' in Excel is 'Paste Formula Results' (in the Edit menu).

As with all other menu picks on the Mac you can assign a keyboard shortcut (if one doesn't already exist) by going to System Preferences > Keyboard > Shortcuts > App Shortcuts and adding one to your liking that doesn't conflict with a keyboard shortcut "already taken."

SG

If i copy cells and drag drop them they = jpeg

If i Command C and Command P it pastes the contents.

Id like to highlight part of numbers spread sheet and copy paste as jpeg into a text or tellegram. Right now im drag and dropping and its really inconvient.

PLease help 🙂