How do I make a formula work for all the cells in a column?

[Janelle]

Hi,

How do I make a formula work for an entire column without having to input
each row, one at a time? Each cell in the column would be calculating from
another columns entry. I currently am inputting it like this.....

D1: =SUM(C1)-1
D2: =SUM(C2)-1
D3: =SUM(C3)-1

Is there a way for me to set the formula for the entire column eventhough it
has to reference a new cell from another column each time (as in the example
above)?

Any help would be greatly appreciated!!! =)

 

[Lars-Åke Aspelin]

Hi,

How do I make a formula work for an entire column without having to input
each row, one at a time? Each cell in the column would be calculating from
another columns entry. I currently am inputting it like this.....

D1: =SUM(C1)-1
D2: =SUM(C2)-1
D3: =SUM(C3)-1

Is there a way for me to set the formula for the entire column eventhough it
has to reference a new cell from another column each time (as in the example
above)?

Any help would be greatly appreciated!!! =)

Just put the formula in cell D1.
Then double click on the little square handle in the lower right
corner of cell D1.
The formula will automagically be filled down column D as far as you
have data in column C.
You can also "click and hold" this handle and then drag it down as far
as you need before you "unclick" it.

Hope this helps / Lars-Åke

 

[Bob Phillips]

Just enter it in D1, then move the cursor towards the bottom right corner of
the cell until it changes to a black cross. Then, whilst holding down the
left-mouse button, drag and copy the formula down as far as required.

HTH

Bob

 

[Leah]

Hi,

How do I make a formula work for an entire column without having to input
each row, one at a time? Each cell in the column would be calculating from
another columns entry. I currently am inputting it like this.....

D1: =SUM(C1)-1
D2: =SUM(C2)-1
D3: =SUM(C3)-1

Is there a way for me to set the formula for the entire column eventhough it
has to reference a new cell from another column each time (as in the example
above)?

Any help would be greatly appreciated!!! =)

If you look at the active cell you should see a little square in the outline
on the bottom right corner of the cell. If you hover over the square your
cursor will change to a little cross. You can click that box and drag it
down the entire column/row. The formula will copy over and the cells will be
updated like you want.

 

[Gord Dibben]

You have fill handle answers in other replies.

Just to make your life a little easier.......

=SUM(C1)-1 can be written =C1-1

SUM is used when multiple cells are to be summed.

i.e. =SUM(C1:C10) or =SUM(C1,C4,C6,C8,C10)


Gord Dibben MS Excel MVP