Set a custom sort order in a Google Sheets pivot table

To put pivot categories in a business order—such as High → Medium → Low—open Google Sheets on a computer and drag the row or column labels directly inside the pivot table. After you move a categorical header, Sheets shows Custom as the order for that field in the pivot table editor. You no longer need alphabetical prefixes just to arrange the pivot’s labels. Google’s customization guide documents this behavior.

Availability as of October 1, 2026: This feature is still rolling out. Rapid Release rollout began September 22; Scheduled Release rollout starts October 5. Both are gradual rollouts of up to 15 days. Google lists availability for all Workspace customers and personal Google accounts, so your account may not have it yet. Rollout announcement

Example: show priorities in their intended order

Use this small, fictional dataset to reproduce the workflow. Enter it in cells A1:B4:

Priority	Tickets
High	12
Medium	7
Low	19

The desired summary is High, Medium, Low—not alphabetical order and not largest ticket count first.

1. Select A1:B4, then choose Insert → Pivot table.
2. In the pivot table editor, add Priority under Rows.
3. Add Tickets under Values, and set its summarization to SUM.

Google’s pivot table setup instructions cover selecting a headed source range and adding row and value fields.

Now set the custom order:

1. In the pivot grid, drag the High row label to the first category position if it is not already there.
2. Drag Medium immediately below High, using the drop-position indicator. Low should follow.
3. Open the pivot table’s Edit control and check that the Priority field’s order reads Custom.
4. Confirm that the values still read 12, 7, 19, with a grand total of 38 if totals are shown.

Drag the category labels, not the numeric totals or the SUM of Tickets header. Google permits moving categorical headers but not dropping them into a value-header area. The same method works for categorical column labels. Manual reordering rules

Nested categories and multiple-item moves

If your pivot has several row fields, keep each move at the same hierarchical level. For example, with Region above Priority, you cannot drag a Priority item up to become a Region item. Google says moving a parent carries its nested child items with it and preserves the structure across expand and collapse actions. Hierarchy behavior

You can also select several category cells and drag them together. The destination must have enough space for the entire selected block; otherwise, the cells return to their original positions. Multi-cell move rules

To return to an ordinary sort, open Edit, find the field under Rows or Columns, and use Order and Sort by to choose a name-based or aggregated-value sort. Sorting controls let you choose between these approaches. Custom ordering is for a deliberate sequence; value sorting is better when the reader’s task is “show the largest total first.”

Check the order before sharing

Google says custom arrangements persist through data refreshes, filtering, layout adjustments and browser sessions. It also says custom pivot orders are retained when importing Excel workbooks and exporting them back to Excel. Persistence and Excel interoperability

Before sharing, check the categories and totals again—especially after adding a new category. A saved order does not replace checking that the pivot includes the intended source rows. If the source range needs attention, see how to change a pivot table’s data source. If you filter by values, also check the filter’s visible-item list: Google notes that new values may need to be enabled in the pivot filter settings.

For a public, sortable data table, make the sequence explicit in the publication copy:

sort_order	Priority	Tickets
1	High	12
2	Medium	7
3	Low	19

Document sort_order as “priority display sequence,” not a performance rank. This gives readers a field they can use to recover the intended order after sorting by ticket count. Publish only reviewed, non-sensitive data.

If drag-and-drop has not reached your account, a temporary workaround is to use labels such as 01 High, 02 Medium, and 03 Low in a separate source copy. In the pivot editor, set Sort by to Priority and Order to ascending. Keep the original category names intact for the final public dataset.