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.
