Well i don't know what you really want but as my underestanding you have to
do as follow:

Col A Col B Col C Col D Col E Col F
1 0.1 0.1 0.1 =A1*160
2 0.5 0.5 0.5
3 0.05 0.05 0.05
4 0.25 0.25 0.25
5 0.1 0.1 0.1

and then copy the formula in the cell D1 as follow:

active cell D1
pu the mouse on the right bottomn corner of the active cell
hit the mouse left bottomn and keep it
drag mouse to column E & F and then drag down to where ever you want
leave the mouse left bottomn
now the formula has copied to all cells and the cells are selected
after that right click on the selected cells and choos copy
then right click on cell A1 and choos past especial and then choos value and
the click ok so now all figurs have replaced with the rusult

hope it works

--
Farhad Hodjat


"DonnaS" wrote:

Greetings - The following is an example of what I want to do. I want to
take all of these figures times 160 and have the result display in the cell
instead. I have only come up with creating a manual formula in each cell
such as =0.1*160 but prefer to have something more automated as there are a
couple hundred of these cells. Thank you for your kind assistance.

Col A Col B Col C
0.1 0.1 0.1
0.5 0.5 0.5
0.05 0.05 0.05
0.25 0.25 0.25
0.1 0.1 0.1