# Excel: Calculate a Percentage of Total

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Problem: I have a spreadsheet with sales by customer and a total at the bottom. I want to express each customer as a percentage of the total.

Strategy: Divide each row's sales by the total cell. Follow these steps:

1. Select a cell next to the first revenue cell.
2. Type an equals sign. Press the Left Arrow key.
3. Type the forward slash (/) sign. Press the Left Arrow key. Press Ctrl+Down Arrow key. Your cell pointer should now be on the total cell.
4. Press the F4 key. The formula bar should now show B2/\$B\$17.
5. Press Ctrl+Enter to enter the formula and stay in the current cell. Format the calculation as a percentage by using the % icon on the Home tab.
6. To use the format 9.2% (that is, one decimal place) instead of 9%, choose the Increase Decimal icon.
7. In cell C2, double-click the fill handle to copy the formula down to the other rows. 