September 19th, 2005
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 thePaste Special dialog, unselect Paste All and Formats. Also selectMultiply. Now click OK …
We are done! The modified cell range.
Posted in Using OpenOffice Calc | No Comments »
