Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How to Calculate Percentages Automatically in Excel

Date:2019-7-12 Author:Cordelia

It’s very frequent at work to make a sheet involving percentages of different departments in the whole company. Calculating percentages with a calculator surely won’t take a lot of your time. But if there’re piles of data to deal with in a short time, can you accomplish it efficiently without any mistake? If not, it’s about time to let Excel take over your work.

I create a table about the quantity of sale as below. The first thing we need to do is calculating the total amount of all these departments.

How to Calculate Percentages Automatically in Excel

Select the cell B22 and then click the “fx” icon above the sheet. Choose SUM in the list of Select a function. Hit OK.

How to Calculate Percentages Automatically in Excel

Confirm the range of cells for calculating. “B2:B21” refers to all the cells from B2 to B21 in column B.

How to Calculate Percentages Automatically in Excel

Now the total amount has been worked out.

How to Calculate Percentages Automatically in Excel

Then click C2 and input the formula “=B2/$B$22“. B22 refers to the value in the B22, which is also the total amount of sales volume. And the symbol “$” makes it a fixed value. It won’t change even when we apply this formula to other cells.

How to Calculate Percentages Automatically in Excel

Press Enter key to work it out. Then put the cursor at the right lower corner of the cell till it becomes a small black cross. Drag it to select all the cells you want to calculate the percentage in, then the formula will be applied to all of them at a time.

How to Calculate Percentages Automatically in Excel

Release the mouse, you can check the result now.

How to Calculate Percentages Automatically in Excel

If you want them to show as percentages instead of decimal fractions, just select all these cells and click the “ icon in Home tab.

How to Calculate Percentages Automatically in Excel

The results will change into percentages immediately.

How to Calculate Percentages Automatically in Excel

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *