To temporarily hide (and unhide) this pane, press +8. While the Subtotal feature is active, Excel displays a pane to the left that shows three viewing levels: To do so, click Subtotal in the Outline group and then click the Remove All button at the bottom of the resulting dialog box.
3: Remove subtotalsĮventually, you might want to remove the subtotaling rows and the levels pane to the left of the sheet. Specifically, sort by the column that contains the grouping value before you execute the Subtotal feature. 2: Always sort firstīecause the Subtotal feature evaluates groups, you must sort your data first. Otherwise, Excel will evaluate slightly different entries as separate groups, and the subtotals will be incorrect for your needs. For instance, you wouldn’t want to enter Baked Goods & Mixes, Baked Goods and Mixes, Baked Good & Mixes, and so on. Each group’s value must be the same across all records. The Subtotal feature evaluates groups, so in order for subtotaling functions to return the correct results, you must use consistent values. These 10 tips will help you get the most from the feature once you learn the basics. You can get the same results manually, but Subtotal is quicker. Then double-click the fill-down handle again.10+ tips for working with Excel’s Subtotal featureĮxcel's Subtotal feature can save you tons of time, especially if you know a few efficiency tricks.Įxcel’s Subtotal feature is geared for efficiency. To increase the amount by 25%, simply replace the + sign in the formula in cell D2 sign to a minus ( -): You get the results in all of the other cells without retyping or copying-and-pasting the formula. To copy the formula in cell D2 down the column, double-click the small square green box in the lower-right corner of cell D2. The result is multiplied by B2 to get a result of 56.25 for Week 1. The values inside the parentheses calculate first, so ther value of C2 is subtracted from 1, to give us 75%. In this formula, 1 is equivalent to 100%. Here's is a formula you could enter in cell D2 to accomplish this: In this example, we set column B to contain the amount currently spent, and column C is the percentage by which to reduce that amount. To calculate the amount, use a formula to subtract or add a percentage. Let's say you need to decrease-or want to increase-your weekly food expenditures by 25%. Note: If you need to find the percentage of a total or find the percentage of change between two numbers, you can learn more in the article Calculate percentages.
0 kommentar(er)
