Back to School Sale -
20% off all courses with code BTS2019
Search for courses or lessons
Redeem a coupon
Start free trial
Suppose you’ve added a field containing numbers into the values area of a Pivot Table, but the display is not to your liking. Which is the best method to update the number format in the Pivot Table?
Go to the Pivot Table Tools Design Tab and set the format under the Report Layout button
Select the cells and format them from the Number group on the Home tab
Right click the column on the Pivot Table, select Value Field Settings and then Numbers, and choose your preferred format there
By default, Excel automatically adjusts column widths on a Pivot Table to fit the data. (This is to avoid seeing ### symbols when a number is too large to be displayed in the cell.) If you don’t want this to happen, how do you turn it off?
There is no way to turn it off
Right click the Pivot Table, choose Value Field Settings, and clear the “Autofit column widths on update” checkbox
Right click the Pivot Table, choose Pivot Table options, and clear the “Autofit column widths on update” checkbox
By default, Excel adds subtotals to Pivot Tables when value fields are added. How do you make subtotals appear at the bottom of the applicable groups?
Right click the label in the rows field on the Pivot Table and choose “Show all subtotals at bottom of group”
No actions are required, as sub-totals show up at the bottom of the group by default
Go to the Pivot Table Tools Design tab, and choose “Show all subtotals at bottom of group” from the Subtotals menu