To see a sort of the grand totals for products-from largest to smallest-choose any number in the Grand Total column, and sort on it. In the example shown below, the data under the category level (Helmet, Travel bag) has an alphabetical sort from A to Z. The sort order applies to all the cells at the same level in the column that contains the cell. You can sort on individual values or on subtotals by right-clicking a cell, choosing Sort, and then choosing a sort method. Sort on a column that doesn't have an arrow button Text entries will sort in alphabetical order, numbers will sort from smallest to largest (or vice versa), and dates or times will sort from oldest to newest (or vice versa). To sort data in ascending or descending order, click Sort A to Z or Sort Z to A. In a PivotTable, click the small arrow next to Row Labels and Column Labels cells.Ĭlick a field in the row or column you want to sort.Ĭlick the arrow on Row Labels or Column Labels, and then click the sort option you want. Follow these steps to sort in Excel Desktop: