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/

Join Taxguru’s Network for Latest updates on Income Tax, GST, Company Law, Corporate Laws and other related subjects.

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Telegram

taxguru on telegram GROUP LINK

Download our App

  

More Under Finance

0 Comments

  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. 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!

Leave a Comment

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

Search Posts by Date

December 2023
M T W T F S S
 123
45678910
11121314151617
18192021222324
25262728293031