Back to lesson
1. Assume that you’ve added a field containing numbers into the values area of a PivotTable, and the display is not to your liking. What is the best way to update the number format on the PivotTable?
Go to the PivotTable Tools Design Tab, and set the format under the Report Layout button
Right click the column on the PivotTable, choose Field Settings > Numbers, and choose your format there.
Select the cells and format them from the Number group on the Home tab
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.) If you don’t want this to happen, how do you turn it off?
Right click the PivotTable, choose Field Settings, and clear the “Autofit column widths on update” checkbox
Right click the PivotTable, choose PivotTable options > Layout and clear the “Autofit column widths on update” checkbox
There is no way currently to do this.
3. By default, Excel adds subtotals to PivotTables when value fields are added. To show subtotals at the bottom of the applicable groups, what actions need to be taken?
Right click the label in the rows field on the PivotTable and choose “Show all subtotals at bottom of group”
Go to the PivotTable Design tab, and choose “Show all subtotals at bottom of group” from the Subtotals menu
None; they show up at the bottom of the group by default.
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement