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


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