Excel’s Paste and Paste Special commands harbor a multitude of useful options. Use them to do everything from transposing data to copying Validation rules.

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/

More Under Finance

Posted Under

Category : Finance (3776)
Type : Articles (18571)
Tags : Excel Tips (36) Software (102)

0 responses to “10 powerful ways to use Excel's paste features”

  1. anupa says:

    It is helpful. Can you tell me how to calculate the number of days from a calender date to another year another calendar date

  2. Anbarasu says:

    Thank you for the shot cut keys.

  3. Mukund Sarda says:

    Thank you

  4. Saket Agarwal says:

    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!

  5. Suresh Panjwani says:

    Thanks for your latest information.Please notify me of new posts by email.

    Suresh Panjwani

Leave a Reply

Your email address will not be published. Required fields are marked *