Share via

Pivot Table Sort by second row label

Anonymous
2014-05-16T23:06:15+00:00

EXCEL 2010 Windows 7

I have a very simple pivot table with two row labels - number and name. the "values" are points.

Column A is number, column B has name, and column C has the sum of points.

How can I sort the pivot table by column B (Name)?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2014-05-17T03:38:06+00:00

    Here is how you can get the results:

    Place your cursor on Col. B data wherever Names are. Goto Home ribbon>Editing>Sort it in either way.

    Alternatively, you can Sort from Pivots settings.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments