Shortcut for Paste Special+Match Destination Formatting in MS excel on OSX Mavericks

Question

Level 1

5 points

Shortcut for Paste Special+Match Destination Formatting in MS excel on OSX Mavericks

Hi,

I am wondering if someone can help me create a keyboard shortcut for 'paste special -> matching destination formatting' into MS excel 2011. I realise this isn't the most ideal situation (not being a mac app), but it's what I have, and I have a lot of text to copy in, so i'd love to create a workaround if possible.

I am running Mavericks 10.9.5 on a 2010 Macbook Pro. I've tried various options that I've found on the net for previous versions of OSX, but none have worked for Mavericks, and I can't find any information on this that was posted after 2012.

I am willing to experiment with a macro, but I have no experience with them so I don't really know what I'm doing. Any advice would be greatly appreciated. Thanks in advance for any help / advice.

MacBook Pro (13-inch Mid 2010), OS X Mavericks (10.9.5)

Posted on Oct 11, 2014 4:59 AM

Reply

Answer 1

Barney-15E

Level 10

123,008 points

Oct 11, 2014 8:12 AM in response to Rmw21

Normally you can create a shortcut for any Menu command in Keyboard System Preferences, Shortcuts. Select Applications and add a new one. Type the text of the command exactly as it appears in a menu.

However, as Microsoft tends to roll it’s own user interface features, that will likely not work. You’d need to ask Microsoft what capability they have added to the program to enable custom shortcuts.

Reply

Answer 2

Rmw21 Author

Level 1

5 points

Oct 11, 2014 1:44 PM in response to Barney-15E

Hi Barney,

Thanks for your reply. I should have mentioned that I've tried to create a keyboard shortcut in both excel and through systems preferences, however to no avail. In excel there is a keyboard shortcut in place for 'paste special', however there is no option to move past this into paste special options. I am starting to think perhaps this isn't available because there is no menu command for it directly, rather a popup box appears with paste special options. But it is so tedious to click this every time you want to paste.

Cheers

Reply

Answer 3

Oct 11, 2014 7:34 AM in response to Rmw21

I suggest you ask on the MIcrosoft Mac forums since it's their software you're having problems with. These forums are for troubleshooting Apple products.

http://answers.microsoft.com/en-us/mac

Reply