formula for entire colum

[sigfreund]

Sorry to have to ask such a basic question, but how do I apply a formula to an entire colum? I want c3=c2+a3-b3, c4=c3+a4-b4, c5=c4+a5-b5, . . .
From what I read, any formula used 3 out of the last 5 times is suppose to continue. I checked the options and the correct options are checked in the edit pane.

[CLR]

If you double-click on the little black square in the lower right hand corner
of your bottommost cell with the formula in it, it will copy itself down
column C as far as you have data in column B........

Vaya con Dios,
Chuck, CABGx3



"sigfreund" wrote:

>
> Sorry to have to ask such a basic question, but how do I apply a formula
> to an entire colum? I want c3=c2+a3-b3, c4=c3+a4-b4, c5=c4+a5-b5, . .
> .
> From what I read, any formula used 3 out of the last 5 times is suppose
> to continue. I checked the options and the correct options are checked
> in the edit pane.
>
>
> --
> sigfreund
> ------------------------------------------------------------------------
> sigfreund's Profile: http://www.excelforum.com/member.php...o&userid=32096
> View this thread: http://www.excelforum.com/showthread...hreadid=518794
>
>

[Dave Peterson]

Type the formula in the top cell of the range you want (C3?).

Then use one of the techniques from Debra Dalgleish's site to fill the rest of
the column:

http://www.contextures.com/xlDataEntry01.html
(I like the mouse version for small number of rows.)

sigfreund wrote:
>
> Sorry to have to ask such a basic question, but how do I apply a formula
> to an entire colum? I want c3=c2+a3-b3, c4=c3+a4-b4, c5=c4+a5-b5, . .

--

Dave Peterson

[Bob Phillips]

Enter =C2+A3 in C3, then select C 3, and go to the bottom right until the
cursor changes to a dark cross, and drag it down the column.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"sigfreund" <[email protected]> wrote
in message news:[email protected]...
>
> Sorry to have to ask such a basic question, but how do I apply a formula
> to an entire colum? I want c3=c2+a3-b3, c4=c3+a4-b4, c5=c4+a5-b5, . .
> .
> From what I read, any formula used 3 out of the last 5 times is suppose
> to continue. I checked the options and the correct options are checked
> in the edit pane.
>
>
> --
> sigfreund
> ------------------------------------------------------------------------
> sigfreund's Profile:
http://www.excelforum.com/member.php...o&userid=32096
> View this thread: http://www.excelforum.com/showthread...hreadid=518794
>

[Dave O]

Land the cell pointer on C3 and click >Edit >Copy. Highlight cells C4,
C5, etc. and click >Edit >Paste. The cell references will change in
each cell as you paste.

[Doug Kanter]

"sigfreund" <[email protected]> wrote
in message news:[email protected]...
>
> Sorry to have to ask such a basic question, but how do I apply a formula
> to an entire colum? I want c3=c2+a3-b3, c4=c3+a4-b4, c5=c4+a5-b5, . .

Just copy & paste. Excel will increment the formula for each line.