Search for courses or lessons
Redeem a coupon
Start free trial
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?
Right click the column on the PivotTable, choose Field Settings > Numbers, and choose your format there.
Go to the PivotTable 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
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?
There is no way currently to do this.
Right click the PivotTable, choose PivotTable options > Layout and clear the “Autofit column widths on update” checkbox
Right click the PivotTable, choose Field Settings, and clear the “Autofit column widths on update” checkbox
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?
None; they show up at the bottom of the group by default.
Go to the PivotTable Design tab, and choose “Show all subtotals at bottom of group” from the Subtotals menu
Right click the label in the rows field on the PivotTable and choose “Show all subtotals at bottom of group”
Back to the top
© 2019 GoSkills Ltd.
Skills for career advancement