« Secret StarWars games | Main | Paste Special II - Removing formulae »
September 19, 2005
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.
Posted by Dave at September 19, 2005 10:32 PM