Back to lesson
1. Suppose you’ve added a field containing numbers into the values area of a PivotTable, but the display is not to your liking. Which is the best method to update the number format in the PivotTable?
Select the cells and format them from the Number group on the Home tab.
Right click the column on the PivotTable, select Value Field Settings and then Numbers, and choose your preferred format there.
Go to the PivotTable Tools Design Tab and set the format under the Report Layout button.
2. By default, Excel automatically adjusts column widths on a PivotTable 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 PivotTable, choose PivotTable options, and clear the “Autofit column widths on update” checkbox.
Right click the PivotTable, choose Value Field Settings, and clear the “Autofit column widths on update” checkbox.
3. By default, Excel adds subtotals to PivotTables 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 PivotTable and choose “Show all subtotals at bottom of group”.
Go to the PivotTable Tools Design tab, and choose “Show all subtotals at bottom of group” from the Subtotals menu.
No actions are required, as sub-totals show up at the bottom of the group by default.
Back to the top
© 2018 GoSkills Ltd.
Skills for career advancement