Check out "the difference between relative and absolute references" in
XL Help.

One way:

C1: =B1/B$11


In article ,
bvi wrote:

if cells b1-b10 have random #'s & are totaled in b11 & i put in the formula
in cell c1 of +b1/b11 to get the % of b1 of the total // how can i copy this
formula to c2-10 & make the 2nd half of the formula reference b11 only?