Read Excel Tips Such As How To Increase A Range By Two Percent At BrightHub.com

See all Microsoft Excel tips

Strategy:

****

In a blank cell, enter 102%, as shown in Fig. 780. Copy that cell and then use Paste Special Multiply to multiply all of the contract prices by this cell.

1. Find a blank cell, such as D1. Enter 102% in that cell.

2. Select D2 and choose Edit – Copy from the menu.

3. Select all of the rates in column B.

4. From the menu, select Edit – Paste Special. In the Paste Special dialog, choose Values and Multiply, as shown in Fig. 781.

**

Result:

All of the values in column B are increased by 2 percent, as shown in Fig. 782.

Summary:

Multiply an entire range by a single cell, using Paste Special – Multiply.

Commands Discussed:

Edit – Paste Special – Multiply

**

****

See all Microsoft Excel tips

Images