Percentage of Multiple Rows

[Hugh]

I'm trying to copy a formula.

The worksheet has 10 rows of numbers and I want to find what percentage of
the total each row equals. As my starting formula, I've entered "=A1/A11"
I then copy the formula and paste it into rows 2-10. But what I end up with
are formulas reading "=A1/A12," "=A1/A13," "=A1/A14" and so on.

How do I keep the dividing number constant?

Thanks.

 

[JoeU2004]

How do I keep the dividing number constant?

Although I don't really understand what you are trying to do, try dividing
by $A$11 instead of A1.


----- original message ----

 

[Hugh]

That works. Thanks for your help.

Although I don't really understand what you are trying to do, try dividing
by $A$11 instead of A1.


----- original message ----