• Excel Book Excerpt

# Excel Calculate a Percentage of Total

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

Calculate a Percentage of Total

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.