Search for courses or lessons
Redeem a coupon
Start free trial
When you drag a row field on to a PivotTable, it will sort in what order by default?
The order the data first appears in the data set.
Descending order from highest letter/number at the top, to lowest letter/number at the bottom.
Ascending order from lowest letter/number at the top, to highest letter/number at the bottom.
You have two major product groups on your PivotTable: Food and Alcohol. Unhappy with Food showing up at the bottom, you manually drag it to the top of the PivotTable so it shows as below. Now the accountant adds a new major product group called “Sundries” to the source data. What will happen when you update the PivotTable?
Because you have manually overridden the sort order it will not re-sort and the new group will be added at the end of the PivotTable after the Alcohol group.
Because there is new data the sort order will revert to Ascending, and the items will be displayed from top to bottom as Alcohol, Food, Sundries.
Because you have changed the sort order to Descending, it will add the Sundries group above the Food category.
Assuming you have the PivotTable shown below. You right click cell B2 and choose to Sort by Z-A (Descending). What would happen?
Nothing would change, as the table is already arranged in that order.
The rows will resort to show the values in order from the largest number at the top to the smallest at the bottom, as per the numbers in the Jan column.
The columns would re-arrange to be displayed in the following order: Feb, Jan, Grand Total.
Back to the top
© 2019 GoSkills Ltd.
Skills for career advancement