tech on the net
Home About Us Feedback Site Map

Microsoft

Access Excel Word

Database

SQL Oracle / PLSQL SQL Server MySQL MariaDB PostgreSQL

Web Development

HTML CSS Color Picker

Language

C Language

More

ASCII Table Linux UNIX Java Clipart Joke of the Moment

Other Sites

CheckYourMath BigActivities DigMinecraft
Share this page:

MS Excel: Sort pivot table results in Excel 2010

See solution in other versions of Excel:

Question: How do I sort the pivot table results in Microsoft Excel 2010?

Answer: To sort the pivot table, select one of the values that you wish to sort. Then select the Options tab from the toolbar at the top of the screen. In the Sort group, you can click on one of the following buttons:

The Sort Smallest to Largest button Microsoft Excel sorts in ascending order, the Sort Largest to Smallest button Microsoft Excel sorts in descending order, and the Sort button allows you to choose more complex sorting options.

In this example we wanted to sort the Order ID values in ascending order, so we selected a value in column A and clicked on the Microsoft Excel button.

Microsoft Excel

Now when you view the pivot table, the Order ID values are sorted in ascending order.

Microsoft Excel