anyone know in excell how to refer to a specific cell when you paste a function.

Say If i Have a total in A11, then for b1-9 i want to find the percentage by dividing the cells b1-b9 by the total in A11

So far I have =b1/a11

etc.

but as soon as I copy the formula in each cell down past b2 it referes to a12, a13 etc, i want it to stick with a11 the whole time but change the values of B

 

good ol excell.... i used to be pretty good with it.... its all in the formulas

 

done! if you need anymore help like i said feel free to ask...

 

crap I forget ow to make a value static when your move it ... and thats a simple thing to do .... ohhh well must be because I never use forulas anymore

 

$a$11 is the way to make it stick