How to Calculate Percentage in Excel With a Shortcut

In Excel for Microsoft 365 on Windows, select the cells and press Ctrl+Shift+% to display their values as percentages; this shortcut formats numbers, but it does not calculate a percentage for you. To calculate a share, divide the part by the whole, then apply the shortcut to show the result as a percent. For example, a result of 0.15 displays as 15%.

Before using the shortcut, decide whether you need to calculate a percentage, display an existing decimal as a percentage, or calculate an amount such as a discount. These are related tasks, but the right formula is different for each one.

What You’ll Need

Excel for Microsoft 365 on Windows, or Excel for Mac or the web if you want to follow along there. Ribbon commands provide a fallback if a keyboard shortcut differs on your device.
A worksheet with the numbers you want to use. For a share calculation, you need both the part and the total; for a percentage increase, you need the starting and ending values.
A blank result cell, or a spare column for the calculation. Keep the original figures so you can check the result.

Step-by-Step

Choose the percentage task. If your result is already a decimal, such as 0.2, and you only want it to look like 20%, use the shortcut to format it. If you have a part and a total, calculate the share first. If you want to know how much a price changes or what a discount is worth, use a formula for that specific calculation. A percent format changes how a value is displayed, not the value used in calculations.

For example, typing 15% into a cell stores the numeric value 0.15. Typing 15 and then applying percentage format displays 1500%, because Excel interprets 15 as fifteen whole units, not 15 percent. Enter the percent sign when typing a percentage rate, or enter its decimal equivalent, such as 0.15.
Set up a simple part-of-total calculation. Put the part in B2 and the total in C2. For instance, enter 18 in B2 and 120 in C2. Select a different cell, such as D2, for the result. With the part in B2 and the total in C2, enter =B2/C2 in D2 and press Enter. The calculation is 18 divided by 120, which equals 0.15.

This division is the essential step: it converts the part into a fraction of the total. Make sure both figures refer to the same kind of quantity and time period. Comparing units sold with total units sold is meaningful; comparing units sold with revenue is not.
Apply Excel’s percentage shortcut. Select D2, or select the range of result cells you want to format. On Windows, press Ctrl+Shift+% (the percent character, commonly Shift+5 on a US keyboard). Excel applies Percentage format, usually with no decimal places, so 0.15 appears as 15%. The underlying value remains 0.15.

In Excel for Mac, Control+Shift+% works in many keyboard layouts. If your keyboard or Excel setup does not respond to it, select the cells and choose Home > Number > Percent Style. In Excel for the web, the ribbon command is also a dependable option because a browser can intercept some keyboard combinations. The ribbon changes the format, not the calculation.
Show more or fewer decimal places when needed. The shortcut normally rounds the display to a whole percent. If the exact rate matters, select the cell and use Home > Number > Increase Decimal or Decrease Decimal. The value in D2 is 15%, so one decimal place displays 15.0%. A value such as 1 divided by 6 is stored as approximately 0.1667; showing two decimal places displays 16.67%.

Displayed rounding does not usually change the stored result. If you need a rounded value for a particular business rule, that is a separate calculation decision. Do not assume that a display showing 17% means the underlying rate is exactly 17%.
Calculate a percentage increase or decrease. Put the starting value in A2 and the new value in B2. For example, use 50 in A2 and 65 in B2. With the original value in A2 and the new value in B2, enter =(B2-A2)/A2 in C2. The difference is 15, and 15 divided by 50 is 0.30, so the result is a 30% increase. Apply the percentage shortcut to C2 to display it as 30%.

If B2 is 40 instead, the same formula returns -0.20, which displays as -20%. A negative result means the new value is lower than the starting value. This formula uses the starting value as its comparison base, which is the usual meaning of percentage change.
Work out a percentage of an amount. Put the original amount in A2 and the rate in B2. For example, enter 80 in A2 and 15% in B2. With the amount in A2 and the percentage rate in B2, enter =A2*B2 in C2. The result is 12, because 80 multiplied by 0.15 equals 12. This gives the discount amount, tax amount, or other share of the original amount, depending on what the rate represents.

If you want the price after a 15% discount instead of the discount amount, with the original amount in A2 and the discount rate in B2, enter =A2*(1-B2) in C2. With 80 and 15%, the result is 68. Format the result as currency if it represents money; percentage format is for rates, not dollar amounts.
Fill the calculation down a column. Once the first result is correct, select its cell and drag the small fill handle at the lower-right corner down through the rows you need. Excel adjusts relative references for each row, so a formula referring to B2 and C2 will refer to B3 and C3 on the next row. Select the completed result range and press Ctrl+Shift+% to format all those results together.

