You can copy C1 and paste it into C2:C100, or just simply put your mouse
on the lower right corner of C1 and drag the cell down.


Elbowhite Wrote:
Hi there,

I'm new here so I don't know if this kind of a question was here before
;)
Here's the problem: On a worksheet I have two columns with about 100 or
even
more rows and in every filed there is a number (i.e. in A1 is typed
for
example 100, in A22 is typed 65983, in B3 is typed 456...) and in the
third
column (C) I have to make a product of the A and B field in the same
row
(i.e. if in A1 is a number such as 100, in B1 number 50, in the field
C1 has
to print 5000 with a function).

Is there a short way, a some kind of formula that makes a product of
two
fileds in the same row (A1, B1) and prints that product in the third
filed
(C1). It would realy help couse there are just too many rows for me to
type
in each one of the 'C' row =A1*B1 etc...

Thx

--
How does it sound when Darth Vader snores?!


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=398415