apply formula to colum

[frustrated]

How do I apply a formula to the whole column. The formula works great but I have to enter it into each cell in the k column
{should be done by next xmas}

Cell I3(cost) Cell K3(mark up30%)
" I4 " " K4 " "
Formula =I:I*33.33%+I:I

Any help would be greatly appreciated Thanks

 

[Chris Davison]

not sure if this is what you mean, but you can enter it once, then highlight your entire range you want it entered into (including the original), hit F2 then hit CNTRL and ENTER : it should pop the formula into each cell in one go

 

[Aladin Akyurek]

On 2002-09-15 05:14, frustrated wrote:
How do I apply a formula to the whole column. The formula works great but I have to enter it into each cell in the k column
{should be done by next xmas}

Cell I3(cost) Cell K3(mark up30%)
" I4 " " K4 " "
Formula =I:I*33.33%+I:I

Any help would be greatly appreciated Thanks

In K3 enter:

=I3*33.33%+I3

Double click on the Fill Handle (little black square) in the lower right corner of K3 in order to drag down the formula.

 

[frustrated]

Hey that little handle thing works pretty good Thanks to you both I've been trying to figure that since yesterday morning thanks again