To calculate % of Totals in Excel, you would normally have to use absolute cell references or name the Total cell. Similarly for cumulative totals, you would have to create the relevant formula. Provided you have Excel 2013 or a later version than that, you can save the effort of using formulas by using the Quick Analysis tool.
Ensure you have a spare column next to the data for the answers to be inserted. You do not need to have created the total.
Select the data to be used.
Click on Totals along the top of the Quick Analysis section. Further buttons will be shown. The first group are for doing calculations across rows. We are looking at columns here so scroll to the right.
Find out more about our Excel training in the London area.
Find out more about our Excel training in Wiltshire, Dorset, Somerset and Hampshire.
Find out more about our online training.