Excel Pivot Table Manual Sort: Drag Items into Order

Charts & pivot tables · Updated November 18, 2026

To manually sort items in an Excel PivotTable, right-click an item label, choose Sort > More Sort Options, select Manual, and click OK; then drag the label to its desired position. You can also drag items directly when manual sorting is available. This changes the order shown in the PivotTable, not the order of the source data.

What manual sorting changes

A PivotTable groups records into fields, such as Region, Product, or Month. Excel normally arranges the items in a field alphabetically, numerically, or according to another active sort. Manual sorting lets you set a custom order instead. For example, you could place the regions West, Central, and East in that order even if an alphabetical sort would put Central first.

The change applies to the field items inside the PivotTable. It does not rearrange rows in the original worksheet table, alter the underlying values, or create a new sort order for every PivotTable in the workbook. If you have several PivotTables, set the order in each one where you need it.

This is useful when the order has meaning that Excel cannot infer from the labels: sales stages such as Lead, Qualified, Proposal, Closed; a custom product priority; or a presentation sequence that differs from alphabetical order. If ordinary A-to-Z or largest-to-smallest ordering is what you want, use the standard sort instead.

How to drag PivotTable items on Windows

  1. Click a cell inside the PivotTable and identify the field whose items you want to reorder. The items to drag are the row or column labels, not the field headings or numbers in the Values area.
  2. If needed, right-click an item label and choose Sort > More Sort Options. In the dialog, choose Manual and select OK. The wording and available choices can vary with the kind of PivotTable and its data source.
  3. Point to the border of the item label you want to move. When the pointer changes to a four-headed arrow, hold the left mouse button and drag the item to the intended position. Watch the insertion line or destination indicator, then release the button.
  4. Check the surrounding labels and the values beside them. Confirm that the item landed in the right place and that its values remain associated with the correct label.

For example, suppose a report lists Basic, Standard, and Premium alphabetically, but the business wants Standard, Basic, Premium. Set the field to Manual, then drag Standard above Basic. The associated totals move with their item; you are reordering the PivotTable item, not moving an isolated number.

Dragging works within the same field. It is not a way to move a product into a different region or change which source records belong to a category. Those relationships come from the source data and the PivotTable layout.

Set and verify the manual sort mode

Manual order can be confusing if Excel continues to apply an automatic sort. Right-click an item in the relevant field and open Sort > More Sort Options to inspect the setting. Choose Manual when you want to control the sequence by dragging. If the dialog is unavailable, the field may be governed by the data source, a special PivotTable layout, or a sort condition that does not allow the operation.

For a value-based order, such as ranking product names by total revenue, use the PivotTable sort commands rather than dragging labels as your main method. Right-click an item and look for Sort options, or use the sort controls associated with the row or column field. Choose the value field and direction that match the intended ranking. Sorting by a measure is different from creating a fixed custom sequence: a refresh can change the ranking as values change, while a manual sequence expresses a chosen order.

Be careful when the PivotTable has several row fields. A label may be nested under a parent category, and dragging it can affect only its position within that group. For example, a product can be reordered among products in its category, but dragging it does not make it a member of another category. To change grouping, edit the source data or the field arrangement instead.

Choosing between manual, alphabetical, and value sorting

Choose the sort method based on why the order matters. A-to-Z sorting is suitable for lookup and scanning. Largest to Smallest is useful for ranking by a value such as revenue or quantity. Manual sorting is appropriate when the display order is editorial, operational, or based on a known sequence that is not captured by the item names or values.

  • Use alphabetical sorting for customer names, locations, or categories where readers expect a neutral, predictable order.
  • Use value sorting when the report should rank items according to a measure, such as units sold or total cost.
  • Use manual sorting for a purposeful sequence, such as risk levels ordered Low, Medium, High, or workflow stages ordered by process.
  • Use a custom list when the same recurring sequence should be recognized by Excel across multiple sorts or reports. Custom lists are a separate Excel feature and are not the same thing as dragging items in one PivotTable.

Manual sorting can be less convenient when the item list changes often. If a new status or category appears regularly, maintain a deliberate order in the source data or use a stable sort key where the reporting design allows it. That gives the sequence a documented rule rather than relying solely on the position of items in a report.

What happens after a PivotTable refresh

