Copying Formula thru Rows

  • Thread starter Thread starter b_tw
  • Start date Start date
B

b_tw

I have an excel worksheet that has Columns A-S and 100
rows.

I have put a formula in row "M" that states =K2*L2,
meaning that M = K*L (starting with Row 2 as row 1
contains the row name).

How do I get this formula to repeat thru all the rows ??

I'm sure there must be an easy way, but I haven't figured
it out.

Any help would be greatly appreciated.
 
Yes, use the Fill Handle see
http://www.mvps.org/dmcritchie/excel/fillhand.htm

Look at dragging the fill handle down and
Look at double-clicking the fill handle to copy down as long as
something is to the immediate left (if Col A to the immediate right)

Please read the above link, but the following my be faster since
controlling the cursor can get tricky going past the screen bottom.

You mean Column M (not row M), I know you know the
difference because you want to propagate down the rows.

With your formula in M2 and as the active cell,
In the Name Box to the left of the formula bar enter
M2:M100 then use Ctrl+D

You should learn all of the above techniques.
 
Back
Top