The Paste Special command is in most Office applications, but Excel users probably benefit from it the most. Using this basic feature — as well as assorted Paste options — you can make short work of a few common tasks and some rather complex problems. These tricks are so easy to implement that you’ll probably find yourself using the paste features a lot more than you used to.
In Excel 2007 and 2010, Paste is in the Clipboard group on the Home tab. In Excel 2003, Paste Special is on the Edit menu. For the shortcut enthusiasts, we’ve included a table at the end that contains keyboard shortcuts for most of these operations.
To Read More Vist the following link :– http://www.techrepublic.com/blog/10-things/10-powerful-ways-to-use-excels-paste-features/2902/
It is helpful. Can you tell me how to calculate the number of days from a calender date to another year another calendar date
Thank you for the shot cut keys.
Thank you
Excellent…!! It is difficult to find people who can explain what is to be done in such a precise way! You have also used the correct terms for referencing (like pane, range, relative refernce), this keeps things simple and avoids confusion. I am totally impressed. Keep up the good work!
Thanks for your latest information.Please notify me of new posts by email.
Suresh Panjwani
09450023529