## Paste Special I

In a series of short tips, we introduce the **Paste Special** feature.

A quick and easy way to multiply an array of numbers by a constant without using a formula…

In the example below, we wish to multiply **B5:B20** by 10. Temporarily enter 10 into an empty cell. Select it and then **Cut** or **Copy**

Select the target range, then click on **Edit – Paste Special **. In the **Paste Special** dialog, unselect **Paste All** and **Formats**. Also select **Multiply**. Now click OK …

We are done! The modified cell range.

## Recent Comments