How to multiply all cells in array by factor

[rhauff]

I have an array from A1:ES80 which I want to multiply all cells by 10.

I know I can select another area on the spreadsheet of the same size
enter
=A1:ES80*10 and press CTL-Shift-Enter to have a new array created.

Unfortunately, this new array is now referenced to the first, an
doesn't let me save just this new array (I am using CSV format so I ca
open in graphing/plotting programs).

Is there a way to multiply the original array so i can easily save it?

Thanks

 

[SteveG]

You can use the Paste Special/Operation/Multiply feature. Type th
number 10 in a cell. Copy that. Select your entire array that yo
want to multiply by 10. Select Paste Special. In the Operatio
section of the option box, select the Multiply option and click ok.
That will multiply all of your values by 10. Or, since you've alread
got the array with the values, you can copy and Paste Special, selec
Values over the original and then delete the array you created t
multiply by 10.


HTH

Stev

 

[rhauff]

Hey thanks!

I',m actually using Gnumeric (open source) and it's got the exact same
function.
It's exactly what I was looking for. Thanks again!