Now to convert them into percentage select the cells and press CTRLSHIFT. To calculate the percentage of a total in Excel execute the following steps. As with any formula in Excel you need to start by typing an equal sign in the cell where you want your result followed by the rest of the formula.
For a percent of total calculation think of a pie chart where each month is a slice and all the slices add up to 100.
Now to convert them into percentage select the cells and press CTRLSHIFT. Select the cell where you want to display the percentage. If you are using Excel for the web click Home Number Format Percentage. To calculate percent of a total ie.