How to multiply all cells in array by factor
 

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, and
doesn't let me save just this new array (I am using CSV format so I can
open in graphing/plotting programs).

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

Thanks!


--
rhauff
------------------------------------------------------------------------
rhauff's Profile: http://www.excelforum.com/member.php...o&userid=32644
View this thread: http://www.excelforum.com/showthread...hreadid=524507

How to multiply all cells in array by factor
 

You can use the Paste Special/Operation/Multiply feature. Type the
number 10 in a cell. Copy that. Select your entire array that you
want to multiply by 10. Select Paste Special. In the Operation
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 already
got the array with the values, you can copy and Paste Special, select
Values over the original and then delete the array you created to
multiply by 10.


HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=524507

How to multiply all cells in array by factor
 

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!


--
rhauff
------------------------------------------------------------------------
rhauff's Profile: http://www.excelforum.com/member.php...o&userid=32644
View this thread: http://www.excelforum.com/showthread...hreadid=524507