Hi Zeeshan -

One way would be to record a PasteSpecial macro and assign it to a shortcut
key.

1. Select any range of several cells and choose |Edit|Copy|.

2. Then choose |Tools|Macro|Record New Macro...|.

3. In the dialog that opens, enter a shortcut key in the 'Shortcut Key' box.
For example, enter "b".

4. Select any single destination cell and choose |Edit|Paste Special|Values.

5. Press the stop recording macro button. Open the VB Editor (Alt-F11) and
find the macro you just recorded (it should be named Macro1()).

6. The macro will have two functionl lines. The first will be something
like:
Range("E1").Select. Delete that line.

----------------
To use the macro on a worksheet, select cells, choose copy, select the
destination and press Ctrl-b. Copy the macro to any workbook you need it in
or copy it to your Personal.xls workbook so it is always available. Search
Google for Personal.xls for details about how to use the macro in your
personal macro workbook.

I'll be offline immediately after this post, but will check back in about 10
hrs. Good luck.
--
Jay


"ZEESHAN ANIS" wrote:

How can we paste special value through shortcut keys.