repeating a function down a column

  • Thread starter Thread starter Dave Wray
  • Start date Start date
D

Dave Wray

I am trying to make a spreadsheet where I am trying to have the same
function down a column without having to write the formula in each cell
so I am looking for a way to repeat it. For example:

cell B1 mult by C1 equal D1 so I would put the function in the cell D1
however, I want the same formula in the whole D column. How can I just
write it in D1 and have it apply to D2, D3 D4 etc?

Thanks
Dave
 
In D1 type =B1*C1 and hit enter.

Now copy cell D1, select D2 as far down as you want to go and hit Edit / Paste.

The formulas will all be relative, eg:-

=B1*C1
=B2*C2
=B3*C3
=B4*C4 etc
 
Put the formula in D1, move the cursor to the bottom-right corner of the
cell until it changes to a black cross, then while holding the left mouse
button down, drag the cursor down the column.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top