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

On Thu, 4 Feb 2010 13:43:02 -0800, Janelle
wrote:

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!!! =)