Check at least one filled row against a hand calculation. If every row should use the same fixed total, make that reference absolute before filling; otherwise, Excel will move the total reference as it copies the formula. This prevents a common source of percentages that look plausible but are wrong.

Common Mistakes

Using the shortcut as if it performs division. Ctrl+Shift+% applies a number format. It cannot determine the part or total. Calculate the fraction first, then format its result.
Applying percentage format to a whole number. Formatting 15 as a percentage displays 1500%. Enter 15% or 0.15 if you mean fifteen percent.
Reversing the part and total. Dividing the total by the part can produce a large percentage that answers a different question. For a share, divide the part by the whole.
Using the wrong base for percentage change. Percentage change is measured against the original value. Dividing the difference by the new value gives a different rate.
Confusing a rate with an amount. A 15% discount rate is not the same thing as the dollar amount of the discount. Multiply the original amount by the rate to find the discount amount.
Overlooking a zero or blank denominator. A part divided by a total of zero has no defined percentage and can produce a #DIV/0! error. Confirm that the total is present and greater than zero.

Tips

Use descriptive column headings such as Part, Total, and Share. Clear labels make it easier to spot a reversed calculation.
Format a range before entering data if you know it will contain percentages. You can also enter a rate with a percent sign, such as 8%, and Excel will treat it as a percentage value.
Use the increase or decrease decimal buttons when whole-number display hides useful differences, such as 2.4% versus 2.6%.
Keep percentages and amounts in separate columns. A discount rate might be 15%, while the discount amount might be $12; each needs its own suitable number format.
For many rows, use an Excel Table or copy the formula down consistently. Then verify that each row refers to the intended inputs, especially when the denominator is meant to stay fixed.
Remember that Ctrl+Shift+% changes formatting only. You can remove or change the format later without rebuilding the formula.

Troubleshooting

The shortcut does nothing: Check that you are editing a cell rather than typing inside the formula bar, and that the intended cells are selected. On Windows, try Ctrl+Shift+% using the percent key for your keyboard layout. On a Mac, try Control+Shift+%; if it is unavailable or intercepted, use Home > Number > Percent Style. Excel for the web may also handle shortcuts differently depending on the browser, so use the ribbon there.

The result shows 1500% instead of 15%: The cell probably contains 15 rather than 0.15. Enter 15% or 0.15 if you mean a fifteen-percent rate. If the number 15 is intended to mean fifteen percentage points, divide it by 100 in your calculation or correct the input before applying the format.

The result is a decimal, not a percent: The calculation may be correct, but the cell is using General or Number format. Select the result and apply Percentage format. For example, 0.25 displayed as 0.25 becomes 25% when formatted as a percentage.

The result is unexpectedly above 100%: Check whether the part is larger than the total, whether the numerator and denominator are in the intended order, and whether you accidentally applied percentage format twice by changing the underlying value. A share can exceed 100% when the part genuinely exceeds the comparison total, so inspect the source data rather than forcing the display to a smaller number.

You see #DIV/0!: The denominator is zero or blank. Check the total cell and correct the source data. If a zero total is a legitimate possibility, decide how the report should represent that case, such as leaving the result blank or showing a note, instead of treating it as a normal percentage.

Frequently Asked Questions

Does Ctrl+Shift+% calculate a percentage?
No. It applies Percentage number format to selected cells. To calculate a share, divide the part by the total, then format the result. For example, 0.2 displays as 20% after the shortcut.

What is the shortcut for percentage format in Excel?
In Excel for Microsoft 365 on Windows, use Ctrl+Shift+%. On many Mac keyboard layouts, Control+Shift+% works too. If the shortcut is unavailable, use Home > Number > Percent Style.

How do I calculate what percent one number is of another?
Divide the first, smaller quantity by the comparison total, then format the result as a percentage. For example, 18 out of 120 is 0.15, or 15%. Check that the total is not zero.

How do I calculate a percentage increase in Excel?
Subtract the original value from the new value, then divide that difference by the original value. Format the result as a percentage. A positive result is an increase, while a negative result is a decrease.

Why does Excel show 0% when I expect a decimal percentage?
The percentage format may be showing no decimal places, so a small value rounds to 0% on screen. Select the cell and use Home > Number > Increase Decimal to show more precision. The underlying calculation may still be correct.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.