Excel Percentages

[patrickstar]

In Excel how can I work the percentage of cell B of cell A in numerous rows that have differing values?

For examplem, in row 1 I know to enter in C1 '=B1/A1' for the percentage but can this be repeated for numerous rows where the value in Column A and B differ all the way down?

For whatever reason I cannot work it out without the same % figure in column C1 repeating all the way down.

Hope that makes sense! Thank you

[ToraToraTora]

can you try starting a new file entirely and copy the what I have in the picture above, does that work?

[patrickstar]

Will check for auto-update Old-Geezer but be surprised if that was it but well could be.
The numbers are all different ToraToraTora by sum margin so should get anything from 100% to 0% and everything in-between.
Maybe the cardboard roll should be swapped with my fore-head?

[New Judge]

Have you tried typing manually in C1 =B1/A1

Then in C2 typing =B2/A2

Try that to see if C1 and C2 produce different results.

[patrickstar]

Great idea ToraToraTora. Have just tried that and the number 50 appeared in all three rows!
New judge, if I type the formula individually per cell then the equation works! Problem is I have a vast amount to convert so this would be restrictive but may need to be used as a fallback.
Again continued and sincere thanks.

[New Judge]

Try this, then. On the top of the page where you see "File Home Insert..." towards the right you will see "Formulas". Click this. Then over on the right you should see "Calculation Options". Click that and you should get a dropdown with "Automatic; Automatic except for data tables; Manual". Make sur Automatic is ticked.

[ToraToraTora]

14:15 ok but does C2 have the correct formula in it, A2/B2*100 ?

[ToraToraTora]

when you drag the C1 cell by the bottom right corner does the pointer change to a larger than normal + sign?

[patrickstar]

New judge, you are a star. That was the issue. Thank you so much.

And a massive thank you to all that assisted me today. You have all helped me. Have a great rest of the day and a sincere thank you again. I best apologise to my keyboard and the cardboard roll now! :-)

[ToraToraTora]

best award the BA to the judge! So it was a settings issue, amazing I can;t imagine why you would not want this option but I suspect the default is not!

[Old_Geezer]

:-)

[New Judge]

The default is usually automatic. In my experience you would only use manual when you have a large spreadsheet with multiple formulae. Making a new entry with "automatic" set may mean quite a delay for recalculation to take place. If you're making a large number of new entries it may be a bit time consuming. It's also not quite so critical these days when machines are a lot faster. But I can remember it being an issue some years back when processors were not so efficient.

[THECORBYLOON]

I have had the autofill function just stop before. I wasn't even aware it could be turnt off and I cannot see a reason for having that option.

[New Judge]

As above, Corby.

I can recall twenty years or more ago when I had a very large spreadsheet, when making new entries the recalculation would take quite a few seconds (the entire spreadsheet is recalculated, not just the formulae affected by the new entries). This could be very time consuming if you had a large number of new entries to make. More than that, if you did an automatic import of new data it could on occasions cause the entire spreadsheet to lock up. The answer was to set the calculation to manual and then do a recalculation after all the new entries had been made.