Now to calculate percentage of total write this Percentage formula in cell C4 and drag it down: =B4/$B$2. You will see fraction numbers. Now to convert them into percentage, select the cells and press CTRL+SHIFT+ (%). This is a shortcut to convert number into percentage. Same thing can be done form Number section of Home tab.
https://www.exceltip.com/mathematical-functions/calculate-percentage-of-total-in-excel.html



