Question: how to calculate percentage of total revenue in excel?
Answer: Select a cell next to the first revenue cell.
Type an equals sign. ... 
Type the forward slash (/) sign. ... 
Press the F4 key. ... 
Press Ctrl+Enter to enter the formula and stay in the current cell. ... 
To use the format 9.2% (that is, one decimal place) instead of 9%, choose the Increase Decimal icon.