What is the easiest way to muliply numbers in Excel

M

ManhattanRebel

What is the easiest way to multiply numbers in excel and how can I make the
calculations repeat the process for numerous rows with different numbers to
be calculated?
 
D

David Biddulph

If you want to multiply A2 and B2, use the formula =A2*B2. If you want to
do the same on each row, copy the formula down as far as you need it.
 
M

ManhattanRebel

Thank you..I know how to multiply cells now but how can I copy fomula and
apply it to other rows?
 
D

David Biddulph

Method 1. Select the cell with the formula. Copy. Select the rest of the
Range. Paste.
Method 2. Select the bottom right hand corner of the cell with the formula
and the cursor turns into a square fill handle. Drag that fill handl;e down
the rest of the range.
Method 3. If your multiplication formula is in a cell adjacent to a range
of data (if it is in cell A2 in this case), double-clicking on the fill
handle (see method 2 above) will automatically fill the formula down as many
rows as you have contiguous data in the adjacent column.

If you are struggling with Excel basics, you may need to take a basic Excel
training course or tutorials, read a book on introduction to Excel, and/ or
use the newsgroup: microsoft.public.excel.newusers.
 
M

ManhattanRebel

Thank you.. With your initial help, i figured out how to apply the formula to
other rows before you could reply again.
 
Top