How to convert data in Excel to percentages of total?

Question

Is there a quick way to convert all cell values in a table to a percentage of a total listed in a separate column? I tried posting an image of my data as an example, but my reputation here isn't strong enough!

Solution

Sounds like a job for pivot table!

Select the range and go to Insert - Pivot Table

For row labels, have whatever your rows are.

In the values field place your numbers, click the drop down and go to value field settings.

Now show value as and select % of total in the drop-down.

Now they are summarized by percentage of total!

click for full size image

Comments

[MikeFallopian]

It won't let me add the picture as I need a '10 reputation!

[Dave]

Try adding it now! :)