A refresh updates a PivotTable from its source, so it is sensible to review a manually ordered field afterward. Existing items often retain their manually chosen positions, but newly appearing items have no position you deliberately assigned. Their placement can depend on the PivotTable and its settings, so do not assume that a refreshed report will automatically match a new business sequence.

To refresh, click inside the PivotTable and use PivotTable Analyze > Refresh in Excel for Microsoft 365 on Windows. To update all PivotTables and connections in the workbook, use Data > Refresh All. Afterward, check for new items, removed items, and unexpected changes to the sequence. If the order is part of a published report, refresh and review it before sharing.

Refreshing does not normally rewrite the source table to match the PivotTable display. If you need the source records themselves in a particular order, sort the source data separately, taking care to sort complete rows and preserve the relationships between columns.

Common reasons dragging does not work

  • You are dragging the wrong area. Drag a row or column item label, not a number in the Values area, a field button, or the worksheet row or column heading.
  • The field is still automatically sorted. Check Sort > More Sort Options and select Manual if that option is available.
  • The pointer is not on the label border. Clicking the middle of a cell selects it; it may not start a move. Pause at the cell edge and look for the four-headed arrow before dragging.
  • The field is nested. A child item can only be reordered in its relevant group. It cannot be dragged across a parent boundary to change its category.
  • The PivotTable uses a restricted source. PivotTables based on an external OLAP source or the Data Model can have sorting controlled by that source. Manual sorting may be missing or behave differently.
  • The report is protected or the layout is constrained. Worksheet protection, shared editing conditions, or a particular PivotTable structure can prevent a drag. Check whether you can edit the sheet and whether the field offers manual sorting.

If the drag handle never appears, try the manual-sort dialog first and confirm that the selected cell is an item label. If the field comes from an external or model-based source, check its available sort controls or open the workbook in desktop Excel if you are using Excel for the web. Interface capabilities can differ by platform and source type.

Mac and Excel for the web

On Excel for Microsoft 365 for Mac, the PivotTable concepts are the same: select an item label, use the available sort controls, and try dragging within the same field. Ribbon placement and context-menu wording can differ from Windows, so look for the PivotTable sorting commands after selecting the PivotTable. A Mac trackpad may make precise dragging harder; using a mouse or the available sort dialog can be easier.

Excel for the web has a different interface and may not expose every desktop sorting option for every PivotTable source. If you cannot select Manual or drag an item, open the workbook in the desktop app and make the change there. If the workbook is shared, save the change and confirm that the order appears as expected after it is reopened.

Manual sorting versus changing the source order

These two actions solve different problems. Dragging a label changes the order of items in a PivotTable report. Sorting the source table changes the arrangement of records in the source worksheet. The PivotTable may still apply its own item sort, so sorting source rows alone is not a dependable way to define the visible category sequence.

If a custom sequence must be repeatable across several reports, consider adding a numeric order field to the source table. For instance, assign workflow stages a sequence number and use that field as part of the report design. This is more maintainable than asking each reader to drag items, but it requires planning the source structure and may need a separate display label. For a one-off report or a small stable list, manual dragging is often quicker.

Do not confuse manual sorting with grouping. Grouping combines items into broader categories, such as dates by month or numeric values into ranges. Sorting only changes their order. If your goal is to show several products under a new heading, rearranging labels will not create that group; use the PivotTable grouping features or change the source categories.

Frequently Asked Questions

Can I manually sort PivotTable items by dragging?

Yes, for a field that allows manual sorting. Set the field to Manual if necessary, then drag a row or column item label to a new position. Drag within the same field and confirm that the pointer indicates a move before releasing the mouse.

Why can’t I drag a row label in my PivotTable?

The field may be automatically sorted, the selected cell may not be an item label, or the PivotTable source may restrict manual sorting. Check Sort > More Sort Options, try the label border, and consider whether the PivotTable uses an external OLAP source or the Data Model.

Does manual sorting change my source data?

No. It changes the displayed order of items in that PivotTable. The original rows and their order remain unchanged. Sort the source table separately if you also need to rearrange its records.

Will my custom order remain after refreshing?

Existing items often keep their manual positions, but refreshes can introduce new items or other changes. Review the field after refreshing and place new items where they belong rather than relying on an assumed position.

Can I sort a PivotTable by sales and still use a manual order?

You can choose a value-based sort when you want items ranked by sales, but that is a different rule from a fixed manual sequence. Decide whether the report should follow changing sales totals or a chosen category order, then apply the sort that expresses that purpose.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.