Paste Special Subtract in Excel 2007

For the operation Subtract 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 deduct $100 from all the employees.
The salary of Alice after deduction will be $2,200, for Aaron $4,100 and so on.
To achieve this, you will enter 2200 directly in cell B2, 4100 in cell B3 and so on. Suppose, there are 2000 employees then it will be a tedious job to do. The simplest way to do is using the Subtract operation provided in the Paste Special.

Perform the following to deduct $100 from all the employees:
1. Click cell B11 (this cell contains the value $100.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 Subtract and click OK.
You will see that $100 is deducted from all the employees.