Paste Special Add in Excel 2007

The operation Add will add the copied data with the destination cells. For operation Add in the Paste Special section, we will consider an example where 8 employees with their salaries are provided in the figure at the right. The company decides to provide a hike of $500 for all the employees.
The salary of Alice after the hike will be $2800, for Aaron $4700, and so on.
To achieve this, you will enter $2800 directly in cell B2, $4700 in cell B3 and so on. Suppose, there are hundreds or thousands of employees then it will be a tedious job to do. The simplest way to do is by using the Add operation provided in the Paste Special.

Perform the following to add $500 to all the employees:
1. Click cell B11 (this cell contains the value $500.00) and click Copy or press CTRL + C.
2. Click cell B2 and press the SHIFT key. Keeping the SHIFT key in the pressed state, click cell B9. This will select the salaries of all the employees.
3. On the Home tab, in the Clipboard group, click the down arrow in the Paste command and click Paste Special...

4. In the Paste Special dialog box, under Operation, click Add and click OK.
You will see that $500 is added to all the employees.