Custom sort a Google Sheets pivot table without renaming categories

To show workflow stages as New → In review → Complete, drag the category headers directly in your Google Sheets pivot table once the feature reaches your account. You no longer need to rename them with numeric prefixes just to avoid alphabetical order. After a manual move, the pivot table editor shows that category field’s order as Custom. Google’s instructions cover both row and column reordering.

Availability as of October 1, 2026: this feature is still rolling out. Google’s Rapid Release rollout began September 22; Scheduled Release begins October 5, with up to 15 days for feature visibility in each rollout. Google lists all Workspace customers and personal Google accounts as eligible, with no admin control. If dragging does not work yet, your account may not have received it. Google’s announcement

Build a small example

This hypothetical source table records ticket counts from four batches:

Status	Tickets
New	8
New	4
In review	7
Complete	21

On a computer:

1. Select the source data, including its headers.
2. Choose Insert → Pivot table.
3. In the pivot table editor, add Status under Rows.
4. Add Tickets under Values and summarize by SUM.

Google documents selecting a headed source range, inserting a pivot table, and adding row and value fields in its pivot-table setup guide. To include the grand total below, check Show totals under the row field. Totals and sorting controls

The desired result is:

Status	SUM of Tickets
New	12
In review	7
Complete	21
Grand Total	40

The sequence describes the workflow—not ticket volume or alphabetical order.

Drag the labels into custom order

Work inside the pivot table grid, rather than moving the source rows:

1. Drag the New category header to the first category position, using the drop-zone indicator.
2. Drag In review between New and Complete if necessary.
3. Open the pivot table’s Edit panel and confirm that the Status field’s order reads Custom.
4. Check that the counts remain 12, 7, and 21, with a grand total of 40.

For categories across columns, use the same method on their column headers. You can also select and drag several category cells together. Google notes that a selected block returns to its original position if there is not enough space at the destination. Manual reordering instructions

Two restrictions matter:

• Move categories only within the same hierarchy level. A parent category cannot become a child through dragging.
• Do not drag a category header into a value-header area; that does not reorder it.

When you move a parent category, its nested children move with it. Google says custom arrangements persist across browser sessions, data refreshes, filtering, and layout adjustments. Feature behavior and persistence

Choose automatic sorting when the order should change

Manual order is appropriate for fixed sequences such as workflow stages or reporting categories. For an alphabetical list or a ranking by totals, use the editor’s Rows or Columns → Order / Sort by controls instead. Sheets supports sorting by category names or aggregated values. Sorting controls

A custom presentation order should not be described as a performance ranking. In this example, Complete has the largest count but appears last because it is the final stage.

Preserve the meaning when sharing the result

Google says the update preserves custom pivot-table order when importing Excel workbooks and exporting them back to Excel. That is an ordering improvement, not a guarantee that every workbook feature transfers unchanged. Excel interoperability announcement

For a public data page, prepare a separate, reviewed summary table. Add an explicit display_order column—1 for New, 2 for In review, 3 for Complete—so the intended sequence is documented in the data, not just the spreadsheet layout. Keep the grand total separate from category records to avoid counting it twice in downstream analysis.

Before publishing, verify the source range, filters, category counts, and total. If new records are missing, check the pivot table’s data source. If you filter by values, also review the filter’s selected items: new values may need to be explicitly included. Google’s filtering notes

Publish only information cleared for public release, and label the sequence as workflow order so readers can distinguish it from a numeric ranking.