Cell reference increments with paste function

[blloyd]

Assume a column of 10 random numbers with a total. To calculate th
percentage of the total the 1st number represents I simply divide th
1st number by the total and display the result in an adjacent cell
However, I cannot copy the formula into other cells. The diviso
(total) cell reference number increments by 1 for every paste function
What is the correct procedure for calculating these percentages

 

[icestationzbra]

anchor the cells using '$' sign, so that, when you drag or paste th
cells do not get incremented.

for example: ($A$1 *B1) would keep cell A1 constant even when B1 wil
change to B2 and so forth

 

[Frank Kabel]

Hi
have a look at absolute/relative refernces in the Excel
help. In your case you probably need something like
=A1/$A$10
and copy this down

 

[blloyd]

Excellent! Thanks so much