Well OK, but I would like to have pasted the A1 cell instead of 1.2 value
into selected cells, so if I change the A1 value from 1.2 to 1.5 all selected
cells will be multiplied by this factor.

"Anne Troy" wrote:

Copy a cell that contains the value 1.2. Now select all the cells you want
to increase. Hit Edit--Paste special, Multiply.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Michal" wrote in message
...
I have a table with quarters in rows and values in columns. I need to
increase all values by some factor (lets say number in cell A1). I know
that
I can multiply every cell separatelly. Is there any other, more automatic
way?