Short cut keys for paste special

Brilliant! Many thanks Toronto Glen.

OPTION #1:

1. Press and release / [forward slash key]
2. Press and release 4 [number four key]

**See below on how to setup spreadsheet one time for this function**

OPTION #2:

1. Copy cells
2. Paste cells using Ctrl+V
3. Tap Ctrl
4. Tap M

SETUP INSTRUCTIONS FOR OPTION #1:

I have been beating my head against the wall trying to figure this out and long story short...The brilliant developers at Microsoft only allowed the ability to assign shortcut keys in Word 2010 but not within Excel 2010. If you're like me and can't use a Macro enabled shared workbook in your office (can't assign a macro) and you don't enjoy burning your wrist out clicking back and forth all day for 'Paste Special', then follow the steps below to enable the quickest way of pasting in Excel to match your destination format (like you wish you could by assigning a simple shortcut key like the ctrl-V shortcut).

1. Right click on the Ribbon (toolbar) at the top.
2. Select "Customize the Quick Access Toolbar".
3. In the "Choose Commands From" edit box (box on left) change choose commands from "Popular Commands" to "All Commands".
4. Scroll down and highlight "Paste and Match Destination Formatting" and click the 'Add' button and you will see it added to your quick access toolbar (box on right)
5. Click OK on the dialog box.
6. You should now then see a little icon at the very top left of your Excel window located to the right of the Save and Undo/Redo icons which looks like a clipboard.
7. Now in your Excel spreadsheet, press / [forward slash] and you will see numbers populate in the ribbon (you cannot change these assignments- I don't think).
8. Look at your new clipboard icon at the top left and take note of the number that Excel assigned to it; thereafter just click anywhere in the spreadsheet to make them disappear. (in my spreadsheet Excel assigned4[number four key] which will be used in the example below but if yours is different then replace 4 after theforward slash with whatever number or letter you see assigned to your new icon)
9. Copy your data from wherever and now in your Excel spreadsheet press and release / [forward slash key] and then press and release 4 [number four key] and BOOM! you have now pasted that info to match the destination format in your spreadsheet with only pressing two keys on the keyboard.

This is the same concept as ctrl+C to copy or ctrl+V to paste  but youdon't have to hold down one key while pressing the other......simply press the first key[ / ], release, and then press the second key[ 4 ].

**Upon verifying this setup works for you make sure to save your spreadsheet so you don't have to do it again next time**

-CHEERS!

Save the macro in your default Book.xls

You may find this file here

C:\Documents and Settings(username)\Application Data\Microsoft\Excel\XLSTART

Probably I am not getting you what u r trying to tell me. But But I did some workout what u mentioned here.......What I found that the XLSTART folder was empty. So i saved a excel file named "default Book" containing the macro u told earlier. Now what happening is that whenever  I am opening any of my excel file this file default Book also opens up. Tough the paste spacial is working up but this unnecesarry opening of another file seems awkward to me.

JUst I would like to know that is this the same step u wanted to get done from me.

Thx.